DBA Data[Home] [Help]

APPS.MSC_UI_PEG_UTIL dependencies on MSC_FULL_PEGGING

Line 254: from msc_full_pegging

250: null end_demand_class
251: from msc_flp_supply_demand_v3
252: where plan_id = p_plan_id
253: and prev_pegging_id in ( select pegging_id
254: from msc_full_pegging
255: where plan_id = p_plan_id
256: and transaction_id = l_transaction_id
257: and sr_instance_id = p_instance_id
258: and allocated_quantity > 0) ------ = p_pegging_id

Line 513: from msc_full_pegging mfp,

509: null end_demand_class
510: from msc_flp_supply_demand_v3
511: where plan_id = p_plan_id
512: and prev_pegging_id in ( select mfp.pegging_id
513: from msc_full_pegging mfp,
514: msc_supplies ms
515: where ms.plan_id = p_plan_id
516: and ms.transaction_id = p_transaction_id
517: and ms.sr_instance_id = p_instance_id