6697: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done Resolving data_level_name' );
6698:
6699: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6700: SET PK1_VALUE = ( SELECT VENDOR_ID
6701: FROM AP_SUPPLIERS aas
6702: WHERE aas.SEGMENT1 = eiai.SUPPLIER_NUMBER
6703: AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046
6704: )
6705: WHERE eiai.BATCH_ID = p_data_set_id
6708: AND eiai.SUPPLIER_NUMBER IS NOT NULL;
6709:
6710: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6711: SET PK1_VALUE = ( SELECT VENDOR_ID
6712: FROM AP_SUPPLIERS aas
6713: WHERE aas.VENDOR_NAME = eiai.SUPPLIER_NAME
6714: AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046
6715: )
6716: WHERE eiai.BATCH_ID = p_data_set_id