View: XTR_IG_ELIGIBLE_DEALS_V

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

View Text

SELECT NULL ACCOUNT_NO
, TO_NUMBER(NULL) BROKERAGE_AMOUNT
, NULL CAP_OR_FLOOR
, IG.COMPANY_CODE COMPANY_CODE
, NULL CONTRACT_CODE
, IG.CURRENCY CURRENCYA
, NULL CURRENCYB
, TO_DATE(NULL) DEAL_DATE
, IG.DEAL_NUMBER DEAL_NO
, DECODE(SIGN(IG.BALANCE_OUT)
, -1
, 'FUND'
, 'INVEST') DEAL_SUBTYPE
, IG.DEAL_TYPE DEAL_TYPE
, NULL DISCOUNT_YIELD
, IG.TRANSFER_DATE EFFECTIVE_DATE
, IG.TRANSFER_DATE ELIGIBLE_DATE
, TO_DATE(NULL) EXPIRY_DATE
, IG.BALANCE_OUT FACE_VALUE
, 0 FX_REVAL_PRINCIPAL_BAL
, 0 FXO_SELL_REF_AMOUNT
, NULL MARKET_DATA_SET
, TO_DATE(NULL) MATURITY_DATE
, IG.PORTFOLIO PORTFOLIO_CODE
, NULL PREMIUM_ACTION
, TO_NUMBER(NULL) PREMIUM_AMOUNT
, NULL PREMIUM_CCY
, IG.PRODUCT_TYPE PRODUCT_TYPE
, NULL PRICING_MODEL
, TO_NUMBER(NULL) SETTLE_AMOUNT
, TO_DATE(NULL) SETTLE_DATE
, TO_DATE(NULL) START_DATE
, NULL STATUS_CODE
, NULL SWAP_REF
, NVL(IG.TRANSACTION_NUMBER
, 1) TRANSACTION_NO
, 0 TRANSACTION_RATE
, TO_NUMBER(NULL) YEAR_BASIS
, 'ACTUAL/ACTUAL' YEAR_CALC_TYPE
FROM XTR_INTERGROUP_TRANSFERS IG
, XTR_PARTY_INFO PI
, GL_SETS_OF_BOOKS GL
WHERE IG.LAST_BATCH_ID IS NULL
AND IG.COMPANY_CODE = PI.PARTY_CODE
AND PI.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GL.CURRENCY_CODE <> IG.CURRENCY
AND IG.PRICING_MODEL <> 'NO_REVAL'

Columns