IGI Subledger Security: Consolidation - draft
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- Subledger Security: Consolidation Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGISLSCG_XML
- DB package
- IGI_IGISLSCG_XMLP_PKG
SQL 8 lines
select from_sls_security_group, to_sls_security_group,mt_date mt_date1,date_security_applied date_security_applied1, to_char(mt_date,'DD-MON-YYYY HH24:MI:SS') mt_date, to_char(date_security_applied,'DD-MON-YYYY HH24:MI:SS') date_security_applied, IGI_IGISLSCG_XMLP_PKG.cf_1formula(to_sls_security_group) CF_1 from igi_sls_consolidate_groups WHERE from_sls_security_group LIKE :P_FROM_SLS_SECURITY_GROUP_T AND to_sls_security_group LIKE :P_TO_SLS_SECURITY_GROUP_T order by 2,3,4 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Source Group | Char | |
| Destination Group | Char |