APPS.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 5838: FROM MTL_SYSTEM_ITEMS_B_KFV

5834: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5835: IF i.INVENTORY_ITEM_ID IS NULL THEN
5836: BEGIN
5837: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
5838: FROM MTL_SYSTEM_ITEMS_B_KFV
5839: WHERE CONCATENATED_SEGMENTS = i.ITEM_NUMBER
5840: AND ORGANIZATION_ID = i.ORGANIZATION_ID;
5841: EXCEPTION WHEN NO_DATA_FOUND THEN
5842: Debug_Conc_Log('Inventory Item Id is NULL and no Matching Item found for Item Number-'||i.ITEM_NUMBER);

Line 7998: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,

7994: SELECT KFV.CONCATENATED_SEGMENTS ITEM_NUMBER,
7995: MSII.ORGANIZATION_CODE,
7996: MSII.ORGANIZATION_ID,
7997: MSII.TRANSACTION_ID
7998: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7999: MTL_SYSTEM_ITEMS_INTERFACE MSII,
8000: MTL_CROSS_REFERENCES MCR
8001: WHERE MSII.SET_PROCESS_ID = p_data_set_id
8002: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'