VIEW: APPS.IGI_SLS_DELETED_GROUPS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)