XTR Intercompany - Letters

Description
Categories: BI Publisher, Financials
Application: Treasury
Source: Intercompany - Letters (XML)
Short Name: XTRLTIGI_XML
DB package: XTR_XTRLTIGI_XMLP_PKG
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
Intercompany Party
 
LOV Oracle
Company
 
LOV Oracle
Period To
 
Date
Period From
 
Date