DBA Data[Home] [Help]

APPS.MSC_ITEM_PKG dependencies on MSC_DEMANDS

Line 177: msc_demands_f f,

173: sysdate, fnd_global.user_id, fnd_global.login_id,
174: fnd_global.conc_program_id, fnd_global.conc_login_id,
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from
177: msc_demands_f f,
178: msc_hub_query d,
179: msc_apcc_item_d i
180: where f.plan_run_id=p_plan_run_id
181: and f.aggr_type=0

Line 494: msc_demands md

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
497: and md.origination_type in (5,6,7,8,9,10,11,12,15,22,24,27,29,30)
498: and mfp.plan_id=p_plan_id

Line 1312: msc_demands_f f,

1308: sysdate, fnd_global.user_id, fnd_global.login_id,
1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,
1313: msc_phub_dates_mv d,
1314: msc_apcc_item_d i
1315: where trunc(f.order_date)=d.calendar_date
1316: and f.plan_run_id=p_plan_run_id