APPS.GMD_RECIPE_DETAIL dependencies on MTL_SYSTEM_ITEMS

Line 579: FROM mtl_system_items

575: /* Get the primary item um for the item passed in */
576: -- NPD Conv.
577: Cursor get_primary_um(vItem_id NUMBER) IS
578: SELECT primary_uom_code
579: FROM mtl_system_items
580: WHERE inventory_item_id = vItem_id;
581:
582: /* Chcek VR dates against Routing dates */
583: CURSOR Get_Routing_Details(vRecipe_id NUMBER) IS

Line 1698: FROM mtl_system_items_kfv

1694:
1695: /* Cursor to get the item id when item no is passed */
1696: CURSOR get_item_id(pItem_no VARCHAR2) IS
1697: SELECT inventory_item_id
1698: FROM mtl_system_items_kfv
1699: WHERE concatenated_segments = pItem_no;
1700: -- And delete_mark = 0;
1701:
1702: Update_VR_Failure EXCEPTION;