APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on AP_SUPPLIER_SITES_ALL

Line 676: FROM ap_supplier_sites_all asa,

672: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
673:
674: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
675: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
676: FROM ap_supplier_sites_all asa,
677: ap_supplier_sites_all asa2,
678: mtl_system_items_interface msii
679: WHERE asa.party_site_id = asa2.party_site_id
680: AND asa.vendor_id = EIUAI.pk1_value

Line 677: ap_supplier_sites_all asa2,

673:
674: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
675: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
676: FROM ap_supplier_sites_all asa,
677: ap_supplier_sites_all asa2,
678: mtl_system_items_interface msii
679: WHERE asa.party_site_id = asa2.party_site_id
680: AND asa.vendor_id = EIUAI.pk1_value
681: AND asa2.vendor_site_id = EIUAI.pk2_value

Line 694: FROM ap_supplier_sites_all asa,

690: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
691:
692: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
693: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
694: FROM ap_supplier_sites_all asa,
695: ap_supplier_sites_all asa2,
696: mtl_system_items_interface msii
697: WHERE asa.party_site_id = asa2.party_site_id
698: AND asa.vendor_id = EIAI.pk1_value

Line 695: ap_supplier_sites_all asa2,

691:
692: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
693: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
694: FROM ap_supplier_sites_all asa,
695: ap_supplier_sites_all asa2,
696: mtl_system_items_interface msii
697: WHERE asa.party_site_id = asa2.party_site_id
698: AND asa.vendor_id = EIAI.pk1_value
699: AND asa2.vendor_site_id = EIAI.pk2_value

Line 712: FROM ap_supplier_sites_all asa,

708: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
709:
710: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
711: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
712: FROM ap_supplier_sites_all asa,
713: ap_supplier_sites_all asa2,
714: mtl_system_items_interface msii
715: WHERE asa.party_site_id = asa2.party_site_id
716: AND asa.vendor_id = EIUAI.pk1_value

Line 713: ap_supplier_sites_all asa2,

709:
710: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
711: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
712: FROM ap_supplier_sites_all asa,
713: ap_supplier_sites_all asa2,
714: mtl_system_items_interface msii
715: WHERE asa.party_site_id = asa2.party_site_id
716: AND asa.vendor_id = EIUAI.pk1_value
717: AND asa2.vendor_site_id = EIUAI.pk2_value

Line 730: FROM ap_supplier_sites_all asa,

726: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
727:
728: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
729: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
730: FROM ap_supplier_sites_all asa,
731: ap_supplier_sites_all asa2,
732: mtl_system_items_interface msii
733: WHERE asa.party_site_id = asa2.party_site_id
734: AND asa.vendor_id = EIAI.pk1_value

Line 731: ap_supplier_sites_all asa2,

727:
728: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
729: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
730: FROM ap_supplier_sites_all asa,
731: ap_supplier_sites_all asa2,
732: mtl_system_items_interface msii
733: WHERE asa.party_site_id = asa2.party_site_id
734: AND asa.vendor_id = EIAI.pk1_value
735: AND asa2.vendor_site_id = EIAI.pk2_value

Line 799: ap_supplier_sites_all asa,

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
803: AND aas.vendor_id = asa.vendor_id

Line 811: ap_supplier_sites_all asa,

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
815: AND aas.vendor_id = asa.vendor_id