IGI Subledger Security: Allocation Status - draft

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