[Home] [Help]
59: activity_rec supplier_activity;
60: l_dock_date_prof number := nvl(FND_PROFILE.Value('MSC_PO_DOCK_DATE_CALC_PREF'),1);
61:
62:
63: --5220804bugfix, msc_supplier_requirements table added to snapshot to get consumption date
64:
65: CURSOR supplier_snapshot_activity IS
66: -- ===================================
67: -- Supplier Availability
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
137: AND decode(mtp.shipping_control,'BUYER',mr.new_ship_date,mr.new_dock_date) <= trunc(g_cutoff_date)
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
653: end if;
654:
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
653: end if;
654:
655: g_error_stmt := 'Debug - populate_horizontal_plan - 20';
656: -- dbms_output.put_line(g_error_stmt);