Product: | AMW - Internal Controls Manager (Obsolete) |
---|---|
Description: | AMW_CONTROLS_ALL_VL is a view that joins the translated, language specific values from AMW_CONTROLS_TL with the non-displayed data from AMW_CONTROLS_B to form complete Control entities. |
Implementation/DBA Data: | Not implemented in this database |
SELECT B.ROWID ROW_ID
, B.CONTROL_ID CONTROL_ID
, B.CONTROL_REV_ID CONTROL_REV_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.CONTROL_TYPE CONTROL_TYPE
, B.CATEGORY CATEGORY
, B.SOURCE SOURCE
, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.ATTRIBUTE11 ATTRIBUTE11
, B.ATTRIBUTE12 ATTRIBUTE12
, B.ATTRIBUTE13 ATTRIBUTE13
, B.ATTRIBUTE14 ATTRIBUTE14
, B.ATTRIBUTE15 ATTRIBUTE15
, B.CONTROL_LOCATION CONTROL_LOCATION
, B.AUTOMATION_TYPE AUTOMATION_TYPE
, B.APPLICATION_ID APPLICATION_ID
, B.JOB_ID JOB_ID
, B.SECURITY_GROUP_ID SECURITY_GROUP_ID
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.REV_NUM REV_NUM
, B.END_DATE END_DATE
, B.APPROVAL_STATUS APPROVAL_STATUS
, B.APPROVAL_DATE APPROVAL_DATE
, B.REQUESTOR_ID REQUESTOR_ID
, B.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, B.CREATED_BY_MODULE CREATED_BY_MODULE
, B.CURR_APPROVED_FLAG CURR_APPROVED_FLAG
, B.LATEST_REVISION_FLAG LATEST_REVISION_FLAG
, B.PREVENTIVE_CONTROL PREVENTIVE_CONTROL
, B.DETECTIVE_CONTROL DETECTIVE_CONTROL
, B.DISCLOSURE_CONTROL DISCLOSURE_CONTROL
, B.KEY_MITIGATING KEY_MITIGATING
, B.VERIFICATION_SOURCE VERIFICATION_SOURCE
, B.UOM_CODE UOM_CODE
, B.CONTROL_FREQUENCY CONTROL_FREQUENCY
, B.CLASSIFICATION CLASSIFICATION
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, T.PHYSICAL_EVIDENCE PHYSICAL_EVIDENCE
, T.VERIFICATION_SOURCE_NAME VERIFICATION_SOURCE_NAME
, T.VERIFICATION_INSTRUCTION VERIFICATION_INSTRUCTION
FROM AMW_CONTROLS_B B
, AMW_CONTROLS_TL T
WHERE B.CONTROL_REV_ID=T.CONTROL_REV_ID
AND T.LANGUAGE=USERENV('LANG')