DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on AP_SUPPLIERS

Line 6619: FROM AP_SUPPLIERS aas

6615: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done Resolving data_level_name' );
6616:
6617: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6618: SET PK1_VALUE = ( SELECT VENDOR_ID
6619: FROM AP_SUPPLIERS aas
6620: WHERE aas.SEGMENT1 = eiai.SUPPLIER_NUMBER
6621: )
6622: WHERE eiai.BATCH_ID = p_data_set_id
6623: AND (eiai.PROCESS_FLAG IS NULL OR eiai.PROCESS_FLAG IN (0, 1) )

Line 6629: FROM AP_SUPPLIERS aas

6625: AND eiai.SUPPLIER_NUMBER IS NOT NULL;
6626:
6627: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6628: SET PK1_VALUE = ( SELECT VENDOR_ID
6629: FROM AP_SUPPLIERS aas
6630: WHERE aas.VENDOR_NAME = eiai.SUPPLIER_NAME
6631: )
6632: WHERE eiai.BATCH_ID = p_data_set_id
6633: AND (eiai.PROCESS_FLAG IS NULL OR eiai.PROCESS_FLAG IN (0, 1) )