VIEW: APPS.IGI_SLS_DELETED_TABLES_V

Source

View Text - Preformatted

SELECT owner, table_name, description, sls_table_name, update_allowed, date_enabled, date_disabled, date_removed, date_object_created , date_security_applied FROM IGI_SLS_SECURE_TABLES_AUDIT AU WHERE au.date_removed IS NOT NULL AND au.date_removed = (SELECT MAX(a1.date_removed) FROM igi_sls_secure_tables_audit a1 WHERE a1.date_removed IS NOT NULL AND a1.table_name = au.table_name AND a1.owner = au.owner) AND NOT EXISTS (SELECT 'X' FROM igi_sls_secure_tables t WHERE t.table_name = au.table_name AND t.owner = au.owner)

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, DESCRIPTION
, SLS_TABLE_NAME
, UPDATE_ALLOWED
, DATE_ENABLED
, DATE_DISABLED
, DATE_REMOVED
, DATE_OBJECT_CREATED
, DATE_SECURITY_APPLIED
FROM IGI_SLS_SECURE_TABLES_AUDIT AU
WHERE AU.DATE_REMOVED IS NOT NULL
AND AU.DATE_REMOVED = (SELECT MAX(A1.DATE_REMOVED)
FROM IGI_SLS_SECURE_TABLES_AUDIT A1
WHERE A1.DATE_REMOVED IS NOT NULL
AND A1.TABLE_NAME = AU.TABLE_NAME
AND A1.OWNER = AU.OWNER)
AND NOT EXISTS (SELECT 'X'
FROM IGI_SLS_SECURE_TABLES T
WHERE T.TABLE_NAME = AU.TABLE_NAME
AND T.OWNER = AU.OWNER)