IGI Process Impact Review - draft

Description
Categories: BI Publisher
Columns: C Flexdata, Ccid, Amend Old Bud, Amend New, Batch Name, Budget Name, Cf Flexfield, Cf Desc All, Cf Acc Desc, Cf Cost Desc ...
Application: Public Sector Financials International
Source: Budgeting: Process Impact Review (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIRR_XML
DB package: IGI_IGIGBIRR_XMLP_PKG
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
Chart of Accounts ID
 
LOV Oracle
Data Access Set ID
 
Number