IGI Process Impact Review Summary - draft

Description
Categories: BI Publisher, Financials
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
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
Data Access Set ID
 
Number
Chart of Accounts ID
 
LOV Oracle
Budget Version ID
 
Number
Group ID
 
Number
Fiscal Year
 
Number
Currency Code
 
LOV Oracle
Ledger ID
 
LOV Oracle
Ask a question