IGI Maintain Code Combination Budget Control Flag - draft

➜ Back to Library

Description
Categories: BI Publisher, Financials 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 more less

Copy

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

Chart of Accounts ID

LOV Oracle

Data Access Set ID

Number

To Flexfield

From Flexfield

Download

Related Blitz Reports
INV Organization parameters listing FA Cost Clearing Reconciliation - draft FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) INV Subinventory listing INV Material account distribution detail WIP Repetitive Schedule Data WIP Discrete Job Data AR Potential Reconciling Items WIP Value AR Open Balances Revaluation