View: IGI_SLS_DELETED_ALLOC_V

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

View Text

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)

Columns