IGI Maintain Code Combination Budget Control Flag - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Financials International
Source: Budgeting: Maintain Code Combination Budget Control Flag (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBUCC_XML
DB package: IGI_IGIGBUCC_XMLP_PKG 
SELECT
	null FLEXDATA,
	cc.code_combination_id ccid,
	'N' no_data, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flex_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') CF_FLEX_DESC, 
	IGI_IGIGBUCC_XMLP_PKG.cf_updateformula(cc.code_combination_id) CF_UPDATE, 
	IGI_IGIGBUCC_XMLP_PKG.cf_no_data_foundformula('N') CF_NO_DATA_FOUND
FROM
	gl_code_combinations cc
WHERE	cc.chart_of_accounts_id =:P_COA_ID
AND	&CP_WHERE_FLEX
ORDER BY
	&CP_SELECT_ALL,
	ccid
Parameter Name SQL text Validation
From Flexfield 
 
To Flexfield 
 
Data Access Set ID 
 
 Number
Chart of Accounts ID 
 
 LOV Oracle
Download
Related Blitz Reports
INV Organization parameters listing FA Asset Retirements AR Transaction Types BR100 FA Asset Retirements Report- Not Supported: Reserved For Future Use ECC Payables, AP Closing, SQL2 ECC Payables, AP Closing, SQL1 GL Account Analysis WIP Repetitive Schedule Data ECC Projects, Projects Costing: Transactions OPM2
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: