IGI Subledger Security: Allocation Status - draft

Description
Categories: BI Publisher
Columns: Grp Table Name, Grp Table Enabled, Grp Table Disabled, Grp Table Removed, Grp Table Enabled C, Grp Table Disabled C, Grp Table Removed C, Grp For Tab Name1 ...
Application: Public Sector Financials International
Source: Subledger Security: Allocation Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSSA_XML
DB package: IGI_IGISLSSA_XMLP_PKG
SELECT a.sls_allocation           grp_table_name,
               a.date_enabled            grp_table_enabled,
               a.date_disabled           grp_table_disabled,
               a.date_removed          grp_table_removed,
               to_char(a.date_enabled,'DD-MON-RRRR HH24:MI:SS')            grp_table_enabled_c,
               to_char(a.date_disabled,'DD-MON-RRRR HH24:MI:SS')           grp_table_disabled_c,
               to_char(a.date_removed,'DD-MON-RRRR HH24:MI:SS')          grp_table_removed_c,
               a.sls_group                  grp_for_tab_name1
FROM   igi_sls_allocations a
WHERE  a.sls_group_type      = 'S'
AND      a.sls_allocation_type = 'T'
and a.sls_group=:grp_for_tab_name
UNION
SELECT a.sls_allocation           grp_table_name,
               a.date_enabled            grp_table_enabled,
               a.date_disabled           grp_table_disabled,
               a.date_removed          grp_table_removed,
               to_char(a.date_enabled,'DD-MON-RRRR HH24:MI:SS')            grp_table_enabled_c,
               to_char(a.date_disabled,'DD-MON-RRRR HH24:MI:SS')           grp_table_disabled_c,
               to_char(a.date_removed,'DD-MON-RRRR HH24:MI:SS')          grp_table_removed_c,
               a.sls_group                  grp_for_tab_name1
FROM   igi_sls_deleted_alloc_v a
WHERE  a.sls_group_type      = 'S'
AND      a.sls_allocation_type = 'T'
 and a.sls_group=:grp_for_tab_name
ORDER BY 1
Parameter NameSQL textValidation
SLS Security Group Name
 
Process Group Name
 
Secure Table Name