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
Source: Subledger Security: Consolidation Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSCG_XML
DB package: IGI_IGISLSCG_XMLP_PKG
Run
IGI Subledger Security: Consolidation - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Source Group |
|
Char | |
Destination Group |
|
Char |