DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_FULL_PEGGING

Line 417: msc_full_pegging mfp,

413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from
417: msc_full_pegging mfp,
418: msc_supplies ms,
419: msc_apcc_item_d i,
420: msc_full_pegging mfp2
421: where mfp.plan_id=mfp2.plan_id

Line 420: msc_full_pegging mfp2

416: from
417: msc_full_pegging mfp,
418: msc_supplies ms,
419: msc_apcc_item_d i,
420: msc_full_pegging mfp2
421: where mfp.plan_id=mfp2.plan_id
422: and mfp.end_pegging_id=mfp2.end_pegging_id
423: and mfp2.prev_pegging_id is null
424: and mfp2.plan_id=p_plan_id

Line 492: msc_full_pegging mfp,

488: sysdate, fnd_global.user_id, fnd_global.login_id,
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from
492: msc_full_pegging mfp,
493: msc_apcc_item_d i,
494: msc_demands md
495: where mfp.plan_id=md.plan_id
496: and mfp.demand_id=md.demand_id