View: RCI_BP_CERT_RESULT_V

Product:	AMW - Internal Controls Manager
Description:	This View contains the definition for the Business Process Certification Results dimension
Implementation/DBA Data:	APPS.RCI_BP_CERT_RESULT_V

View Text

SELECT B.OPINION_VALUE_CODE ID
, TL.OPINION_VALUE_NAME VALUE
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='CERTIFICATION'
AND FO.OBJ_NAME='AMW_ORGANIZATION' UNION ALL SELECT AL.LOOKUP_CODE ID
, AL.MEANING VALUE
FROM AMW_LOOKUPS AL
WHERE AL.LOOKUP_TYPE='RCI_CERT_EVAL_STATUS'
AND AL.LOOKUP_CODE='NOT_CERTIFIED'

Columns