DBA Data[Home] [Help]

APPS.MSC_SUPPLY_PKG dependencies on MSC_PHUB_DATES_MV

Line 817: msc_phub_dates_mv d

813: fnd_global.conc_program_id, fnd_global.conc_login_id,
814: fnd_global.prog_appl_id, fnd_global.conc_request_id
815: from
816: msc_supplies_f f,
817: msc_phub_dates_mv d
818: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
819: and f.aggr_type between 42 and 44
820: and f.supply_date = d.calendar_date
821: and d.mfg_period_start_date is not null

Line 883: msc_phub_dates_mv d

879: fnd_global.conc_program_id, fnd_global.conc_login_id,
880: fnd_global.prog_appl_id, fnd_global.conc_request_id
881: from
882: msc_supplies_f f,
883: msc_phub_dates_mv d
884: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
885: and f.aggr_type between 42 and 44
886: and f.supply_date = d.calendar_date
887: and d.fis_period_start_date is not null

Line 1001: msc_phub_dates_mv d

997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from
1000: msc_item_wips_f f,
1001: msc_phub_dates_mv d
1002: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1003: and f.aggr_type between 42 and 44
1004: and f.wip_start_date = d.calendar_date
1005: and d.mfg_period_start_date is not null

Line 1029: msc_phub_dates_mv d

1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from
1028: msc_item_wips_f f,
1029: msc_phub_dates_mv d
1030: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1031: and f.aggr_type between 42 and 44
1032: and f.wip_start_date = d.calendar_date
1033: and d.fis_period_start_date is not null