VIEW: APPS.BIS_INDICATOR_RESPS_V

Source

View Text - Preformatted

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'
   

View Text - HTML Formatted

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'