APPS.MSC_DRP_UTIL dependencies on MSC_SUPPLIES

Line 128: from msc_supplies ms,

124: FUNCTION material_avail_date(p_plan_id number, p_supply_id number)
125: RETURN date IS
126: CURSOR date_c IS
127: select ms.new_schedule_date
128: from msc_supplies ms,
129: msc_single_lvl_peg mslp
130: where mslp.plan_id = p_plan_id
131: and mslp.pegging_type = 1 -- supply to parent supply
132: and mslp.parent_id = p_supply_id

Line 356: from msc_supplies

352: p_dock_date out nocopy date,
353: p_due_date out nocopy date) IS
354: CURSOR ir_c IS
355: select new_ship_date, new_dock_date, new_schedule_date
356: from msc_supplies
357: where plan_id = p_plan_id
358: and sr_instance_id = p_inst_id
359: and transaction_id = p_transaction_id;
360: BEGIN

Line 521: from msc_supplies ms,

517: nvl(ms.firm_quantity,ms.new_order_quantity),
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

Line 585: update msc_supplies

581: g_supply_undo_rec(p_rec).lead_time := nvl(p_lead_time,sup_rec.lead_time);
582:
583:
584: -- update table
585: update msc_supplies
586: set firm_planned_type = p_firm_flag,
587: firm_quantity = p_firm_qty,
588: firm_date = p_firm_date,
589: new_ship_date = nvl(p_ship_date,new_ship_date),

Line 756: from msc_supplies

752: FUNCTION get_iso_trip(p_plan_id number, p_instance_id number,
753: p_disposition_id number) return number IS
754: CURSOR trip_c IS
755: select shipment_id
756: from msc_supplies
757: where plan_id = p_plan_id
758: and sr_instance_id = p_instance_id
759: and transaction_id = p_disposition_id;
760: v_trip number;