XTR Data Exchange - Market Data Transfer
Description
- Categories
- BI Publisher
- Application
- Treasury
- Source
- Data Exchange - Market Data Transfer Report (XML)
- Short Name
- XTRMDTRP_XML
- DB package
- XTR_XTRMDTRP_XMLP_PKG
SQL 4 lines
SELECT xmdi.source SOURCE, xmdi.external_ref_code EXTERNAL_REF_CODE, xmdi.bid BID, xmdi.ask ASK, xmdi.mid MID, xmdi.spread SPREAD, xmdi.datetime DATETIME, xmdi.return_code RETURN_CODE, xmdi.ref_code REF_CODE, fl.description RTN_DESC FROM xtr_market_data_interface xmdi, fnd_lookups fl WHERE nvl(:p_errors_only,'Y') = 'N' AND xmdi.return_code < 50 AND fl.lookup_type = 'XTR_MDTSF_RTN_CODES' AND xmdi.return_code = fl.lookup_code order by RETURN_CODE,RTN_DESC |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Report Errors Only | LOV Oracle |