GL Budget - Unbudgeted Master/Detail Accounts
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Unbudgeted Master/Detail Accounts Report
Application: General Ledger
Source: Budget - Unbudgeted Master/Detail Accounts (XML)
Short Name: GLRRBUDA_XML
DB package: GL_GLXRBUDA_XMLP_PKG
Description: Unbudgeted Master/Detail Accounts Report
Application: General Ledger
Source: Budget - Unbudgeted Master/Detail Accounts (XML)
Short Name: GLRRBUDA_XML
DB package: GL_GLXRBUDA_XMLP_PKG
select &FLEXDATA FLEXDATA_H, &ACCOUNT_SEG ACCOUNT_SEG_H, glbv.budget_name Dep_Bud_Name, &PTD_YTD Dep_amount, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP FROM gl_code_combinations cs, gl_balances glbd, gl_budget_versions glbv where glbd.ledger_id = :P_LEDGER_ID AND glbd.currency_code = :P_CURRENCY_CODE AND glbd.period_name = :P_PERIOD_NAME AND glbd.actual_flag = 'B' AND glbd.code_combination_id = cs.code_combination_id AND glbd.budget_version_id in (select glbv1.budget_version_id from gl_budget_versions glbv1 where glbv1.control_budget_version_id = :P_BUDGET_VERSION_ID) AND glbd.budget_version_id = glbv.budget_version_id AND NVL(glbd.translated_flag,'R') = 'R' AND glbd.template_id is NOT NULL AND glbd.code_combination_id NOT IN (select glbc.code_combination_id from gl_balances glbc where glbc.ledger_id = :P_LEDGER_ID AND glbc.period_name = :P_PERIOD_NAME AND glbc.currency_code = :P_CURRENCY_CODE AND glbc.budget_version_id = :P_BUDGET_VERSION_ID AND glbc.actual_flag = 'B') &WHERE_DAS order by 1 ASC , &FLEX_ORDERBY, glbv.budget_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger | LOV Oracle | ||
Master Budget | LOV Oracle | ||
Period | LOV Oracle | ||
Currency | LOV Oracle | ||
Amount Type | LOV Oracle |