APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on AP_SUPPLIER_SITES_ALL

Line 249: FROM ap_supplier_sites_all asa

245: AND eiai.supplier_number IS NULL
246: AND eiai.pk1_value IS NOT NULL;
247: UPDATE ego_item_associations_intf eiai
248: SET supplier_site_name = ( SELECT vendor_site_code
249: FROM ap_supplier_sites_all asa
250: WHERE asa.vendor_site_id = eiai.pk2_value
251: AND asa.org_id = fnd_profile.value('ORG_ID')
252: )
253: WHERE eiai.batch_id = p_batch_id

Line 364: FROM ap_supplier_sites_all assa

360: AND ( eiai.pk2_value IS NULL
361: OR NOT EXISTS
362: (
363: SELECT 1
364: FROM ap_supplier_sites_all assa
365: WHERE assa.vendor_site_id = eiai.pk2_value
366: --AND assa.vendor_id = eiai.vendor_id
367: AND assa.vendor_id = eiai.pk1_value
368: AND nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE --BUG 11072046

Line 617: FROM ap_supplier_sites_all assa

613: AND eiai.transaction_type = G_CREATE
614: AND NOT EXISTS
615: (
616: SELECT 1
617: FROM ap_supplier_sites_all assa
618: WHERE assa.vendor_id = eiai.pk1_value
619: AND assa.org_id = fnd_profile.value('ORG_ID')
620: AND nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE --BUG11072046
621: );

Line 1430: FROM ap_supplier_sites_all assa

1426: THEN supplier_site_name
1427: ELSE
1428: (
1429: SELECT vendor_site_code
1430: FROM ap_supplier_sites_all assa
1431: WHERE assa.vendor_site_id = eiai.pk2_value
1432: )
1433: END AS supplier_site_name,
1434: data_level_name

Line 1709: FROM ap_suppliers aas, ap_supplier_sites_all asa

1705: AND eiai.pk1_value IS NOT NULL;
1706: UPDATE ego_item_associations_intf eiai
1707: SET pk2_value = NVL(
1708: ( SELECT vendor_site_id
1709: FROM ap_suppliers aas, ap_supplier_sites_all asa
1710: WHERE aas.vendor_id = asa.vendor_id
1711: AND asa.vendor_site_code = eiai.supplier_site_name
1712: AND asa.vendor_id = eiai.pk1_value -- BUG 6322084
1713: AND asa.org_id = fnd_profile.value('ORG_ID')

Line 1723: FROM ap_supplier_sites_all asa

1719: AND eiai.pk2_value IS NULL
1720: AND eiai.supplier_site_name IS NOT NULL;
1721: UPDATE ego_item_associations_intf eiai
1722: SET supplier_site_name = ( SELECT vendor_site_code
1723: FROM ap_supplier_sites_all asa
1724: WHERE asa.vendor_site_id = eiai.pk2_value
1725: )
1726: WHERE eiai.batch_id = p_batch_id
1727: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)