View: BIS_MRPOTALL_V

Product:	BIS - Applications BIS
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BIS_MRPOTALL_V

View Text

SELECT LVL.WF_PROCESS
, PLAN.PLAN_ID
, PLAN.SHORT_NAME
, PLAN.VERSION_NO
, PLAN.CURRENT_PLAN_FLAG
, VAL.TIME_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
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 = 'MRPOTALL'

Columns