View: IGI_SLS_ENABLED_ALLOC_V

Product:	IGI - Public Sector Financials International
Description:	This view provides information on enabled groups and secure tables
Implementation/DBA Data:	APPS.IGI_SLS_ENABLED_ALLOC_V

View Text

SELECT A.SLS_GROUP SLS_GROUP
, A.SLS_ALLOCATION TABLE_NAME
FROM IGI_SLS_ALLOCATIONS A
, IGI_SLS_SECURE_TABLES B
, IGI_SLS_GROUPS C
WHERE A.SLS_GROUP = C.SLS_GROUP
AND A.SLS_GROUP_TYPE = 'S'
AND A.SLS_ALLOCATION = B.TABLE_NAME
AND A.SLS_ALLOCATION_TYPE = 'T'
AND C.SLS_GROUP_TYPE = 'S'
AND A.DATE_REMOVED IS NULL
AND A.DATE_DISABLED IS NULL
AND B.DATE_REMOVED IS NULL
AND B.DATE_DISABLED IS NULL
AND C.DATE_REMOVED IS NULL
AND C.DATE_DISABLED IS NULL UNION SELECT A.SLS_GROUP SLS_GROUP
, D.SLS_ALLOCATION TABLE_NAME
FROM IGI_SLS_ALLOCATIONS A
, IGI_SLS_SECURE_TABLES B
, IGI_SLS_GROUPS C
, IGI_SLS_ALLOCATIONS D
, IGI_SLS_GROUPS E
WHERE A.SLS_GROUP = C.SLS_GROUP
AND A.SLS_GROUP_TYPE = 'S'
AND A.SLS_ALLOCATION_TYPE = 'P'
AND C.SLS_GROUP_TYPE = 'S'
AND A.SLS_ALLOCATION = D.SLS_GROUP
AND D.SLS_GROUP_TYPE = 'P'
AND D.SLS_GROUP = E.SLS_GROUP
AND D.SLS_GROUP_TYPE = 'P'
AND D.SLS_ALLOCATION = B.TABLE_NAME
AND D.SLS_ALLOCATION_TYPE = 'T'
AND E.SLS_GROUP_TYPE = 'P'
AND A.DATE_REMOVED IS NULL
AND A.DATE_DISABLED IS NULL
AND B.DATE_REMOVED IS NULL
AND B.DATE_DISABLED IS NULL
AND C.DATE_REMOVED IS NULL
AND C.DATE_DISABLED IS NULL
AND D.DATE_REMOVED IS NULL
AND D.DATE_DISABLED IS NULL
AND E.DATE_REMOVED IS NULL
AND E.DATE_DISABLED IS NULL

Columns