DBA Data[Home] [Help]

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 363: FROM ap_supplier_sites_all assa

359: AND ( eiai.pk2_value IS NULL
360: OR NOT EXISTS
361: (
362: SELECT 1
363: FROM ap_supplier_sites_all assa
364: WHERE assa.vendor_site_id = eiai.pk2_value
365: --AND assa.vendor_id = eiai.vendor_id
366: AND assa.vendor_id = eiai.pk1_value
367: AND assa.org_id = fnd_profile.value('ORG_ID')

Line 615: FROM ap_supplier_sites_all assa

611: AND eiai.transaction_type = G_CREATE
612: AND NOT EXISTS
613: (
614: SELECT 1
615: FROM ap_supplier_sites_all assa
616: WHERE assa.vendor_id = eiai.pk1_value
617: AND assa.org_id = fnd_profile.value('ORG_ID')
618: );
619: UPDATE ego_item_associations_intf eiai

Line 1366: FROM ap_supplier_sites_all assa

1362: THEN supplier_site_name
1363: ELSE
1364: (
1365: SELECT vendor_site_code
1366: FROM ap_supplier_sites_all assa
1367: WHERE assa.vendor_site_id = eiai.pk2_value
1368: )
1369: END AS supplier_site_name,
1370: data_level_name

Line 1643: FROM ap_suppliers aas, ap_supplier_sites_all asa

1639: AND eiai.pk1_value IS NOT NULL;
1640: UPDATE ego_item_associations_intf eiai
1641: SET pk2_value = NVL(
1642: ( SELECT vendor_site_id
1643: FROM ap_suppliers aas, ap_supplier_sites_all asa
1644: WHERE aas.vendor_id = asa.vendor_id
1645: AND asa.vendor_site_code = eiai.supplier_site_name
1646: AND asa.vendor_id = eiai.pk1_value -- BUG 6322084
1647: AND asa.org_id = fnd_profile.value('ORG_ID')

Line 1656: FROM ap_supplier_sites_all asa

1652: AND eiai.pk2_value IS NULL
1653: AND eiai.supplier_site_name IS NOT NULL;
1654: UPDATE ego_item_associations_intf eiai
1655: SET supplier_site_name = ( SELECT vendor_site_code
1656: FROM ap_supplier_sites_all asa
1657: WHERE asa.vendor_site_id = eiai.pk2_value
1658: )
1659: WHERE eiai.batch_id = p_batch_id
1660: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)