How to pass a parameter in the where Clause (LOV) dependent on another Attribute Name
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