APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on AP_SUPPLIERS

Line 798: FROM ap_suppliers aas,

794: IF X_EXT_SUP_TYPE = 'GLN' AND X_SUP_LEVEL = 'SUPPLIER'
795: THEN
796: SELECT asa.VENDOR_ID, aas.VENDOR_NAME
797: INTO X_SUPPLIER_ID, X_SUPPLIER_NAME
798: FROM ap_suppliers aas,
799: ap_supplier_sites_all asa,
800: hz_party_sites hps
801: WHERE hps.GLOBAL_LOCATION_NUMBER = X_EXT_SUP_ID
802: AND hps.party_site_id = asa.party_site_id

Line 810: FROM ap_suppliers aas,

806: ELSIF X_EXT_SUP_TYPE = 'GLN'
807: THEN
808: SELECT asa.VENDOR_SITE_ID, asa.VENDOR_SITE_CODE
809: INTO X_SUPPLIER_ID, X_SUPPLIER_NAME
810: FROM ap_suppliers aas,
811: ap_supplier_sites_all asa,
812: hz_party_sites hps
813: WHERE hps.GLOBAL_LOCATION_NUMBER = X_EXT_SUP_ID
814: AND hps.party_site_id = asa.party_site_id