VIEW: APPS.BIS_TARGET_VALUES_V

Source

View Text - Preformatted

SELECT A.TARGET_ID , A.TARGET_LEVEL_ID , A.PLAN_ID , B.NAME PLAN_NAME , A.ORG_LEVEL_VALUE , A.TIME_LEVEL_VALUE , A.DIMENSION1_LEVEL_VALUE , A.DIMENSION2_LEVEL_VALUE , A.DIMENSION3_LEVEL_VALUE , A.DIMENSION4_LEVEL_VALUE , A.DIMENSION5_LEVEL_VALUE , A.DIMENSION6_LEVEL_VALUE , A.DIMENSION7_LEVEL_VALUE , A.TARGET , A.RANGE1_LOW , A.RANGE1_HIGH , A.RANGE2_LOW , A.RANGE2_HIGH , A.RANGE3_LOW , A.RANGE3_HIGH , A.ROLE1_ID , A.ROLE2_ID , A.ROLE3_ID , A.ROLE1 , A.ROLE2 , A.ROLE3 , A.ROWID ROW_ID , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_LOGIN FROM BIS_TARGET_VALUES A, BIS_BUSINESS_PLANS_VL B WHERE A.PLAN_ID = B.PLAN_ID

View Text - HTML Formatted

SELECT A.TARGET_ID
, A.TARGET_LEVEL_ID
, A.PLAN_ID
, B.NAME PLAN_NAME
, A.ORG_LEVEL_VALUE
, A.TIME_LEVEL_VALUE
, A.DIMENSION1_LEVEL_VALUE
, A.DIMENSION2_LEVEL_VALUE
, A.DIMENSION3_LEVEL_VALUE
, A.DIMENSION4_LEVEL_VALUE
, A.DIMENSION5_LEVEL_VALUE
, A.DIMENSION6_LEVEL_VALUE
, A.DIMENSION7_LEVEL_VALUE
, A.TARGET
, A.RANGE1_LOW
, A.RANGE1_HIGH
, A.RANGE2_LOW
, A.RANGE2_HIGH
, A.RANGE3_LOW
, A.RANGE3_HIGH
, A.ROLE1_ID
, A.ROLE2_ID
, A.ROLE3_ID
, A.ROLE1
, A.ROLE2
, A.ROLE3
, A.ROWID ROW_ID
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
FROM BIS_TARGET_VALUES A
, BIS_BUSINESS_PLANS_VL B
WHERE A.PLAN_ID = B.PLAN_ID