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: )
350: );
351: UPDATE ego_item_associations_intf eiai

Line 1356: FROM ap_suppliers aas

1352: THEN supplier_name
1353: ELSE
1354: (
1355: SELECT vendor_name
1356: FROM ap_suppliers aas
1357: WHERE aas.vendor_id = eiai.pk1_value
1358: )
1359: END AS supplier_name,
1360: CASE

Line 1614: FROM ap_suppliers aas

1610: AND eiai.organization_id IS NOT NULL;
1611:
1612: UPDATE ego_item_associations_intf eiai
1613: SET pk1_value = ( SELECT vendor_id
1614: FROM ap_suppliers aas
1615: WHERE aas.segment1 = eiai.supplier_number
1616: )
1617: WHERE eiai.batch_id = p_batch_id
1618: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 1623: FROM ap_suppliers aas

1619: AND eiai.pk1_value IS NULL
1620: AND eiai.supplier_number IS NOT NULL;
1621: UPDATE ego_item_associations_intf eiai
1622: SET pk1_value = ( SELECT vendor_id
1623: FROM ap_suppliers aas
1624: WHERE aas.vendor_name = eiai.supplier_name
1625: )
1626: WHERE eiai.batch_id = p_batch_id
1627: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

Line 1633: FROM ap_suppliers aas

1629: AND eiai.supplier_name IS NOT NULL
1630: AND eiai.supplier_number IS NULL;
1631: UPDATE ego_item_associations_intf eiai
1632: SET supplier_name = ( SELECT vendor_name
1633: FROM ap_suppliers aas
1634: WHERE aas.vendor_id = eiai.pk1_value
1635: )
1636: WHERE eiai.batch_id = p_batch_id
1637: AND eiai.process_flag IN (G_REC_TO_BE_PROCESSED, G_REC_BEFORE_MATCH)

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