IGI Balanced Budget History - draft

Description
Categories: BI Publisher, Financials
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
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
Data Access Set ID
 
Number
Chart of Accounts ID
 
LOV Oracle
Code Combination ID
 
Number
Currency Code
 
LOV Oracle
FISCAL YEAR
 
Number
Budget Version ID
 
Number
Ledger ID
 
LOV Oracle