Product: | XTR - Treasury |
---|---|
Description: | This view is to collect eligible STOCK deals for Revaluations process |
Implementation/DBA Data: | APPS.XTR_STOCK_ELIGIBLE_DEALS_V |
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