APPS.MSC_DRP_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 278: FROM msc_system_items

274: p_dock_date in out nocopy date,
275: p_due_date in out nocopy date) IS
276: CURSOR pp_lt_c IS
277: SELECT nvl(postprocessing_lead_time, 0)
278: FROM msc_system_items
279: WHERE plan_id = p_plan_id
280: AND sr_instance_id = p_inst_id
281: AND ORGANIZATION_ID = p_to_org
282: AND INVENTORY_ITEM_ID = p_item_id;

Line 518: msc_system_items msi

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

Line 984: from msc_system_items

980:
981:
982: cursor lead_time_c is
983: select nvl(fixed_lead_time,0)
984: from msc_system_items
985: where plan_id = p_plan_id
986: and inventory_item_id = p_item_id
987: and organization_id = p_org_id
988: and sr_instance_id = p_inst_id;