eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_DEMAND_PKG dependencies on MSC_PHUB_DATES_MV

Line 539: from msc_phub_dates_mv

535: md2.old_demand_quantity
536: from
537: msc_demands md2,
538: (select calendar_date, mfg_week_start_date, mfg_period_start_date
539: from msc_phub_dates_mv
540: where calendar_date between l_plan_start_date and l_plan_cutoff_date
541: and mfg_seq_num is not null) d
542: where md2.plan_id=-1
543: and md2.plan_id=p_plan_id

Line 1512: msc_phub_dates_mv d

1508: fnd_global.conc_program_id, fnd_global.conc_login_id,
1509: fnd_global.prog_appl_id, fnd_global.conc_request_id
1510: from
1511: msc_demands_f f,
1512: msc_phub_dates_mv d
1513: where f.plan_id=p_plan_id
1514: and f.plan_run_id=p_plan_run_id
1515: and f.aggr_type=0
1516: and f.constrained_fcst is not null

Line 1831: msc_phub_dates_mv d

1827: fnd_global.conc_program_id, fnd_global.conc_login_id,
1828: fnd_global.prog_appl_id, fnd_global.conc_request_id
1829: from
1830: msc_demands_f f,
1831: msc_phub_dates_mv d
1832: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1833: and f.aggr_type between 42 and 44
1834: and f.order_date = d.calendar_date
1835: and d.mfg_period_start_date is not null

Line 1907: msc_phub_dates_mv d

1903: fnd_global.conc_program_id, fnd_global.conc_login_id,
1904: fnd_global.prog_appl_id, fnd_global.conc_request_id
1905: from
1906: msc_demands_f f,
1907: msc_phub_dates_mv d
1908: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1909: and f.aggr_type between 42 and 44
1910: and f.order_date = d.calendar_date
1911: and d.fis_period_start_date is not null