VIEW: APPS.BIS_POACTLKG_OU_M_V

Source

View Text - Preformatted

SELECT LVL.WF_PROCESS , PLAN.PLAN_ID , PLAN.SHORT_NAME , PLAN.VERSION_NO , PLAN.CURRENT_PLAN_FLAG , VAL.TIME_LEVEL_VALUE , VAL.ORG_LEVEL_VALUE , VAL.TARGET , VAL.RANGE1_LOW , VAL.RANGE1_HIGH , VAL.RANGE2_LOW , VAL.RANGE2_HIGH , VAL.RANGE3_LOW , VAL.RANGE3_HIGH , VAL.ROLE1_ID , VAL.ROLE2_ID , VAL.ROLE3_ID , VAL.ROLE1 , VAL.ROLE2 , VAL.ROLE3 , SUBSTR(VAL.TIME_LEVEL_VALUE,INSTR(VAL.TIME_LEVEL_VALUE,'+',1,1)+1) , TO_NUMBER(GL.PERIOD_YEAR) , SUBSTR(VAL.TIME_LEVEL_VALUE,1,INSTR(VAL.TIME_LEVEL_VALUE,'+',1,1) -1) FROM BIS_TARGET_VALUES VAL,BIS_BUSINESS_PLANS PLAN,BIS_TARGET_LEVELS LVL,GL_PERIODS GL WHERE VAL.TARGET_LEVEL_ID = LVL.TARGET_LEVEL_ID AND VAL.PLAN_ID = PLAN.PLAN_ID AND LVL.SHORT_NAME = 'POACTLKG_OU_M' AND GL.PERIOD_SET_NAME = SUBSTR(VAL.TIME_LEVEL_VALUE,1,INSTR(VAL.TIME_LEVEL_VALUE,'+',1,1)-1) AND GL.PERIOD_NAME = SUBSTR(VAL.TIME_LEVEL_VALUE,INSTR(VAL.TIME_LEVEL_VALUE,'+',1,1)+1)

View Text - HTML Formatted

SELECT LVL.WF_PROCESS
, PLAN.PLAN_ID
, PLAN.SHORT_NAME
, PLAN.VERSION_NO
, PLAN.CURRENT_PLAN_FLAG
, VAL.TIME_LEVEL_VALUE
, VAL.ORG_LEVEL_VALUE
, VAL.TARGET
, VAL.RANGE1_LOW
, VAL.RANGE1_HIGH
, VAL.RANGE2_LOW
, VAL.RANGE2_HIGH
, VAL.RANGE3_LOW
, VAL.RANGE3_HIGH
, VAL.ROLE1_ID
, VAL.ROLE2_ID
, VAL.ROLE3_ID
, VAL.ROLE1
, VAL.ROLE2
, VAL.ROLE3
, SUBSTR(VAL.TIME_LEVEL_VALUE
, INSTR(VAL.TIME_LEVEL_VALUE
, '+'
, 1
, 1)+1)
, TO_NUMBER(GL.PERIOD_YEAR)
, SUBSTR(VAL.TIME_LEVEL_VALUE
, 1
, INSTR(VAL.TIME_LEVEL_VALUE
, '+'
, 1
, 1) -1)
FROM BIS_TARGET_VALUES VAL
, BIS_BUSINESS_PLANS PLAN
, BIS_TARGET_LEVELS LVL
, GL_PERIODS GL
WHERE VAL.TARGET_LEVEL_ID = LVL.TARGET_LEVEL_ID
AND VAL.PLAN_ID = PLAN.PLAN_ID
AND LVL.SHORT_NAME = 'POACTLKG_OU_M'
AND GL.PERIOD_SET_NAME = SUBSTR(VAL.TIME_LEVEL_VALUE
, 1
, INSTR(VAL.TIME_LEVEL_VALUE
, '+'
, 1
, 1)-1)
AND GL.PERIOD_NAME = SUBSTR(VAL.TIME_LEVEL_VALUE
, INSTR(VAL.TIME_LEVEL_VALUE
, '+'
, 1
, 1)+1)