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
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 |