GL Consolidation - Audit

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Consolidation - Audit (XML)
Short Name: GLXCAR_XML
DB package: GL_GLXCAR_XMLP_PKG
Run GL Consolidation - Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
select  null  TO_FLEXDATA,
            decode(cc.summary_flag, 'Y', '*', '') SUMMARY,
            null FROM_FLEXDATA,
            (nvl(ca.entered_dr,0) - nvl(ca.entered_cr,0)) ACCOUNT_BAL,
            ca.request_id REQUEST_ID, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield', 'SQLGL', 'GL#', CA.CHART_OF_ACCOUNTS_ID, NULL, CA.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') TO_FLEXFIELD, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield_pad', 'SQLGL', 'GL#', CA.CHART_OF_ACCOUNTS_ID, NULL, CA.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') TO_FLEXFIELD_PAD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('from_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FROM_FLEXFIELD
from gl_code_combinations cc,
        gl_consolidation_audit ca
where ca.consolidation_id = :P_CONSOLIDATION_ID
and     &WHERE_BALANCE
and     ca.to_period_name = :P_PERIOD_NAME
and     ca.average_consolidation_flag = decode(:P_USAGE,'A','Y','N')
and     cc.code_combination_id = ca.from_code_combination_id
and     &WHERE_DR_CR_NOT_ZERO
ORDER BY 2 ASC , &ORDERBY_TO_FLEX , &ORDERBY_FROM_FLEX, ca.request_id , 4
Parameter Name SQL text Validation
Consolidation Definition 
 
 LOV Oracle
Period 
 
 LOV Oracle
Balance Type 
 
 LOV Oracle
Usage 
 
 LOV Oracle
Download
Related Blitz Reports
GL Consolidation - Disabled Parent Accounts GL Consolidation - Unmapped Subsidiary Accounts CE General Ledger Reconciliation GL Currency - Historical Rates Listing PA Cross Charge Audit AR Transactions and Lines XX AR Transactions and Lines GL Journals PA Cost Audit
Blitz Report™

Blitz Report™ provides multiple benefits: