IGI Process Impact Review - draft
Description
Categories: BI Publisher
Columns: C Flexdata, Ccid, Amend Old Bud, Amend New, Batch Name, Budget Name, Cf Flexfield, Cf Desc All, Cf Acc Desc, Cf Cost Desc ...
Columns: C Flexdata, Ccid, Amend Old Bud, Amend New, Batch Name, Budget Name, Cf Flexfield, Cf Desc All, Cf Acc Desc, Cf Cost Desc ...
Application: Public Sector Financials International
Source: Budgeting: Process Impact Review (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIRR_XML
DB package: IGI_IGIGBIRR_XMLP_PKG
Source: Budgeting: Process Impact Review (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIRR_XML
DB package: IGI_IGIGBIRR_XMLP_PKG
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') |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger ID |
|
LOV Oracle | |
Currency Code |
|
LOV Oracle | |
Fiscal Year |
|
Number | |
Group ID |
|
Number | |
Budget Version ID |
|
Number | |
Chart of Accounts ID |
|
LOV Oracle | |
Data Access Set ID |
|
Number |