DBA Data[Home] [Help]

APPS.ENG_GLOBALS dependencies on MTL_SYSTEM_ITEMS

Line 2100: FROM MTL_SYSTEM_ITEMS

2096: CURSOR l_routing_type_csr ( p_revised_item_id NUMBER
2097: , p_organization_id NUMBER )
2098: IS
2099: SELECT decode(eng_item_flag, 'N', 1, 2) eng_item_flag
2100: FROM MTL_SYSTEM_ITEMS
2101: WHERE inventory_item_id = p_revised_item_id
2102: AND organization_id = p_organization_id ;
2103:
2104: -- Get Routing_Sequence_id