VIEW: APPS.BIS_INVACC_ORG_MON_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 lvl.short_name = 'INVACC_ORG_MON' 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) and val.target_level_id = lvl.target_level_id and val.plan_id = plan.plan_id

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 LVL.SHORT_NAME = 'INVACC_ORG_MON'
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)
AND VAL.TARGET_LEVEL_ID = LVL.TARGET_LEVEL_ID
AND VAL.PLAN_ID = PLAN.PLAN_ID