VIEW: APPS.XTR_STOCK_ELIGIBLE_DEALS_V

Source

View Text - Preformatted

SELECT NULL ACCOUNT_NO, D.BROKERAGE_AMOUNT BROKERAGE_AMOUNT, NULL CAP_OR_FLOOR, D.COMPANY_CODE COMPANY_CODE, D.BOND_ISSUE CONTRACT_CODE, D.CURRENCY CURRENCYA, NULL CURRENCYB, D.DEAL_DATE DEAL_DATE, D.DEAL_NO DEAL_NO, D.DEAL_SUBTYPE DEAL_SUBTYPE, D.DEAL_TYPE DEAL_TYPE, NULL DISCOUNT_YIELD, D.START_DATE EFFECTIVE_DATE, decode(CP.PARAMETER_VALUE_CODE,'TRADE',D.DEAL_DATE, D.START_DATE) ELIGIBLE_DATE, to_date(NULL) EXPIRY_DATE, D.START_AMOUNT FACE_VALUE, D.QUANTITY FX_REVAL_PRINCIPAL_BAL, D.REMAINING_QUANTITY FXO_SELL_REF_AMOUNT, D.MARKET_DATA_SET MARKET_DATA_SET, to_date(NULL) MATURITY_DATE, D.PORTFOLIO_CODE PORTFOLIO_CODE, NULL PREMIUM_ACTION, to_number(NULL) PREMIUM_AMOUNT, NULL PREMIUM_CCY, D.PRICING_MODEL PRICING_MODEL, D.PRODUCT_TYPE PRODUCT_TYPE, NULL SETTLE_ACTION, to_number(NULL) SETTLE_AMOUNT, to_date(NULL) SETTLE_DATE, D.START_DATE START_DATE, D.STATUS_CODE STATUS_CODE, NULL SWAP_REF, nvl(D.TRANSACTION_NO,1) TRANSACTION_NO, D.CAPITAL_PRICE TRANSACTION_RATE, to_number(NULL) YEAR_BASIS, NULL YEAR_CALC_TYPE from XTR_DEALS D, XTR_COMPANY_PARAMETERS CP WHERE D.DEAL_TYPE = 'STOCK' and D.DEAL_SUBTYPE = 'BUY' and D.STATUS_CODE <> 'CANCELLED' and D.PRICING_MODEL <> 'NO_REVAL' and D.COMPANY_CODE = CP.COMPANY_CODE and CP.PARAMETER_CODE = 'ACCNT_TSDTM' and D.LAST_REVAL_BATCH_ID is null

View Text - HTML Formatted

SELECT NULL ACCOUNT_NO
, D.BROKERAGE_AMOUNT BROKERAGE_AMOUNT
, NULL CAP_OR_FLOOR
, D.COMPANY_CODE COMPANY_CODE
, D.BOND_ISSUE CONTRACT_CODE
, D.CURRENCY CURRENCYA
, NULL CURRENCYB
, D.DEAL_DATE DEAL_DATE
, D.DEAL_NO DEAL_NO
, D.DEAL_SUBTYPE DEAL_SUBTYPE
, D.DEAL_TYPE DEAL_TYPE
, NULL DISCOUNT_YIELD
, D.START_DATE EFFECTIVE_DATE
, DECODE(CP.PARAMETER_VALUE_CODE
, 'TRADE'
, D.DEAL_DATE
, D.START_DATE) ELIGIBLE_DATE
, TO_DATE(NULL) EXPIRY_DATE
, D.START_AMOUNT FACE_VALUE
, D.QUANTITY FX_REVAL_PRINCIPAL_BAL
, D.REMAINING_QUANTITY FXO_SELL_REF_AMOUNT
, D.MARKET_DATA_SET MARKET_DATA_SET
, TO_DATE(NULL) MATURITY_DATE
, D.PORTFOLIO_CODE PORTFOLIO_CODE
, NULL PREMIUM_ACTION
, TO_NUMBER(NULL) PREMIUM_AMOUNT
, NULL PREMIUM_CCY
, D.PRICING_MODEL PRICING_MODEL
, D.PRODUCT_TYPE PRODUCT_TYPE
, NULL SETTLE_ACTION
, TO_NUMBER(NULL) SETTLE_AMOUNT
, TO_DATE(NULL) SETTLE_DATE
, D.START_DATE START_DATE
, D.STATUS_CODE STATUS_CODE
, NULL SWAP_REF
, NVL(D.TRANSACTION_NO
, 1) TRANSACTION_NO
, D.CAPITAL_PRICE TRANSACTION_RATE
, TO_NUMBER(NULL) YEAR_BASIS
, NULL YEAR_CALC_TYPE
FROM XTR_DEALS D
, XTR_COMPANY_PARAMETERS CP
WHERE D.DEAL_TYPE = 'STOCK'
AND D.DEAL_SUBTYPE = 'BUY'
AND D.STATUS_CODE <> 'CANCELLED'
AND D.PRICING_MODEL <> 'NO_REVAL'
AND D.COMPANY_CODE = CP.COMPANY_CODE
AND CP.PARAMETER_CODE = 'ACCNT_TSDTM'
AND D.LAST_REVAL_BATCH_ID IS NULL