XTR Positions - Outstanding Receivables / Payables
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Positions - Outstanding Receivables / Payables Report
Application: Treasury
Source: Positions - Outstanding Receivables / Payables Report (XML)
Short Name: XTRHOAPR_XML
DB package: XTR_XTRHOAPR_XMLP_PKG
Description: Positions - Outstanding Receivables / Payables Report
Application: Treasury
Source: Positions - Outstanding Receivables / Payables Report (XML)
Short Name: XTRHOAPR_XML
DB package: XTR_XTRHOAPR_XMLP_PKG
Run
XTR Positions - Outstanding Receivables / Payables and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
