IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Unbalanced Budget Journal Report
Application: Public Sector Financials International
Source: Budgeting: Unbalanced Budget Journal Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBJRU_XML
DB package: IGI_IGIGBJRU_XMLP_PKG
Run IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	lines.be_line_num,
	&P_FLEXDATA C_FLEXDATA,
	lines.recurring_entry,
	look.meaning,
	NVL(lines.next_year_budget,0) ny_bud,
	lines.reason_code,
	lines.be_header_id be_header_id1,
	periods.period_name,
	periods.period_number,
	NVL(periods.entered_dr,0) - NVL(periods.entered_cr,0) amount,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', comb.CHART_OF_ACCOUNTS_ID, NULL, comb.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD
FROM	igi_bud_journal_lines lines,
	igi_lookups look,
	gl_code_combinations comb,
	igi_bud_journal_periods periods
WHERE 	look.lookup_type = 'IGI_BUD_ENTRY_EFFECT'
AND 	look.lookup_code = nvl(lines.fye_pye_entry,'PYE')
AND 	comb.code_combination_id = lines.code_combination_id
AND	comb.chart_of_accounts_id = :P_COA
AND 	lines.be_header_id = periods.be_header_id
AND	lines.be_line_num = periods.be_line_num 
 and lines.be_header_id=:BE_HEADER_ID
ORDER BY be_line_num, period_number
Parameter Name SQL text Validation
Ledger ID 2 
 
 LOV Oracle
Batch Name 
 
 LOV Oracle
Download
Related Blitz Reports
IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use IGI Balanced Budget History Report- Not Supported: Reserved For Future Use IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use IGI Profile Code Listing- Not Supported: Reserved For Future Use IGI Reason Code Listing- Not Supported: Reserved For Future Use IGI Range Code Listing- Not Supported: Reserved For Future Use IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use GL Journals - Check
Blitz Report™

Blitz Report™ provides multiple benefits: