HTS_LABOR_DEMAND

Details

Schema: FUSION
Object owner: HTS
Object type: VIEW

Columns

Name
DEMAND_DATE SCHEDULER_PROFILE_ID RESOURCES_REQUIRED

Name

DEMAND_DATE

SCHEDULER_PROFILE_ID

RESOURCES_REQUIRED

Query

SQL_Statement
select prfl.demand_date, prfl.scheduler_profile_id, nvl(dated.value, prfl.resources_required) resources_required from hts_labor_demand_prfl_dated_v prfl left outer join hts_labor_demand_vals dated on trunc(dated.from_date) = prfl.demand_date and prfl.scheduler_profile_id = dated.sched_profile_id

SQL_Statement

select prfl.demand_date, prfl.scheduler_profile_id, nvl(dated.value, prfl.resources_required) resources_required

from hts_labor_demand_prfl_dated_v prfl left outer join hts_labor_demand_vals dated on trunc(dated.from_date) = prfl.demand_date and prfl.scheduler_profile_id = dated.sched_profile_id