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
Ask a question