Reports2017-11-18T12:27:27+00:00

IGI Unbalanced Budget Journal - draft

Description
Categories: BI Publisher, Financials
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
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
Data Access Set ID
 
Number
Ledger ID
 
LOV Oracle
Batch Name
 
LOV Oracle
Ledger ID
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept