XTR Admin - Cancelled Transactions Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Treasury
Source: Admin - Cancelled Transactions Summary Report (XML)
Short Name: XTRAUNCL_XML
DB package: XTR_XTRAUNCL_XMLP_PKG
Run XTR Admin - Cancelled Transactions Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select a.COMPANY_CODE            company,
       p.SHORT_NAME              company_name,
       a.DEAL_NO                 deal_no,
       a.TRANSACTION_NO          trans_no,
       a.CURRENCY                ccy,
       a.CPARTY_CODE             cparty,
       t.USER_DEAL_TYPE             type,
       s.USER_DEAL_SUBTYPE            subtype,
       a.PRODUCT_TYPE            product,
       a.CREATED_ON              created,
       a.UPDATED_ON              updated,
       substr(a.CREATED_BY,1,18) created_by,
       substr(a.UPDATED_BY,1,18) updated_by
from XTR_DEALS_V a,
     XTR_PARTIES_V p,
     XTR_DEAL_TYPES_V t,
    XTR_DEAL_SUBTYPES_V s
where a.STATUS_CODE = 'CANCELLED'
and a.DEAL_TYPE != 'ONC'
and a.COMPANY_CODE like nvl(upper(:COMP_CODE2),a.COMPANY_CODE)
and (a.UPDATED_ON between nvl(:CANCEL_FROM2,a.UPDATED_ON) and nvl(:CANCEL_TO2,a.UPDATED_ON) or a.UPDATED_ON is null)
and nvl(a.UPDATED_BY,'%') like nvl(upper(:CANCELLED_BY2),'%')
and a.DEAL_TYPE like nvl(upper(:DEAL_TYPE2),a.DEAL_TYPE)
and p.PARTY_CODE = a.COMPANY_CODE
and a.DEAL_TYPE = t.DEAL_TYPE
and a.DEAL_SUBTYPE = s.DEAL_SUBTYPE
UNION
select a.COMPANY_CODE            company,
       p.SHORT_NAME              company_name,
       a.DEAL_NUMBER             deal_no,
       a.TRANSACTION_NUMBER      trans_no,
       a.CURRENCY                ccy,
       a.CPARTY_CODE             cparty,
       t.USER_DEAL_TYPE          type,
       s.USER_DEAL_SUBTYPE       subtype,
       a.PRODUCT_TYPE            product,
       a.CREATED_ON              created,
       a.UPDATED_ON              updated,
       substr(a.CREATED_BY,1,18) created_by,
       substr(a.UPDATED_BY,1,18) updated_by
from XTR_ROLLOVER_TRANSACTIONS_V a,
     XTR_PARTIES_V p,
   XTR_DEAL_TYPES_V t,
     XTR_DEAL_SUBTYPES_V s
where a.STATUS_CODE = 'CANCELLED'
and a.DEAL_TYPE = 'ONC'
and a.COMPANY_CODE like nvl(upper(:COMP_CODE2),a.COMPANY_CODE)
and (a.UPDATED_ON between nvl(:CANCEL_FROM2,a.UPDATED_ON) and nvl(:CANCEL_TO2,a.UPDATED_ON) or a.UPDATED_ON is null)
and nvl(a.UPDATED_BY,'%') like nvl(upper(:CANCELLED_BY2),'%')
and a.DEAL_TYPE like nvl(upper(:DEAL_TYPE2),a.DEAL_TYPE)
and p.PARTY_CODE = a.COMPANY_CODE
and a.DEAL_TYPE = t.DEAL_TYPE
and a.DEAL_SUBTYPE = s.DEAL_SUBTYPE
order by 1,11
Parameter Name SQL text Validation
Company 
 
 LOV Oracle
Deal Type 
 
 LOV Oracle
Cancelled By 
 
 LOV Oracle
Cancelled Date From 
 
 Date
Cancelled Date To 
 
 Date
Download
 
Related Blitz Reports
XTR Term Money - By Type and Product XTR Positions - Interest Rate Hedges XTR Term Money - Retail Term Money Overdues XTR Positions - Outstanding Hedge Instruments XTR Term Money - Retail Term Money Aging XTR Positions - Treasury Cashflows by Account XTR Term Money - Retail Term Money Statements XTR Positions - Treasury Consolidated Cashflows XTR Positions - Discounted Securities Register
Blitz Report™

Blitz Report™ provides multiple benefits: