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 1599: FROM mtl_system_items_kfv

1595:
1596: /* Cursor to get the item id when item no is passed */
1597: CURSOR get_item_id(pItem_no VARCHAR2) IS
1598: SELECT inventory_item_id
1599: FROM mtl_system_items_kfv
1600: WHERE concatenated_segments = pItem_no;
1601: -- And delete_mark = 0;
1602:
1603: Update_VR_Failure EXCEPTION;