VIEW: APPS.AMW_DELETE_OBJECT_VL

Source

View Text - Preformatted

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) and risk.curr_approved_flag ='Y' and risk.approval_status = 'A' and risk.approval_date is not null and (risk.end_date is null or risk.end_date >= sysdate) 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) and ctrl.curr_approved_flag = 'Y' and ctrl.approval_status = 'A' and ctrl.approval_date is not null and (ctrl.end_date is null or ctrl.end_date >= sysdate) 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) and ap.approval_status = 'A' and ap.curr_approved_flag = 'Y' and ap.approval_date is not null and (ap.end_date is null or ap.end_date >= sysdate)

View Text - HTML Formatted

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)
AND RISK.CURR_APPROVED_FLAG ='Y'
AND RISK.APPROVAL_STATUS = 'A'
AND RISK.APPROVAL_DATE IS NOT NULL
AND (RISK.END_DATE IS NULL OR RISK.END_DATE >= SYSDATE) 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)
AND CTRL.CURR_APPROVED_FLAG = 'Y'
AND CTRL.APPROVAL_STATUS = 'A'
AND CTRL.APPROVAL_DATE IS NOT NULL
AND (CTRL.END_DATE IS NULL OR CTRL.END_DATE >= SYSDATE) 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)
AND AP.APPROVAL_STATUS = 'A'
AND AP.CURR_APPROVED_FLAG = 'Y'
AND AP.APPROVAL_DATE IS NOT NULL
AND (AP.END_DATE IS NULL OR AP.END_DATE >= SYSDATE)