eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGI_SLS_DELETED_ALLOC_V

Source

View Text - Preformatted


SELECT sls_group, sls_group_type, sls_allocation, sls_allocation_type, date_enabled, date_disabled, date_removed, date_security_applied FROM IGI_SLS_ALLOCATIONS_AUDIT AU WHERE au.date_removed IS NOT NULL AND au.date_removed = (SELECT MAX(a1.date_removed) FROM igi_sls_allocations_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 a1.sls_allocation = au.sls_allocation AND a1.sls_allocation_type = au.sls_allocation_type) AND NOT EXISTS (SELECT 'X' FROM igi_sls_allocations a WHERE a.sls_group = au.sls_group AND a.sls_allocation = au.sls_allocation)

View Text - HTML Formatted

SELECT SLS_GROUP
, SLS_GROUP_TYPE
, SLS_ALLOCATION
, SLS_ALLOCATION_TYPE
, DATE_ENABLED
, DATE_DISABLED
, DATE_REMOVED
, DATE_SECURITY_APPLIED
FROM IGI_SLS_ALLOCATIONS_AUDIT AU
WHERE AU.DATE_REMOVED IS NOT NULL
AND AU.DATE_REMOVED = (SELECT MAX(A1.DATE_REMOVED)
FROM IGI_SLS_ALLOCATIONS_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 A1.SLS_ALLOCATION = AU.SLS_ALLOCATION
AND A1.SLS_ALLOCATION_TYPE = AU.SLS_ALLOCATION_TYPE)
AND NOT EXISTS (SELECT 'X'
FROM IGI_SLS_ALLOCATIONS A
WHERE A.SLS_GROUP = AU.SLS_GROUP
AND A.SLS_ALLOCATION = AU.SLS_ALLOCATION)