Supplier Site LOV on WEBADI
I am using the below API for supplier site LOV on WEBAdi for a specific OU in R12.2.4.
It is working fine , but the problem is that we want to have an LOV of the Operating Unit from which the users Logins.
BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV
(P_APPLICATION_ID => 101,
P_INTERFACE_CODE => 'AP_INVOICE_UPLOAD_XINTG',
P_INTERFACE_COL_NAME => 'P_VENDOR_SITE_CODE',
P_ID_COL => 'VENDOR_SITE_CODE',
P_MEAN_COL => 'VENDOR_SITE_CODE',
P_DESC_COL => 'VENDOR_SITE_CODE',
P_TABLE => 'AP_SUPPLIER_SITES_ALL',
P_ADDL_W_C => 'ORG_ID = 749 ',
P_WINDOW_CAPTION => 'SUPPLIER_SITE',