APPS.MSC_PHUB_COST_PKG dependencies on MSC_PHUB_DATES_MV

Line 100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d

96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d
101: where mbid.plan_id=p_plan_id
102: and l_plan_type not in (101,102,103,105)
103: and (mbid.detail_level=1 or l_plan_type=6)
104: and mbid.period_type=1

Line 188: from msc_bis_org_detail mbod, msc_phub_dates_mv d

184: fnd_global.user_id, sysdate,
185: sysdate, fnd_global.user_id, fnd_global.login_id,
186: fnd_global.conc_program_id, fnd_global.conc_login_id,
187: fnd_global.prog_appl_id, fnd_global.conc_request_id
188: from msc_bis_org_detail mbod, msc_phub_dates_mv d
189: where mbod.plan_id=p_plan_id
190: and trunc(mbod.detail_date)=d.calendar_date
191: group by
192: decode(sign(mbod.sr_instance_id), -1,

Line 289: msc_phub_dates_mv d

285: sr_instance_id2, source_organization_id, supplier_id, supplier_site_id,
286: effective_date, disable_date
287: )
288: ) f,
289: msc_phub_dates_mv d
290: where d.calendar_date between l_plan_start_date and l_plan_cutoff_date
291: and d.calendar_date in (d.mfg_week_end_date, l_plan_cutoff_date)
292: and d.calendar_date between nvl(f.effective_date, l_plan_start_date) and nvl(f.disable_date, l_plan_cutoff_date);
293:

Line 374: msc_phub_dates_mv d

370: fnd_global.conc_program_id, fnd_global.conc_login_id,
371: fnd_global.prog_appl_id, fnd_global.conc_request_id
372: from
373: msc_rp_kpi mrk,
374: msc_phub_dates_mv d
375: where mrk.plan_id=p_plan_id
376: and mrk.kpi_type_id in (5,7,8,36,37,38)
377: and l_plan_type in (101,102,103,105)
378: and trunc(mrk.kpi_time)=d.calendar_date