eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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