XTR Data Exchange - Market Data Transfer

Description
Categories: BI Publisher, Financials
Application: Treasury
Source: Data Exchange - Market Data Transfer Report (XML)
Short Name: XTRMDTRP_XML
DB package: XTR_XTRMDTRP_XMLP_PKG
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
Parameter Name SQL text Validation
Report Errors Only
 
LOV Oracle