[Home] [Help]
APPS.MSC_PHUB_EXCESS_PKG dependencies on MSC_DEMANDS_F
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