VIEW: APPS.BIS_TARGET_VALUE_DETAILS_V

Source

View Text - Preformatted

SELECT tv.target_level_id, gl.period_set_name, gl.period_name, gl.start_date, gl.end_date, tv.org_level_value, tv.target, tv.range1_low, tv.range1_high from bis_target_values tv, gl_periods gl WHERE substr(tv.time_level_value,instr(tv.time_level_value,'+')+1) = gl.period_name and substr(tv.time_level_value,1,instr(tv.time_level_value,'+')-1) = gl.period_set_name and substr(tv.time_level_value,1,2) <> 'HR' union select tv.target_level_id, hr.period_set_name, hr.period_name, hr.start_date, add_months(hr.start_date,1), tv.org_level_value, tv.target, tv.range1_low, tv.range1_high from bis_target_values tv, bis_hr_months_v hr where substr(tv.time_level_value,instr(tv.time_level_value,'+')+1) = hr.period_name and substr(tv.time_level_value,1,instr(tv.time_level_value,'+')-1) = hr.period_set_name union select tv.target_level_id, hr.period_set_name, hr.period_name, hr.start_date, add_months(hr.start_date,3), tv.org_level_value, tv.target, tv.range1_low, tv.range1_high from bis_target_values tv, bis_hr_quarters_v hr where substr(tv.time_level_value,instr(tv.time_level_value,'+')+1) = hr.period_name and substr(tv.time_level_value,1,instr(tv.time_level_value,'+')-1) = hr.period_set_name union select tv.target_level_id, hr.period_set_name, hr.period_name, hr.start_date, add_months(hr.start_date,1), tv.org_level_value, tv.target, tv.range1_low, tv.range1_high from bis_target_values tv, bis_hr_months_v hr where substr(tv.time_level_value,instr(tv.time_level_value,'+')+1) = hr.period_name and substr(tv.time_level_value,1,instr(tv.time_level_value,'+')-1) = hr.period_set_name union select tv.target_level_id, hr.period_set_name, hr.period_name, hr.start_date, add_months(hr.start_date,12), tv.org_level_value, tv.target, tv.range1_low, tv.range1_high from bis_target_values tv, bis_hr_years_v hr where substr(tv.time_level_value,instr(tv.time_level_value,'+')+1) = hr.period_name and substr(tv.time_level_value,1,instr(tv.time_level_value,'+')-1) = hr.period_set_name

View Text - HTML Formatted

SELECT TV.TARGET_LEVEL_ID
, GL.PERIOD_SET_NAME
, GL.PERIOD_NAME
, GL.START_DATE
, GL.END_DATE
, TV.ORG_LEVEL_VALUE
, TV.TARGET
, TV.RANGE1_LOW
, TV.RANGE1_HIGH
FROM BIS_TARGET_VALUES TV
, GL_PERIODS GL
WHERE SUBSTR(TV.TIME_LEVEL_VALUE
, INSTR(TV.TIME_LEVEL_VALUE
, '+')+1) = GL.PERIOD_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, INSTR(TV.TIME_LEVEL_VALUE
, '+')-1) = GL.PERIOD_SET_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, 2) <> 'HR' UNION SELECT TV.TARGET_LEVEL_ID
, HR.PERIOD_SET_NAME
, HR.PERIOD_NAME
, HR.START_DATE
, ADD_MONTHS(HR.START_DATE
, 1)
, TV.ORG_LEVEL_VALUE
, TV.TARGET
, TV.RANGE1_LOW
, TV.RANGE1_HIGH
FROM BIS_TARGET_VALUES TV
, BIS_HR_MONTHS_V HR
WHERE SUBSTR(TV.TIME_LEVEL_VALUE
, INSTR(TV.TIME_LEVEL_VALUE
, '+')+1) = HR.PERIOD_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, INSTR(TV.TIME_LEVEL_VALUE
, '+')-1) = HR.PERIOD_SET_NAME UNION SELECT TV.TARGET_LEVEL_ID
, HR.PERIOD_SET_NAME
, HR.PERIOD_NAME
, HR.START_DATE
, ADD_MONTHS(HR.START_DATE
, 3)
, TV.ORG_LEVEL_VALUE
, TV.TARGET
, TV.RANGE1_LOW
, TV.RANGE1_HIGH
FROM BIS_TARGET_VALUES TV
, BIS_HR_QUARTERS_V HR
WHERE SUBSTR(TV.TIME_LEVEL_VALUE
, INSTR(TV.TIME_LEVEL_VALUE
, '+')+1) = HR.PERIOD_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, INSTR(TV.TIME_LEVEL_VALUE
, '+')-1) = HR.PERIOD_SET_NAME UNION SELECT TV.TARGET_LEVEL_ID
, HR.PERIOD_SET_NAME
, HR.PERIOD_NAME
, HR.START_DATE
, ADD_MONTHS(HR.START_DATE
, 1)
, TV.ORG_LEVEL_VALUE
, TV.TARGET
, TV.RANGE1_LOW
, TV.RANGE1_HIGH
FROM BIS_TARGET_VALUES TV
, BIS_HR_MONTHS_V HR
WHERE SUBSTR(TV.TIME_LEVEL_VALUE
, INSTR(TV.TIME_LEVEL_VALUE
, '+')+1) = HR.PERIOD_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, INSTR(TV.TIME_LEVEL_VALUE
, '+')-1) = HR.PERIOD_SET_NAME UNION SELECT TV.TARGET_LEVEL_ID
, HR.PERIOD_SET_NAME
, HR.PERIOD_NAME
, HR.START_DATE
, ADD_MONTHS(HR.START_DATE
, 12)
, TV.ORG_LEVEL_VALUE
, TV.TARGET
, TV.RANGE1_LOW
, TV.RANGE1_HIGH
FROM BIS_TARGET_VALUES TV
, BIS_HR_YEARS_V HR
WHERE SUBSTR(TV.TIME_LEVEL_VALUE
, INSTR(TV.TIME_LEVEL_VALUE
, '+')+1) = HR.PERIOD_NAME
AND SUBSTR(TV.TIME_LEVEL_VALUE
, 1
, INSTR(TV.TIME_LEVEL_VALUE
, '+')-1) = HR.PERIOD_SET_NAME