[Home] [Help]
128: 0, sum(mr.new_order_quantity),
129: 1, sum(msr.consumed_quantity)
130: )
131: FROM msc_form_query list,
132: msc_supplies mr,
133: msc_supplier_requirements msr,
134: msc_trading_partner_sites mtp
135: WHERE mr.order_type in (M_PLANNED_ORDER, M_PURCHASE_ORDER, M_PURCHASE_REQ, M_PLANNED_ARRIVAL)
136: AND mr.disposition_status_type <> 2
188: 0),
189: 0 ),
190: 0)) po_consumption_quantity
191: FROM msc_form_query list,
192: msc_supplies mr,
193: msc_trading_partner_sites mtp
194: WHERE mr.order_type = M_PURCHASE_ORDER
195: AND mr.disposition_status_type <> 2
196: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) <= trunc(g_cutoff_date)
643: OPEN get_plan_type(p_plan_id);
644: FETCH get_plan_type INTO g_plan_type, l_enforce_sup_cap_constraints, l_constraints;
645: CLOSE get_plan_type;
646:
647: --bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies
648: --BUG5609299--modified previous fix so that we use msc_supplies for unconstrained DRP or unconstrained ASCP plans.
649: if (g_plan_type=5) or (g_plan_type=1 and l_constraints=0) then
650: g_use_sup_req:=0; -- do not use msc_supplier_requirements
651: else
644: FETCH get_plan_type INTO g_plan_type, l_enforce_sup_cap_constraints, l_constraints;
645: CLOSE get_plan_type;
646:
647: --bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies
648: --BUG5609299--modified previous fix so that we use msc_supplies for unconstrained DRP or unconstrained ASCP plans.
649: if (g_plan_type=5) or (g_plan_type=1 and l_constraints=0) then
650: g_use_sup_req:=0; -- do not use msc_supplier_requirements
651: else
652: g_use_sup_req:=1; -- use msc_supplier_requirements