View: IGI_SLS_DELETED_TABLES_V

Product:	IGI - Public Sector Financials International
Description:	This view provides information on deleted secure tables
Implementation/DBA Data:	APPS.IGI_SLS_DELETED_TABLES_V

View Text

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)

Columns