DBA Data[Home] [Help]

APPS.POS_BULKLOAD_ENTITIES dependencies on AP_SUPPLIER_SITES_ALL

Line 238: AP_SUPPLIER_SITES_ALL SS,

234:
235: CURSOR c_supplier_site (c_party_id IN NUMBER, c_party_site_id IN NUMBER, c_vendor_site_code IN VARCHAR) IS
236: SELECT SS.Vendor_Site_ID
237: FROM AP_Suppliers AP,
238: AP_SUPPLIER_SITES_ALL SS,
239: HZ_PARTY_SITES PS
240: WHERE AP.Party_ID = PS.Party_ID
241: AND AP.Party_ID = c_Party_ID
242: AND PS.STATUS = 'A'

Line 361: AP_SUPPLIER_SITES_ALL SS,

357: CURSOR c_supplier_site (c_party_id IN NUMBER) IS
358: SELECT SS.Party_Site_ID,
359: SS.Vendor_Site_ID
360: FROM AP_Suppliers AP,
361: AP_SUPPLIER_SITES_ALL SS,
362: HZ_PARTY_SITES PS
363: WHERE AP.Party_ID = PS.Party_ID
364: AND AP.Party_ID = p_Party_ID
365: AND PS.STATUS = 'A'