View: AMW_DELETE_OBJECT_VL

Product:	AMW - Internal Controls Manager
Description:	View that lists all the risks, controls and audit procedures.
Implementation/DBA Data:	APPS.AMW_DELETE_OBJECT_VL

View Text

SELECT RISK.ROW_ID
, LKUP.MEANING OBJECT_TYPE
, RISK.RISK_ID OBJECT_ID
, RISK.NAME OBJECT_NAME
, 'RISK#'||RISK.RISK_ID TYPE_AND_ID
FROM AMW_RISKS_ALL_VL RISK
, AMW_LOOKUPS LKUP
WHERE LKUP.LOOKUP_TYPE = 'AMW_OBJECT_TYPE'
AND LKUP.LOOKUP_CODE = 'RISK'
AND LKUP.ENABLED_FLAG ='Y'
AND (LKUP.END_DATE_ACTIVE > SYSDATE OR LKUP.END_DATE_ACTIVE IS NULL) UNION ALL SELECT CTRL.ROW_ID
, LKUP.MEANING OBJECT_TYPE
, CTRL.CONTROL_ID OBJECT_ID
, CTRL.NAME OBJECT_NAME
, 'CTRL#'||CTRL.CONTROL_ID TYPE_AND_ID
FROM AMW_CONTROLS_ALL_VL CTRL
, AMW_LOOKUPS LKUP
WHERE LKUP.LOOKUP_TYPE = 'AMW_OBJECT_TYPE'
AND LKUP.LOOKUP_CODE = 'CTRL'
AND LKUP.ENABLED_FLAG ='Y'
AND (LKUP.END_DATE_ACTIVE > SYSDATE OR LKUP.END_DATE_ACTIVE IS NULL) UNION ALL SELECT AP.ROW_ID
, LKUP.MEANING OBJECT_TYPE
, AP.AUDIT_PROCEDURE_ID OBJECT_ID
, AP.NAME OBJECT_NAME
, 'AP#'||AP.AUDIT_PROCEDURE_ID TYPE_AND_ID
FROM AMW_AUDIT_PROCEDURES_VL AP
, AMW_LOOKUPS LKUP
WHERE LKUP.LOOKUP_TYPE = 'AMW_OBJECT_TYPE'
AND LKUP.LOOKUP_CODE = 'AP'
AND LKUP.ENABLED_FLAG ='Y'
AND (LKUP.END_DATE_ACTIVE > SYSDATE OR LKUP.END_DATE_ACTIVE IS NULL)

Columns