APPS.MSC_RELEASE_PK dependencies on MSC_DEMANDS

Line 494: msc_demands md,

490: and (ms.releasable =0 or ms.releasable is null)
491: and ms.batch_id is null
492: and
493: not exists (select 1 from msc_full_pegging mfp,
494: msc_demands md,
495: msc_supplies ms1
496: where mfp.sr_instance_id = ms.sr_instance_id and
497: mfp.plan_id = ms.plan_id and
498: mfp.transaction_id =ms.transaction_id and

Line 960: FROM msc_demands

956: BEGIN
957: var_sales_order_line_id := NULL;
958: SELECT sales_order_line_id
959: INTO var_sales_order_line_id
960: FROM msc_demands
961: WHERE
962: plan_id = var_plan_id
963: AND sr_instance_id = var_sr_instance_id
964: AND disposition_id = var_transaction_id