DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_FULL_PEGGING

Line 221: msc_full_pegging mfp

217:
218: select md.using_assembly_demand_date
219: into var_date
220: from msc_demands md,
221: msc_full_pegging mfp
222: where mfp.pegging_id = arg_pegging_id
223: and mfp.plan_id=arg_plan_id
224: and md.demand_id = mfp.demand_id
225: and md.plan_id = mfp.plan_id;

Line 277: msc_full_pegging mfp

273:
274: select ms.new_schedule_date
275: into var_date
276: from msc_supplies ms,
277: msc_full_pegging mfp
278: where ms.transaction_id = mfp.transaction_id
279: and ms.plan_id=mfp.plan_id
280: and mfp.pegging_id = arg_pegging_id
281: and mfp.plan_id = arg_plan_id;

Line 1536: not exists (select 1 from msc_full_pegging mfp,

1532: and mtp.sr_instance_id= ms.sr_instance_id
1533: and mtp.partner_type= 3
1534: and ms.batch_id is null
1535: and
1536: not exists (select 1 from msc_full_pegging mfp,
1537: msc_demands md,
1538: msc_supplies ms1
1539: where mfp.sr_instance_id = ms.sr_instance_id and
1540: mfp.plan_id = ms.plan_id and

Line 6263: MSC_FULL_PEGGING PEGGING,

6259: SELECT
6260: COMPONENTS.WIP_SUPPLY_TYPE
6261: FROM
6262: MSC_SUPPLIES SUPPLIES,
6263: MSC_FULL_PEGGING PEGGING,
6264: MSC_DEMANDS DEMANDS,
6265: MSC_BOM_COMPONENTS COMPONENTS,
6266: MSC_PLANS PLANS
6267: WHERE