XTR Positions - Outstanding Receivables / Payables

Description
Categories: BI Publisher
Application: Treasury
Source: Positions - Outstanding Receivables / Payables Report (XML)
Short Name: XTRHOAPR_XML
DB package: XTR_XTRHOAPR_XMLP_PKG
select d.company_code hp_company,
       hr.hedge_attribute_id hp_hedge_number,
       hr.primary_code hp_deal_no,
       trunc(d.value_date)-trunc(sysdate) hp_days_remaining,
       DECODE(hedge_currency
              ,currency_sell,currency_buy
                            ,currency_sell) hp_offset_currency,
       hr.cur_reference_amt hp_amount,
	&hp_amount_dsp hp_amount_dsp
from   xtr_hedge_relationships hr,
       xtr_hedge_attributes ha,
       xtr_deals_v d
where  d.deal_no = hr.primary_code
AND    d.company_code = nvl(:P_COMPANY_CODE,d.company_code)
AND    ha.hedge_currency = :P_CURRENCY
and    ha.hedge_attribute_id = hr.hedge_attribute_id
and    ha.hedge_status = 'CURRENT'
AND    d.value_date > sysdate
AND    trunc(d.value_date)-trunc(sysdate) > 0
AND   ha.hedge_attribute_id NOT IN (select hedge_attribute_id from xtr_hedge_relationships
                  where instrument_item_flag = 'U' group by hedge_attribute_id
                  having sum(cur_reference_amt) = 0)
order by 1,4,2
Parameter Name SQL text Validation
Search By
 
LOV Oracle
Criteria Set
 
LOV Oracle
Source
 
LOV Oracle
Currency
 
LOV Oracle
Company
 
LOV Oracle
SOB Currency
 
LOV Oracle
AP Discount
 
LOV Oracle
Factor
 
LOV Oracle
Due Date From
 
Date
Due Date To
 
Date
Include Unapplied Prepayments
 
LOV Oracle
Include Unapplied Receivables
 
LOV Oracle
Show Transactions
 
LOV Oracle
XTR_HEDGE_IS_ADVANCED
 
XTR_HEDGE_IS_BASIC
 
Criteria Set Owner
 
LOV Oracle
XTR_DUMMY
 
XTR_DUMMY_2