[Home] [Help]
View: BIS_TARGET_VALUE_DETAILS_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
TARGET_LEVEL_ID |
PERIOD_SET_NAME |
PERIOD_NAME |
PERIOD_START_DATE |
PERIOD_END_DATE |
ORG_LEVEL_VALUE |
TARGET |
RANGE1_LOW |
RANGE1_HIGH |