IGI Maintain Code Combination Budget Control Flag - draft
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
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 |