XTR Intercompany - Interest Settlement
Description
Categories: BI Publisher
Application: Treasury
Source: Intercompany - Interest Settlement Report (XML)
Short Name: XTRIGINS_XML
DB package: XTR_XTRIGINS_XMLP_PKG
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 |