IGI Process Impact Review Summary- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- Budgeting: Process Impact Review Summary (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGIGBIRS_XML
- DB package
- IGI_IGIGBIRS_XMLP_PKG
Imported from BI Publisher
BUD: Budgeting: Process Impact Review Summary Report
BUD: Budgeting: Process Impact Review Summary Report
SQL 23 lines
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') |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger ID | LOV Oracle | |
| Currency Code | LOV Oracle | |
| Fiscal Year | Number | |
| Group ID | Number | |
| Budget Version ID | Number |