GL Trial Balance - Average

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Trial Balance - Average (XML)
Short Name: GLXAVTRB_XML
DB package: GL_GLXAVTRB_XMLP_PKG
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
GL_SRS_LEDGER_ID_UNVALIDATED
 
Number
Chart of Accounts ID
 
Number
Access Set ID
 
Number
Account To
 
Account From
 
Reporting Date
 
Date
Entered Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle