IGI Process Impact Review - draft

➜ Back to Library
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
Download
Related Blitz Reports
ECC Projects, Projects Costing: Transactions IGI Process Impact Review Summary - draft GL Account Analysis (Distributions) GL Account Analysis 11g COPY OF: GL Account Analysis GL Account Analysis GL Account Analysis 11i GL Budget - Organization Listing GL Budget - Master/Detail
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: