GL Trial Balance - Average

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Average Balance Trial Balance Report
Application: General Ledger
Source: Trial Balance - Average (XML)
Short Name: GLXAVTRB_XML
DB package: GL_GLXAVTRB_XMLP_PKG
Run GL Trial Balance - Average and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	lr.target_ledger_name C_LEDGER_NAME,
	null 	C_MASTER,
	null	C_FLEXDATA_MASTER,
	&P_ENDING_BALANCE Ending_Balance,
	&P_PATD		P_PATD1,
	&P_QATD		P_QATD1,
	&P_YATD		P_YATD1,
	&P_PTD_AGGREGATE PTD_Aggregate,
	&P_QTD_AGGREGATE QTD_Aggregate,
	&P_YTD_AGGREGATE YTD_Aggregate,
                  DECODE(dbs.currency_type, 'O', '*', NULL) C_TYPE, 
	--null DISP_BAL_LPROMPT, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_bal_val', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') DISP_BAL_VAL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_bal_desc', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') DISP_BAL_DESC, 
	GL_GLXAVTRB_XMLP_PKG.end_bal(:END_BAL_Total) END_BAL, 
	GL_GLXAVTRB_XMLP_PKG.patd(:PTD_Aggregate_Total) PATD, 
	GL_GLXAVTRB_XMLP_PKG.qatd(:QTD_Aggregate_Total) QATD, 
	GL_GLXAVTRB_XMLP_PKG.yatd(:YTD_Aggregate_Total) YATD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_secure', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'SECURITY') BAL_SECURE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_flexfield', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') DISP_FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('disp_desc_all', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') DISP_DESC_ALL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_secure', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'SECURITY') FLEX_SECURE
FROM    
	GL_CODE_COMBINATIONS 	cc,
	GL_DAILY_BALANCES 	dbs,
	GL_LEDGERS		l,
	GL_LEDGER_SET_ASSIGNMENTS ls,
	GL_LEDGER_RELATIONSHIPS	lr
WHERE 
	cc.code_combination_id  = dbs.code_combination_id
AND	&WHERE_lexical
AND	l.ledger_id = :P_LEDGER_ID
AND	ls.ledger_set_id (+) = l.ledger_id
AND	lr.source_ledger_id = NVL(ls.ledger_id, :P_LEDGER_ID)
AND	lr.target_ledger_id = NVL(ls.ledger_id, :P_LEDGER_ID)
AND	lr.target_currency_code = :P_LEDGER_CURRENCY
&WHERE_DAS
AND	dbs.period_name = :PERIOD_NAME
AND	dbs.currency_code = :RESULTING_CURRENCY
AND           dbs.template_id is NULL
AND	&CURR_TYPE
AND	dbs.ledger_id = lr.target_ledger_id
AND	cc.chart_of_accounts_id = :STRUCT_NUM
ORDER  BY lr.target_ledger_name, &ORDERBY
Parameter Name SQL text Validation
Ledger/Ledger Set
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Entered Currency
 
LOV Oracle
Reporting Date
 
Date
Account From
 
Char
Account To
 
Char
Blitz Report™