HTS_LABOR_DEMAND_PRFL_VALS_V

Details

• Schema: FUSION

• Object owner: HTS

• Object type: VIEW

Columns

Name
SCHED_PROFILE_ID START_DATE END_DATE VAL_INDEX VALUE

Query

SQL_Statement
select s.sched_profile_id,s.start_date, s.end_date, P.val_index, p.value from hts_labor_demand_prfl_vals P, hts_labor_demand_prfl_defs D, hts_labor_demand_prfl_defsets S where P.lbr_dmd_prfl_def_id = D.lbr_dmd_prfl_def_id and d.lbr_dmd_prfl_set_id = s.lbr_dmd_prfl_set_id order by S.sched_profile_id, D.lbr_dmd_prfl_set_id, P.lbr_dmd_prfl_def_id, P.val_index