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

ParameterTypeList of values SQL
Source GroupChar
Destination GroupChar