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 Cost Clearing Reconciliation - draft AR Transaction Types Listing INV Subinventory listing JA India - Debtors Ledger - draft CST Periodic Material and Receiving Distribution Details AR Potential Reconciling Items AR Open Balances Revaluation AR Deposit Balance Report - Japan CST Inventory Subledger
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: