APPS.MSC_UI_PEG_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 59: from msc_system_items mis,

55: ms.new_order_quantity pegged_qty,
56: ms.inventory_item_id,
57: ms.order_type,
58: null disposition
59: from msc_system_items mis,
60: msc_supplies ms
61: where mis.inventory_item_id = ms.inventory_item_id
62: and mis.sr_instance_id = ms.sr_instance_id
63: and mis.organization_id = ms.organization_id

Line 69: --5523978 bugfix, msc_items changed to msc_system_items

65: and ms.transaction_id = p_disposition_id_1
66: and ms.plan_id = p_plan_id
67: and ms.organization_id = p_organization_id
68: and ms.sr_instance_id = p_sr_instance_id;
69: --5523978 bugfix, msc_items changed to msc_system_items
70:
71: cursor cur2(l_show_item_desc number) is
72: select distinct
73: decode(l_show_item_desc ,1,item_desc_org,item_org) item_org,

Line 216: from msc_system_items

212: p_show_item_desc IN NUMBER DEFAULT 2) IS
213:
214: cursor bom_item_type (p_inventory_item_id in NUMBER) IS
215: select bom_item_type
216: from msc_system_items
217: where inventory_item_id = p_inventory_item_id
218: and plan_id = p_plan_id
219: and sr_instance_id = p_instance_id;
220:

Line 265: msc_system_items msi

261: msc_routings rout,
262: msc_routing_operations op,
263: msc_operation_components moc,
264: msc_bom_components mbc,
265: msc_system_items msi
266: WHERE req.plan_id = rout.plan_id
267: AND req.sr_instance_id = rout.sr_instance_id
268: AND nvl(req.routing_sequence_id,-23453) = decode(nvl(req.routing_sequence_id,-23453), -23453,-23453, rout.routing_sequence_id)
269: AND req.plan_id = op.plan_id

Line 314: from msc_system_items mis,

310: null order_number,
311: null pegging_id,
312: null transaction_id,
313: null end_demand_class
314: from msc_system_items mis,
315: msc_demands dm
316: where mis.inventory_item_id = dm.inventory_item_id
317: and mis.sr_instance_id = dm.sr_instance_id
318: and mis.organization_id = dm.organization_id

Line 620: from msc_system_items mis,

616: null order_number,
617: null pegging_id,
618: null transaction_id,
619: null end_demand_class
620: from msc_system_items mis,
621: msc_demands dm
622: where mis.inventory_item_id = dm.inventory_item_id
623: and mis.sr_instance_id = dm.sr_instance_id
624: and mis.organization_id = dm.organization_id