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
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