DBA Data[Home] [Help]

APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_SUPPLIES_F

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