DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2343: FROM mtl_system_items_b_kfv msk

2339:
2340: BEGIN
2341:
2342: SELECT msk.inventory_item_id into p_related_item_id
2343: FROM mtl_system_items_b_kfv msk
2344: WHERE msk.concatenated_segments = l_mtl_Rel_Item_rec.RELATED_ITEM_NUMBER
2345: and rownum=1;
2346:
2347: IF l_mtl_Rel_Item_rec.RELATED_ITEM_ID IS NOT NULL THEN

Line 2396: FROM mtl_system_items_b_kfv msk

2392:
2393: BEGIN
2394:
2395: SELECT msk.inventory_item_id into p_inventory_item_id
2396: FROM mtl_system_items_b_kfv msk
2397: WHERE msk.concatenated_segments = l_mtl_Rel_Item_rec.ITEM_NUMBER
2398: and organization_id=l_mtl_Rel_Item_rec.ORGANIZATION_ID;
2399:
2400: IF l_mtl_Rel_Item_rec.INVENTORY_ITEM_ID IS NOT NULL THEN