IGI Subledger Security: Allocation Status - draft
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
Source: Subledger Security: Allocation Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSSA_XML
DB package: IGI_IGISLSSA_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 Name | SQL text | Validation | |
---|---|---|---|
SLS Security Group Name |
|
Char | |
Process Group Name |
|
Char | |
Secure Table Name |
|
Char |