View: BIS_INDICATOR_RESPS_V

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

View Text

SELECT IR.ROWID ROW_ID
, IR.INDICATOR_RESP_ID
, IR.RESPONSIBILITY_ID
, R.RESPONSIBILITY_NAME
, TL.INDICATOR_ID
, I.NAME INDICATOR_NAME
, IR.TARGET_LEVEL_ID
, TL.NAME TARGET_LEVEL_NAME
, IR.CREATION_DATE
, IR.CREATED_BY
, IR.LAST_UPDATE_DATE
, IR.LAST_UPDATED_BY
, IR.LAST_UPDATE_LOGIN
FROM BIS_INDICATOR_RESPS IR
, FND_RESPONSIBILITY_VL R
, BIS_TARGET_LEVELS_VL TL
, BIS_INDICATORS_VL I
WHERE IR.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND IR.TARGET_LEVEL_ID = TL.TARGET_LEVEL_ID
AND TL.INDICATOR_ID = I.INDICATOR_ID
AND NVL(I.OBSOLETE
, 'F') = 'F'

Columns