XTR Intercompany - Interest Settlement

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Intercompany - Interest Settlement Report (XML)
Short Name: XTRIGINS_XML
DB package: XTR_XTRIGINS_XMLP_PKG
Run XTR Intercompany - Interest Settlement and other Oracle EBS reports with Blitz Report™ on our demo environment
select P.PARTY_CODE   PTY_CODE,
           P.SHORT_NAME   PTY_NAME
from XTR_PARTIES_V P 		
where  (CROSS_REF_TO_OTHER_PARTY = nvl(:p_company,P.CROSS_REF_TO_OTHER_PARTY)
and internal_pty = 'Y')
and ( exists (select 1 from  XTR_BANK_BALANCES_V 	B
                      where B.BALANCE_DATE >= Nvl(:P_From,B.Balance_Date)
                      and     B.BALANCE_DATE <= Nvl(:P_To,B.Balance_Date)
                      and    nvl(b.interest_settled,0) != 0
                      and   	B.COMPANY_CODE =  P.PARTY_CODE)
          or
          exists (select 1 from  XTR_INTERGROUP_TRANSFERS_V T
                       where 	Nvl(T.INTEREST_SETTLED,0) != 0
                       and   	T.TRANSFER_DATE >= Nvl(:P_From,T.Transfer_Date)
                       and        T.TRANSFER_DATE <= Nvl(:P_To,T.Transfer_Date)
                       and   	T.PARTY_CODE = P.PARTY_CODE) )
Parameter Name SQL text Validation
Company 
 
 LOV Oracle
From Date 
 
 Date
To Date 
 
 Date
Download
 
Related Blitz Reports
XTR Intercompany - Statements XTR Intercompany - Letters CE General Ledger Reconciliation XTR Term Money - By Type and Product CE General Ledger Cash Account Usage CE Cleared Transactions CE Sweep Transactions Generation Execution - draft XTR Settlements - Daily Payments / Receipts Letters CE Cash Forecast Template Listing - draft
Blitz Report™

Blitz Report™ provides multiple benefits: