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
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
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