APPS.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 5772: FROM MTL_SYSTEM_ITEMS_B_KFV

5768: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5769: IF i.INVENTORY_ITEM_ID IS NULL THEN
5770: BEGIN
5771: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
5772: FROM MTL_SYSTEM_ITEMS_B_KFV
5773: WHERE CONCATENATED_SEGMENTS = i.ITEM_NUMBER
5774: AND ORGANIZATION_ID = i.ORGANIZATION_ID;
5775: EXCEPTION WHEN NO_DATA_FOUND THEN
5776: Debug_Conc_Log('Inventory Item Id is NULL and no Matching Item found for Item Number-'||i.ITEM_NUMBER);

Line 7896: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,

7892: SELECT KFV.CONCATENATED_SEGMENTS ITEM_NUMBER,
7893: MSII.ORGANIZATION_CODE,
7894: MSII.ORGANIZATION_ID,
7895: MSII.TRANSACTION_ID
7896: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7897: MTL_SYSTEM_ITEMS_INTERFACE MSII,
7898: MTL_CROSS_REFERENCES MCR
7899: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7900: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'