APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on AP_SUPPLIERS

Line 240: FROM ap_suppliers aas

236: AND eiai.item_number IS NOT NULL;
237: /*
238: UPDATE ego_item_associations_intf eiai
239: SET (supplier_number,supplier_name) = ( SELECT segment1, vendor_name
240: FROM ap_suppliers aas
241: WHERE aas.vendor_id = eiai.pk1_value
242: )
243: WHERE eiai.batch_id = p_batch_id
244: AND eiai.process_flag = G_REC_IN_PROCESS

Line 347: FROM ap_suppliers aas

343: AND ( eiai.pk1_value IS NULL
344: OR NOT EXISTS
345: (
346: SELECT 1
347: FROM ap_suppliers aas
348: WHERE aas.vendor_id = eiai.pk1_value
349: and NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046
350: )
351: );

Line 1420: FROM ap_suppliers aas

1416: THEN supplier_name
1417: ELSE
1418: (
1419: SELECT vendor_name
1420: FROM ap_suppliers aas
1421: WHERE aas.vendor_id = eiai.pk1_value
1422: )
1423: END AS supplier_name,
1424: CASE

Line 1678: FROM ap_suppliers aas

1674: AND eiai.organization_id IS NOT NULL;
1675:
1676: UPDATE ego_item_associations_intf eiai
1677: SET pk1_value = ( SELECT vendor_id
1678: FROM ap_suppliers aas
1679: WHERE aas.segment1 = eiai.supplier_number
1680: and NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046
1681: )
1682: WHERE eiai.batch_id = p_batch_id

Line 1688: FROM ap_suppliers aas

1684: AND eiai.pk1_value IS NULL
1685: AND eiai.supplier_number IS NOT NULL;
1686: UPDATE ego_item_associations_intf eiai
1687: SET pk1_value = ( SELECT vendor_id
1688: FROM ap_suppliers aas
1689: WHERE aas.vendor_name = eiai.supplier_name
1690: and NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046
1691: )
1692: WHERE eiai.batch_id = p_batch_id

Line 1699: FROM ap_suppliers aas

1695: AND eiai.supplier_name IS NOT NULL
1696: AND eiai.supplier_number IS NULL;
1697: UPDATE ego_item_associations_intf eiai
1698: SET supplier_name = ( SELECT vendor_name
1699: FROM ap_suppliers aas
1700: WHERE aas.vendor_id = eiai.pk1_value
1701: )
1702: WHERE eiai.batch_id = p_batch_id
1703: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

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')