GL Consolidation - Disabled Parent Accounts

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Consolidation - Disabled Parent Accounts (XML)
Short Name: GLXDDA_XML
DB package: GL_GLXDDA_XMLP_PKG
Run GL Consolidation - Disabled Parent Accounts and other Oracle EBS reports with Blitz Report™ on our demo environment
select distinct null C_FLEXDATA, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Flexfield, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('description', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') Description
from   gl_consolidation_audit   GLCA,
          gl_code_combinations   GLCC
where GLCA.consolidation_id         =
                     to_number(:P_CONSOLIDATION_ID)
--and     &P_FLEXDATA1                  = &P_FLEXDATA2
and     GLCA.to_period_name          = :P_PERIOD_NAME
and     GLCC.template_id               is NULL
and     GLCC.chart_of_accounts_id = to_number(:STRUCT_NUM)
and     ( glcc.enabled_flag = 'N'  
               OR  ((sign(glcc.start_date_active - sysdate) = 1)
                    or (sign(glcc.end_date_active - sysdate) = -1)))
and    &WHERE_DR_CR_NOT_ZERO
order by  1
Parameter Name SQL text Validation
Consolidation Definition 
 
 LOV Oracle
Parent Period 
 
 LOV Oracle
Download
Related Blitz Reports
GL Consolidation - Audit 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 PA Cost Audit GCS Consolidation Entries Writeback
Blitz Report™

Blitz Report™ provides multiple benefits: