IGI Process Impact Review Summary- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Process Impact Review Summary Report
Application: Public Sector Financials International
Source: Budgeting: Process Impact Review Summary (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIRS_XML
DB package: IGI_IGIGBIRS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT 	null C_FLEXDATA, 
	gl_cc.CODE_COMBINATION_ID CCID,
	SUM(NVL(gi.ENTERED_DR,0) - nvl(gi.ENTERED_CR,0)) amend_old_bud,
	SUM(nvl(gi.REFERENCE28,0)) amend_new,
	MIN(gi.REFERENCE1) batch_name,
	BUDGET_NAME, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_desc_all', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') CF_DESC_ALL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_acc_desc', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') CF_ACC_DESC, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_cost_desc', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'DESCRIPTION') CF_COST_DESC
FROM 	GL_CODE_COMBINATIONS gl_cc,
	GL_INTERFACE gi,
	GL_BUDGET_VERSIONS gb
WHERE	gl_cc.CHART_OF_ACCOUNTS_ID = :P_COA_ID	
AND	gl_cc.CODE_COMBINATION_ID = gi.CODE_COMBINATION_ID
AND	gi.LEDGER_ID = :P_SOB
AND	gi.CURRENCY_CODE = :P_C_CODE
AND	gi.BUDGET_VERSION_ID = :P_BUD_VER_ID
AND 	gi.GROUP_ID = :P_GROUP_ID
AND	gi.STATUS = 'IGIG-NEW'
AND 	gb.BUDGET_VERSION_ID = gi.BUDGET_VERSION_ID
GROUP BY gl_cc.CODE_COMBINATION_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), BUDGET_NAME,fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_desc_all', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_acc_desc', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION'),fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_cost_desc', 'SQLGL', 'GL#', gl_cc.CHART_OF_ACCOUNTS_ID, NULL, gl_cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'DESCRIPTION')
Parameter Name SQL text Validation
Ledger ID 
 
 LOV Oracle
Currency Code 
 
 LOV Oracle
Fiscal Year 
 
 Number
Group ID 
 
 Number
Budget Version ID 
 
 Number
Download
 
Related Blitz Reports
GL Account Analysis GL Account Analysis (Distributions) 11g XXRG GL Account Analysis ECC Projects, Projects Costing: Transactions, SQL1 GL Account Analysis (Distributions) EOS GL Account Analysis EOS GL Account Analysis with Tax GL Account Analysis 11g IGI Process Impact Review- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: