VIEW: APPS.XTR_FX_ELIGIBLE_DEALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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