APPS.EGO_IMPORT_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 6724: FROM AP_SUPPLIER_SITES_ALL asa

6720: AND eiai.SUPPLIER_NUMBER IS NULL;
6721:
6722: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6723: SET PK2_VALUE = ( SELECT VENDOR_SITE_ID
6724: FROM AP_SUPPLIER_SITES_ALL asa
6725: WHERE asa.VENDOR_ID = eiai.PK1_VALUE
6726: AND asa.VENDOR_SITE_CODE = eiai.SUPPLIER_SITE_NAME
6727: AND asa.ORG_ID = FND_PROFILE.Value('ORG_ID')
6728: and nvl(asa.inactive_date,SYSDATE + 1) >SYSDATE --bug11072046