Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to pass a parameter in the where Clause (LOV) dependent on another Attribute Name

edited Sep 4, 2017 5:01AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

I have made a Custom Integrator for AP Invoices. There are two fields which I want to sync and that is Supplier Name and Supplier Site. I have Created a table LOV for both but how can I pass a Vendor Name Parameter in Vendor Site Attribute name

Validation Type: Table

Group Name:

Id Column: b.VENDOR_SITE_ID

Meaning Column: b.VENDOR_SITE_CODE

Desc Column:

Validation Entity: ap_suppliers a, ap_supplier_sites_all b

Where Clause: a.VENDOR_ID = b.VENDOR_ID and b.ORG_ID = $PROFILE$.ORG_ID and a.VENDOR_NAME = ?

Component Name: Component for XX_INV_XINTG_INTF1.P_DISTRIBUTION_SET_NAME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center