[Home] [Help]
70: number3, -- sr_instance_id
71: number4, -- organization_id
72: number5, -- inventory_item_id
73: number7, -- excess_horizon
74: number8 -- standard_cost
75: )
76: select
77: unique l_qid_eo,
78: sysdate,
84: msi.sr_instance_id,
85: msi.organization_id,
86: msi.inventory_item_id,
87: msi.excess_horizon,
88: msi.standard_cost
89: from msc_system_items msi
90: where msi.plan_id=l_sim_plan_id
91: and nvl(msi.simulation_set_id, -23453)=l_item_simulation_set_id;
92:
121: number3, -- sr_instance_id
122: number4, -- organization_id
123: number5, -- inventory_item_id
124: number7, -- excess_horizon
125: number8 -- standard_cost
126: )
127: select
128: unique l_qid_eo,
129: sysdate,
135: mia.sr_instance_id,
136: mia.organization_id,
137: mia.inventory_item_id,
138: mia.excess_horizon,
139: nvl(mia.standard_cost, msi.standard_cost)
140: from msc_item_attributes mia, msc_system_items msi
141: where mia.plan_id=-1
142: and mia.simulation_set_id=l_item_simulation_set_id
143: and msi.plan_id=p_plan_id
265: sum(decode(msf.supply_type,18, nvl(msf.supply_qty,0),0)) onhand_qty,
266: sum(case when msf.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
267: then nvl(msf.supply_qty,0) else 0 end) onorder_qty,
268: sum(decode(msf.supply_type,18,nvl(msf.supply_qty,0),0)
269: *nvl(b.number8, nvl(i.standard_cost,0))) onhand_value,
270: sum((case when msf.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
271: then nvl(msf.supply_qty,0) else 0 end)
272: *nvl(b.number8, nvl(i.standard_cost,0))) onorder_value
273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i
268: sum(decode(msf.supply_type,18,nvl(msf.supply_qty,0),0)
269: *nvl(b.number8, nvl(i.standard_cost,0))) onhand_value,
270: sum((case when msf.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
271: then nvl(msf.supply_qty,0) else 0 end)
272: *nvl(b.number8, nvl(i.standard_cost,0))) onorder_value
273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i
274: where msf.plan_id=p_plan_id
275: and msf.plan_run_id=p_plan_run_id
276: and msf.aggr_type=0
307: then mdf.demand_qty else 0 end),0) dmd_within_obs_horizon,
308: nvl((case when mdf.order_date between l_plan_start_date and decode(b.number7, null, l_plan_cutoff_date, l_plan_start_date+b.number7)
309: then mdf.demand_qty else 0 end),0) dmd_within_excess_horizon,
310: nvl((case when mdf.order_date between l_plan_start_date and nvl(b.date1, l_plan_cutoff_date)
311: then mdf.demand_qty else 0 end),0)*nvl(b.number8,nvl(i.standard_cost,0)) dmd_within_obs_hor_value,
312: nvl((case when mdf.order_date between l_plan_start_date and decode(b.number7, null, l_plan_cutoff_date, l_plan_start_date+b.number7)
313: then mdf.demand_qty else 0 end),0)*nvl(b.number8,nvl(i.standard_cost,0)) dmd_within_excess_hor_value,
314: to_number(0) onhand_qty,
315: to_number(0) onorder_qty,
309: then mdf.demand_qty else 0 end),0) dmd_within_excess_horizon,
310: nvl((case when mdf.order_date between l_plan_start_date and nvl(b.date1, l_plan_cutoff_date)
311: then mdf.demand_qty else 0 end),0)*nvl(b.number8,nvl(i.standard_cost,0)) dmd_within_obs_hor_value,
312: nvl((case when mdf.order_date between l_plan_start_date and decode(b.number7, null, l_plan_cutoff_date, l_plan_start_date+b.number7)
313: then mdf.demand_qty else 0 end),0)*nvl(b.number8,nvl(i.standard_cost,0)) dmd_within_excess_hor_value,
314: to_number(0) onhand_qty,
315: to_number(0) onorder_qty,
316: to_number(0) onhand_value,
317: to_number(0) onorder_value