XLA Trading Partner Summary
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Subledger Accounting
Source: Trading Partner Summary Report
Short Name: XLATPSUMRPT
DB package: XLA_TP_SUMMARY_RPT_PKG
Application: Subledger Accounting
Source: Trading Partner Summary Report
Short Name: XLATPSUMRPT
DB package: XLA_TP_SUMMARY_RPT_PKG
Run
XLA Trading Partner Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT gcc.code_combination_id code_combination_id ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') accounting_flexfield ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') accounting_flexfield_desc &p_party_col ,HPS.party_site_name party_site_name ,MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.min_period(GPS.effective_period_num), NVL(XCB.beginning_balance_dr,0), 0))begin_balance_dr ,MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.min_period(GPS.effective_period_num), NVL(XCB.beginning_balance_cr,0), 0))begin_balance_cr ,MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.max_period(GPS.effective_period_num), (NVL(XCB.beginning_balance_dr,0)+ NVL(XCB.period_balance_dr,0)), 0)) - MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.min_period(GPS.effective_period_num), NVL(XCB.beginning_balance_dr,0), 0)) period_net_dr ,MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.max_period(GPS.effective_period_num), (NVL(XCB.beginning_balance_cr,0)+ NVL(XCB.period_balance_cr,0)), 0)) - MAX(DECODE(GPS.effective_period_num, XLA_TP_SUMMARY_RPT_PKG.min_period(GPS.effective_period_num), NVL(XCB.beginning_balance_cr,0), 0)) period_net_cr FROM xla_control_balances XCB ,gl_code_combinations GCC ,gl_period_statuses GPS ,hz_parties HZP ,hz_party_sites HPS &p_party_tab WHERE XCB.ledger_id = :P_LEDGER_ID AND XCB.application_id = :P_RESP_APPLICATION_ID AND XCB.period_name = GPS.period_name AND XCB.application_id = GPS.application_id AND XCB.ledger_id = GPS.ledger_id AND GPS.effective_period_num BETWEEN :P_PERIOD_NUM_FROM AND :P_PERIOD_NUM_TO AND GCC.code_combination_id = XCB.code_combination_id &p_party_join &p_party_name_join AND &ACCT_FLEX_WHERE_CLAUSE GROUP BY gcc.code_combination_id ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') &p_party_group ,HPS.party_site_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger Name |
|
LOV Oracle | |
Accounting Flexfield From |
|
Char | |
Accounting Flexfield To |
|
Char | |
Period From |
|
LOV Oracle | |
Period To |
|
LOV Oracle | |
Trading Partner Type |
|
LOV Oracle | |
Third Party Type |
|
LOV Oracle | |
Accounting Date From |
|
Date | |
Accounting Date To |
|
Date | |
Trading Partner Name From |
|
LOV Oracle | |
Trading Partner Name To |
|
LOV Oracle | |
Include Subsidiary Trading |
|
LOV Oracle |