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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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