APPS.EGO_ITEM_WS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1371: MTL_SYSTEM_ITEMS_KFV MSIK ,

1367: MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER ,
1368: MSIK.ORGANIZATION_ID MASTER_ORGANIZATION_ID,
1369: MSIK.PRIMARY_UOM_CODE
1370: FROM MTL_CROSS_REFERENCES_B MCR1,
1371: MTL_SYSTEM_ITEMS_KFV MSIK ,
1372: MTL_PARAMETERS MP1
1373: WHERE MCR1.CROSS_REFERENCE_TYPE = 'GTIN'
1374: AND MCR1.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
1375: AND MSIK.ORGANIZATION_ID = MP1.MASTER_ORGANIZATION_ID

Line 4209: from mtl_system_items_kfv

4205: IF (p_inv_id <> -1 AND p_org_id <> -1) THEN
4206:
4207: select inventory_item_id
4208: INTO p_inv_item_id
4209: from mtl_system_items_kfv
4210: WHERE organization_id = p_org_id
4211: AND inventory_item_id = p_inv_id;
4212:
4213: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

Line 4222: from mtl_system_items_kfv

4218:
4219: ELSE
4220: select inventory_item_id
4221: INTO p_inv_item_id
4222: from mtl_system_items_kfv
4223: WHERE organization_id = p_org_id
4224: AND Nvl(segment1, 0) = Nvl(p_segment1, 0)
4225: AND Nvl(segment2, 0) = Nvl(p_segment2, 0)
4226: AND Nvl(segment3, 0) = Nvl(p_segment3, 0)