DBA Data[Home] [Help]

APPS.BOM_DEFAULT_RTG_HEADER dependencies on MTL_SYSTEM_ITEMS

Line 162: FROM mtl_system_items

158: CURSOR get_routing_flag_csr ( p_assembly_item_id NUMBER
159: , p_org_id NUMBER )
160: IS
161: SELECT DECODE(eng_item_flag, 'Y', 1, 2) eng_routing_flag
162: FROM mtl_system_items
163: WHERE inventory_item_id = p_assembly_item_id
164: AND organization_id = p_org_id;
165:
166:

Line 194: FROM mtl_system_items

190: CURSOR GET_SER_NUM_CONTROL_CODE_csr ( p_assembly_item_id NUMBER
191: , p_org_id NUMBER )
192: IS
193: SELECT serial_number_control_code
194: FROM mtl_system_items
195: WHERE inventory_item_id = p_assembly_item_id
196: AND organization_id = p_org_id;
197:
198: BEGIN