View: IGI_SLS_DELETED_GROUPS_V

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

View Text

SELECT SLS_GROUP
, SLS_GROUP_TYPE
, DESCRIPTION
, DATE_ENABLED
, DATE_DISABLED
, DATE_REMOVED
, DATE_SECURITY_APPLIED
FROM IGI_SLS_GROUPS_AUDIT AU
WHERE AU.DATE_REMOVED IS NOT NULL
AND AU.DATE_REMOVED = (SELECT MAX(A1.DATE_REMOVED)
FROM IGI_SLS_GROUPS_AUDIT A1
WHERE A1.DATE_REMOVED IS NOT NULL
AND A1.SLS_GROUP = AU.SLS_GROUP
AND A1.SLS_GROUP_TYPE = AU.SLS_GROUP_TYPE)
AND NOT EXISTS (SELECT 'X'
FROM IGI_SLS_GROUPS G
WHERE G.SLS_GROUP = AU.SLS_GROUP)

Columns