APPS.MSC_DRP_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 281: FROM msc_system_items

277: p_due_date in out nocopy date,
278: p_source_sr_instance_id in number default null) IS
279: CURSOR pp_lt_c IS
280: SELECT nvl(postprocessing_lead_time, 0)
281: FROM msc_system_items
282: WHERE plan_id = p_plan_id
283: AND sr_instance_id = p_inst_id
284: AND ORGANIZATION_ID = p_to_org
285: AND INVENTORY_ITEM_ID = p_item_id;

Line 522: msc_system_items msi

518: null) firm_qty,
519: nvl(ms.firm_quantity,ms.new_order_quantity) new_firm_qty,
520: ms.sr_instance_id
521: from msc_supplies ms,
522: msc_system_items msi
523: where ms.plan_id = p_plan_id
524: and ms.transaction_id = p_transaction_id
525: and msi.inventory_item_id = ms.INVENTORY_ITEM_ID
526: and msi.organization_id = ms.organization_id

Line 993: from msc_system_items

989:
990:
991: cursor lead_time_c is
992: select nvl(fixed_lead_time,0)
993: from msc_system_items
994: where plan_id = p_plan_id
995: and inventory_item_id = p_item_id
996: and organization_id = p_org_id
997: and sr_instance_id = p_inst_id;