View: RCI_FS_ACCT_EVAL_V

Product:	AMW - Internal Controls Manager
Description:	This View contains the definition for the Significant Accounts dimension
Implementation/DBA Data:	APPS.RCI_FS_ACCT_EVAL_V

View Text

SELECT B.OPINION_VALUE_CODE ID
, TL.OPINION_VALUE_NAME VALUE
, FO.OBJ_NAME OBJ_NAME
FROM AMW_OPINION_VALUES_B B
, AMW_OPINION_VALUES_TL TL
, AMW_OPINION_TYPES_B AOTB
, AMW_OPINION_COMPONTS_B AOCB
, AMW_OBJECT_OPINION_TYPES AOOT
, FND_OBJECTS FO
WHERE B.OPINION_VALUE_ID = TL.OPINION_VALUE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND (B.END_DATE IS NULL OR B.END_DATE >= SYSDATE)
AND B.OPINION_COMPONENT_ID=AOCB.OPINION_COMPONENT_ID
AND AOCB.OBJECT_OPINION_TYPE_ID = AOOT.OBJECT_OPINION_TYPE_ID
AND AOOT.OBJECT_ID=FO.OBJECT_ID
AND AOTB.OPINION_TYPE_ID=AOOT.OPINION_TYPE_ID
AND AOTB.OPINION_TYPE_CODE='EVALUATION'
AND AOCB.OPINION_COMPONENT_CODE='OVERALL' UNION SELECT AL.LOOKUP_CODE AS ID
, AL.MEANING AS VALUE
, 'AMW_KEY_ACCOUNT' AS OBJ_NAME
FROM AMW_LOOKUPS AL
WHERE AL.LOOKUP_TYPE='RCI_CERT_EVAL_STATUS'
AND AL.LOOKUP_CODE='NOT_EVALUATED'

Columns