IGI Subledger Security: Allocation Status - draft

➜ Back to Library
Description
Categories: BI Publisher
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
 
Char
Process Group Name
 
Char
Secure Table Name
 
Char
Download
Related Blitz Reports
IGI Subledger Security: Group Status - draft IGI Subledger Security: Secure Tables Status - draft IGI Subledger Security: Grouped Secure Tables - draft IGI Subledger Security: User Allocation Status - draft IGI Subledger Security: Object Status - draft IGI Subledger Security: Consolidation - draft INL Unaccounted Landed Costs for Full Returns IGI Secondary Invoice Approval : Secondary Approval of Invoices - draft IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use
Blitz Report™