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 352: from msc_supplies

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

Line 517: from msc_supplies ms,

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

Line 581: update msc_supplies

577: g_supply_undo_rec(p_rec).lead_time := nvl(p_lead_time,sup_rec.lead_time);
578:
579:
580: -- update table
581: update msc_supplies
582: set firm_planned_type = p_firm_flag,
583: firm_quantity = p_firm_qty,
584: firm_date = p_firm_date,
585: new_ship_date = nvl(p_ship_date,new_ship_date),

Line 752: from msc_supplies

748: FUNCTION get_iso_trip(p_plan_id number, p_instance_id number,
749: p_disposition_id number) return number IS
750: CURSOR trip_c IS
751: select shipment_id
752: from msc_supplies
753: where plan_id = p_plan_id
754: and sr_instance_id = p_instance_id
755: and transaction_id = p_disposition_id;
756: v_trip number;