DBA Data[Home] [Help]

APPS.MSC_RESOURCE_PKG dependencies on MSC_PHUB_DATES_MV

Line 461: msc_phub_dates_mv d

457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from
460: msc_resources_f f,
461: msc_phub_dates_mv d
462: where f.plan_id=p_plan_id
463: and f.plan_run_id=p_plan_run_id
464: and f.aggr_type=0
465: and d.calendar_date between l_plan_start_date and l_plan_cutoff_date

Line 654: msc_phub_dates_mv d

650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from
653: msc_resources_f f,
654: msc_phub_dates_mv d
655: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
656: and f.aggr_type = 82
657: and f.analysis_date = d.calendar_date
658: and d.mfg_period_start_date is not null

Line 688: msc_phub_dates_mv d

684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from
687: msc_resources_f f,
688: msc_phub_dates_mv d
689: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
690: and f.aggr_type = 82
691: and f.analysis_date = d.calendar_date
692: and d.fis_period_start_date is not null