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

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
Run IGI Process Impact Review Summary- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™