VIEW: APPS.IGI_SLS_ENABLED_ALLOC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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