VIEW: APPS.XTR_ELIGIBLE_HEDGES_V

Source

View Text - Preformatted

SELECT NULL ACCOUNT_NO, to_number(NULL) BROKERAGE_AMOUNT, NULL CAP_OR_FLOOR, ATT.COMPANY_CODE COMPANY_CODE, NULL CONTRACT_CODE, ATT.HEDGE_CURRENCY CURRENCYA, null CURRENCYB, to_date(NULL) DEAL_DATE, ATT.HEDGE_ATTRIBUTE_ID DEAL_NO, STR.HEDGE_TYPE DEAL_SUBTYPE, 'HEDGE' DEAL_TYPE, NULL DISCOUNT_YIELD, nvl(ATT.DISCONTINUE_DATE, ATT.END_DATE) EFFECTIVE_DATE, ATT.START_DATE ELIGIBLE_DATE, to_date(NULL) EXPIRY_DATE, ATT.HEDGE_AMOUNT FACE_VALUE, 0 FX_REVAL_PRINCIPAL_BAL, 0 FXO_SELL_REF_AMOUNT, NULL MARKET_DATA_SET, ATT.END_DATE MATURITY_DATE, ATT.STRATEGY_CODE PORTFOLIO_CODE, NULL PREMIUM_ACTION, to_number(NULL) PREMIUM_AMOUNT, NULL PREMIUM_CCY, ATT.EXCLUSION_ITEM_CODE PRICING_MODEL, STR.HEDGE_APPROACH PRODUCT_TYPE, NULL SETTLE_ACTION, to_number(NULL) SETTLE_AMOUNT, to_date(NULL) SETTLE_DATE, ATT.START_DATE START_DATE, ATT.HEDGE_STATUS STATUS_CODE, NULL SWAP_REF, 1 TRANSACTION_NO, 0 TRANSACTION_RATE, to_number(NULL) YEAR_BASIS, 'ACTUAL/ACTUAL' YEAR_CALC_TYPE from XTR_HEDGE_ATTRIBUTES ATT, XTR_HEDGE_STRATEGIES STR, XTR_PARTY_INFO PI, GL_SETS_OF_BOOKS GL WHERE ATT.COMPANY_CODE = PI.PARTY_CODE and PI.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID and GL.CURRENCY_CODE <> ATT.HEDGE_CURRENCY and ATT.HEDGE_STATUS not in ('DESIGNATE', 'CANCELLED') and ATT.LAST_BATCH_ID is null and ATT.STRATEGY_CODE = STR.STRATEGY_CODE and STR.RISK_TYPE in ('FAIR_VALUE', 'FOREIGN EXCHANGE') and ATT.EXCLUSION_ITEM_CODE is NOT NULL and ATT.RETRO_METHOD <> 'NOTEST'

View Text - HTML Formatted

SELECT NULL ACCOUNT_NO
, TO_NUMBER(NULL) BROKERAGE_AMOUNT
, NULL CAP_OR_FLOOR
, ATT.COMPANY_CODE COMPANY_CODE
, NULL CONTRACT_CODE
, ATT.HEDGE_CURRENCY CURRENCYA
, NULL CURRENCYB
, TO_DATE(NULL) DEAL_DATE
, ATT.HEDGE_ATTRIBUTE_ID DEAL_NO
, STR.HEDGE_TYPE DEAL_SUBTYPE
, 'HEDGE' DEAL_TYPE
, NULL DISCOUNT_YIELD
, NVL(ATT.DISCONTINUE_DATE
, ATT.END_DATE) EFFECTIVE_DATE
, ATT.START_DATE ELIGIBLE_DATE
, TO_DATE(NULL) EXPIRY_DATE
, ATT.HEDGE_AMOUNT FACE_VALUE
, 0 FX_REVAL_PRINCIPAL_BAL
, 0 FXO_SELL_REF_AMOUNT
, NULL MARKET_DATA_SET
, ATT.END_DATE MATURITY_DATE
, ATT.STRATEGY_CODE PORTFOLIO_CODE
, NULL PREMIUM_ACTION
, TO_NUMBER(NULL) PREMIUM_AMOUNT
, NULL PREMIUM_CCY
, ATT.EXCLUSION_ITEM_CODE PRICING_MODEL
, STR.HEDGE_APPROACH PRODUCT_TYPE
, NULL SETTLE_ACTION
, TO_NUMBER(NULL) SETTLE_AMOUNT
, TO_DATE(NULL) SETTLE_DATE
, ATT.START_DATE START_DATE
, ATT.HEDGE_STATUS STATUS_CODE
, NULL SWAP_REF
, 1 TRANSACTION_NO
, 0 TRANSACTION_RATE
, TO_NUMBER(NULL) YEAR_BASIS
, 'ACTUAL/ACTUAL' YEAR_CALC_TYPE
FROM XTR_HEDGE_ATTRIBUTES ATT
, XTR_HEDGE_STRATEGIES STR
, XTR_PARTY_INFO PI
, GL_SETS_OF_BOOKS GL
WHERE ATT.COMPANY_CODE = PI.PARTY_CODE
AND PI.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND GL.CURRENCY_CODE <> ATT.HEDGE_CURRENCY
AND ATT.HEDGE_STATUS NOT IN ('DESIGNATE'
, 'CANCELLED')
AND ATT.LAST_BATCH_ID IS NULL
AND ATT.STRATEGY_CODE = STR.STRATEGY_CODE
AND STR.RISK_TYPE IN ('FAIR_VALUE'
, 'FOREIGN EXCHANGE')
AND ATT.EXCLUSION_ITEM_CODE IS NOT NULL
AND ATT.RETRO_METHOD <> 'NOTEST'