APPS.MSC_PEG_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 183: from msc_system_items

179: p_supply_pegging IN NUMBER DEFAULT 0) IS
180:
181: cursor bom_item_type (p_inventory_item_id in NUMBER) IS
182: select bom_item_type
183: from msc_system_items
184: where inventory_item_id = p_inventory_item_id
185: and plan_id = p_plan_id
186: and sr_instance_id = p_instance_id;
187:

Line 261: msc_system_items msi

257: msc_routings rout,
258: msc_routing_operations op,
259: msc_operation_components moc,
260: msc_bom_components mbc,
261: msc_system_items msi
262: WHERE req.plan_id = rout.plan_id
263: AND req.sr_instance_id = rout.sr_instance_id
264: AND nvl(req.routing_sequence_id,-23453) = decode(nvl(req.routing_sequence_id,-23453), -23453,-23453, rout.routing_sequence_id)
265: AND req.plan_id = op.plan_id