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
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
Blitz Report™