APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_SYSTEM_ITEMS

Line 89: from msc_system_items msi

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:
93: msc_phub_util.log('l_qid_eo='||l_qid_eo||', count='||sql%rowcount);

Line 140: from msc_item_attributes mia, msc_system_items msi

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
144: and mia.sr_instance_id=msi.sr_instance_id

Line 273: from msc_supplies_f msf,msc_trading_partners mtp, msc_hub_query b, msc_system_items i

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
277: and b.query_id(+)=l_qid_eo

Line 318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i

314: to_number(0) onhand_qty,
315: to_number(0) onorder_qty,
316: to_number(0) onhand_value,
317: to_number(0) onorder_value
318: from msc_demands_f mdf, msc_trading_partners mtp, msc_hub_query b, msc_system_items i
319: where mdf.plan_id=p_plan_id
320: and mdf.plan_run_id=p_plan_run_id
321: and mdf.aggr_type=0
322: and b.query_id(+)=l_qid_eo