DBA Data[Home] [Help]

APPS.BOM_OP_SEQ_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 496: FROM MTL_SYSTEM_ITEMS

492: CURSOR l_routing_type_csr ( p_revised_item_id NUMBER
493: , p_organization_id NUMBER )
494: IS
495: SELECT decode(eng_item_flag, 'N', 1, 2) eng_item_flag
496: FROM MTL_SYSTEM_ITEMS
497: WHERE inventory_item_id = p_revised_item_id
498: AND organization_id = p_organization_id ;
499:
500: -- Get Routing_Sequence_id