XTR Intercompany - Letters

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Intercompany - Letters (XML)
Short Name: XTRLTIGI_XML
DB package: XTR_XTRLTIGI_XMLP_PKG
Run XTR Intercompany - Letters and other Oracle EBS reports with Blitz Report™ on our demo environment
select sum(a.balance_out)        BAL_OUT,
       max(a.transaction_number) T_NUM,
       a.currency                CCY
from XTR_INTERGROUP_TRANSFERS_V a
 where a.party_code = :PTY_CODE
 and   a.transfer_date||to_char(a.transaction_number) =
         (select max(b.transfer_date)||max(to_char(b.transaction_number))
           from XTR_INTERGROUP_TRANSFERS_V b
           where b.transfer_date <= :P_TO
		   and b.PARTY_CODE = :PTY_CODE)
		   group by a.party_code,a.currency
Parameter Name SQL text Validation
Period From 
 
 Date
Period To 
 
 Date
Company 
 
 LOV Oracle
Intercompany Party 
 
 LOV Oracle
Download
Related Blitz Reports
XTR Intercompany - Statements XTR Intercompany - Interest Settlement CE Cleared Transactions CE Transactions Available for Reconciliation XTR Positions - Treasury Consolidated Cashflows XTR Positions - Outstanding Hedge Instruments XTR Term Money - Retail Term Money Aging XTR Positions - Treasury Cashflows by Account XTR Positions - Currency Gain/Loss Revaluation
Blitz Report™

Blitz Report™ provides multiple benefits: