DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 6640: FROM AP_SUPPLIER_SITES_ALL asa

6636: AND eiai.SUPPLIER_NUMBER IS NULL;
6637:
6638: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6639: SET PK2_VALUE = ( SELECT VENDOR_SITE_ID
6640: FROM AP_SUPPLIER_SITES_ALL asa
6641: WHERE asa.VENDOR_ID = eiai.PK1_VALUE
6642: AND asa.VENDOR_SITE_CODE = eiai.SUPPLIER_SITE_NAME
6643: AND asa.ORG_ID = FND_PROFILE.Value('ORG_ID')
6644: )