View: XTR_FX_ELIGIBLE_DEALS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_FX_ELIGIBLE_DEALS_V

View Text

SELECT NULL ACCOUNT_NO
, BROKERAGE_AMOUNT BROKERAGE_AMOUNT
, NULL CAP_OR_FLOOR
, COMPANY_CODE COMPANY_CODE
, NULL CONTRACT_CODE
, CURRENCY_BUY CURRENCYA
, CURRENCY_SELL CURRENCYB
, DEAL_DATE DEAL_DATE
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, NVL(DISCOUNT
, 'N') DISCOUNT_YIELD
, NVL(START_DATE
, VALUE_DATE) EFFECTIVE_DATE
, DECODE(DEAL_SUBTYPE
, 'SPOT'
, NVL(START_DATE
, VALUE_DATE)
, DEAL_DATE) ELIGIBLE_DATE
, EXPIRY_DATE EXPIRY_DATE
, BUY_AMOUNT FACE_VALUE
, 0 FX_REVAL_PRINCIPAL_BAL
, SELL_AMOUNT FXO_SELL_REF_AMOUNT
, MARKET_DATA_SET MARKET_DATA_SET
, MATURITY_DATE MATURITY_DATE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PREMIUM_ACTION PREMIUM_ACTION
, PREMIUM_AMOUNT PREMIUM_AMOUNT
, NULL PREMIUM_CCY
, PRICING_MODEL PRICING_MODEL
, PRODUCT_TYPE PRODUCT_TYPE
, SETTLE_ACTION SETTLE_ACTION
, SETTLE_AMOUNT SETTLE_AMOUNT
, SETTLE_DATE SETTLE_DATE
, START_DATE START_DATE
, STATUS_CODE STATUS_CODE
, NULL SWAP_REF
, NVL(TRANSACTION_NO
, 1) TRANSACTION_NO
, TRANSACTION_RATE TRANSACTION_RATE
, YEAR_BASIS YEAR_BASIS
, NVL(YEAR_CALC_TYPE
, 'ACTUAL/ACTUAL') YEAR_CALC_TYPE
FROM XTR_DEALS
WHERE DEAL_TYPE = 'FX'
AND STATUS_CODE <> 'CANCELLED'
AND PRICING_MODEL <> 'NO_REVAL' /*
AND ((DEAL_SUBTYPE = 'FORWARD'
AND STATUS_CODE <> 'CLOSED') OR (DEAL_SUBTYPE = 'SPOT')) */
AND LAST_REVAL_BATCH_ID IS NULL

Columns