IGI Balanced Budget History Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Balanced Budget History Report
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget History Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBHRB_XML
DB package: IGI_IGIGBHRB_XMLP_PKG
Description: BUD: Budgeting: Balanced Budget History Report
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget History Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBHRB_XML
DB package: IGI_IGIGBHRB_XMLP_PKG
Run
IGI Balanced Budget History Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT GLBV.BUDGET_NAME Budget_Name, &P_FLEXDATA C_FLEXDATA, 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, SOB.NAME C_NAME, to_char(BHE.POSTED_DATE,'DD MON YYYY') Posted_Date, LU1.MEANING TRX_TYPE, BHE.CURRENT_YEAR_BUDGET Current_Year_Budget, BHE.PROFILE_CODE Profile_Code, BHE.START_PERIOD Start_Period, DECODE(BHE.TRANSACTION_TYPE, 'IGIGBUDIN', BHE.REFERENCE1||'%', 'IGIGBUDNY', LU3.MEANING, NULL) Additional, BHE.TRANSACTION_TYPE, FND.MEANING Recurring_Entr, LU2.MEANING EFFECT, BHE.NEXT_YEAR_BUDGET Next_Year_Budget, BHE.REASON_CODE Reason_Code FROM igi_bud_history_entries_v BHE, igi_lookups LU1, igi_lookups LU2, igi_lookups LU3, gl_code_combinations GL_CC, gl_sets_of_books SOB, gl_budget_versions GLBV, fnd_lookups FND WHERE BHE.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND BHE.CURRENCY_CODE = :P_Curr_Code AND BHE.CODE_COMBINATION_ID = :P_Code_Comb_ID AND BHE.FISCAL_YEAR = :P_Fiscal_Yr AND GLBV.BUDGET_VERSION_ID = BHE.BUDGET_VERSION_ID AND GLBV.BUDGET_VERSION_ID = :P_Budget_Version_ID AND GL_CC.CODE_COMBINATION_ID = BHE.CODE_COMBINATION_ID AND GL_CC.CHART_OF_ACCOUNTS_ID = :P_COA_ID AND SOB.SET_OF_BOOKS_ID =:P_SET_OF_BOOKS_ID AND LU1.LOOKUP_TYPE='IGI_BUD_TRANSACTION' AND LU1.LOOKUP_CODE=BHE.TRANSACTION_TYPE AND LU2.LOOKUP_TYPE='IGI_BUD_ENTRY_EFFECT' AND LU2.LOOKUP_CODE=NVL(BHE.EFFECT,'PYE') AND LU3.LOOKUP_TYPE(+) = 'IGI_BUD_PROFILE_METHOD' AND LU3.LOOKUP_CODE(+) = BHE.REFERENCE1 AND FND.LOOKUP_TYPE = 'YES_NO' AND FND.LOOKUP_CODE = BHE.RECURRING ORDER BY 1 ASC,2 ASC,3 ASC |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger ID |
|
LOV Oracle | |
Budget Version ID |
|
Number | |
FISCAL YEAR |
|
Number | |
Currency Code |
|
LOV Oracle | |
Code Combination ID |
|
Number |