IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Unbalanced Budget History Report
Application: Public Sector Financials International
Source: Budgeting: UnBalanced Budget History Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBHRU_XML
DB package: IGI_IGIGBHRU_XMLP_PKG
Run IGI UnBalanced 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",
	null C_FLEXDATA,
	GSOB.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||'%',
                                                        	'IGIBUDNY', LU3.MEANING,
                                                        	NULL) "Additional", 
	LU4.MEANING "Recurring Entry",
	LU2.MEANING "Effect",
	BHE.NEXT_YEAR_BUDGET "Next Year Budget",
	BHE.REASON_CODE "Reason Code",
	BHE.GROUP_ID,
	PERIODS.PERIOD_NAME HEADER_PERIOD_NAME, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_desc_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') CF_DESC_ALL
FROM 	igi_bud_history_entries_v BHE,
         	igi_lookups LU1,
	igi_lookups LU2,
	igi_lookups LU3,
        	gl_code_combinations gcc,
         	gl_sets_of_books gsob,
         	gl_budget_versions GLBV,
	fnd_lookups LU4,
	gl_periods PERIODS
where 	BHE.SET_OF_BOOKS_ID = GSOB.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     	GCC.CODE_COMBINATION_ID = BHE.CODE_COMBINATION_ID
and     	GCC.CHART_OF_ACCOUNTS_ID = :P_COA_ID  
and     	LU1.LOOKUP_TYPE = 'IGI_BUD_TRANSACTION'
and     	LU1.LOOKUP_CODE =  BHE.TRANSACTION_TYPE
and     	GSOB.SET_OF_BOOKS_ID = :P_SET_OF_BOOKS_ID
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 	LU4.LOOKUP_TYPE = 'YES_NO'
and	LU4.LOOKUP_CODE = BHE.RECURRING
and	PERIODS.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE
and	PERIODS.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
AND	PERIODS.PERIOD_YEAR = BHE.FISCAL_YEAR
ORDER BY 1 ASC,3 ASC,9 ASC,4 ASC,5 ASC,6 ASC,11 ASC,7 ASC,8 ASC,10 ASC,12 ASC,13 ASC , BHE.POSTED_DATE DESC , PERIODS.PERIOD_NUM
Parameter Name SQL text Validation
Ledger ID 
 
 LOV Oracle
Budget Version ID 
 
 Number
FISCAL YEAR 
 
 Number
Currency Code 
 
 LOV Oracle
Code Combination ID 
 
 Number
Download
Related Blitz Reports
IGI Balanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use GL Balance FA Asset Summary (Germany) FA Asset Additions FA Asset Retirements PSB Budget Revisions Transaction
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™