XLA Trading Partner Summary

➜ Back to Library
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
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
Download
Related Blitz Reports
CE General Ledger Reconciliation GL Account Analysis ECC Payables, AP Closing, SQL2 AP Accounted Invoice Aging AR Open Items Revaluation GL Account Analysis (Distributions) XLA Import Initial Balance for Third Party Control Account ECC Payables, AP Closing, SQL4 ECC Receivables, AR Closing, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits: