Product: | XTR - Treasury |
---|---|
Description: | This view is created in association with the base table Xtr_Deals_Interface. The table is designed to hold as much common deal information as possible. |
Implementation/DBA Data: | APPS.XTR_DEALS_INTERFACE_V |
SELECT XDI.EXTERNAL_DEAL_ID
, XDI.DEAL_TYPE
, XDI.CREATED_BY
, XDI.CREATION_DATE
, XDI.LAST_UPDATED_BY
, XDI.LAST_UPDATE_DATE
, XDI.LAST_UPDATE_LOGIN
, XDI.LOAD_STATUS_CODE LOAD_STATUS_CODE
, XDI.BROKERAGE_CODE
, XDI.BROKERAGE_CURRENCY
, XDI.ACCOUNT_NO_A
, XDI.ACCOUNT_NO_B
, XDI.CLIENT_CODE
, XDI.COMMENTS
, XDI.COMPANY_CODE
, XDI.CPARTY_CODE
, XDI.CPARTY_ACCOUNT_NO
, XDI.CPARTY_REF
, XDI.CURRENCY_A
, XDI.CURRENCY_B
, XDI.DEALER_CODE
, XDI.DEAL_LINKING_CODE
, XDI.DEAL_SUBTYPE
, XDI.EXTERNAL_COMMENTS
, XDI.EXTERNAL_CPARTY_NO
, XDI.INTERNAL_TICKET_NO
, XDI.LIMIT_CODE
, XDI.PORTFOLIO_CODE
, XDI.PRODUCT_TYPE
, XDI.STATUS_CODE
, XDI.AMOUNT_A
, XDI.AMOUNT_B
, XDI.AMOUNT_C
, XDI.RATE_A
, XDI.RATE_B
, XDI.RATE_C
, XDI.DATE_A
, XDI.DATE_B
, XDI.NO_OF_DAYS
, XDI.ACTION_CODE
, XDI.AMOUNT_TYPE
, XDI.AMOUNT_HCE
, XDI.EXPOSURE_TYPE
, XDI.SETTLE_ACTION_REQD
, XDI.BANK_CODE_FROM
, XDI.BANK_CODE_TO
, XDI.MARKET_DATA_SET
, XDI.PRICING_MODEL
, XDI.OVERRIDE_LIMIT
, XDI.DUAL_AUTHORIZATION_BY
, XDI.DUAL_AUTHORIZATION_ON
, XDI.ATTRIBUTE_CATEGORY
, XDI.ATTRIBUTE1
, XDI.ATTRIBUTE2
, XDI.ATTRIBUTE3
, XDI.ATTRIBUTE4
, XDI.ATTRIBUTE5
, XDI.ATTRIBUTE6
, XDI.ATTRIBUTE7
, XDI.ATTRIBUTE8
, XDI.ATTRIBUTE9
, XDI.ATTRIBUTE10
, XDI.ATTRIBUTE11
, XDI.ATTRIBUTE12
, XDI.ATTRIBUTE13
, XDI.ATTRIBUTE14
, XDI.ATTRIBUTE15
, XDI.LIMIT_CODE_B
, XDI.MIRROR_PORTFOLIO_CODE
, XDI.MIRROR_PRODUCT_TYPE
, XDI.MIRROR_PRICING_MODEL
, XDI.MIRROR_LIMIT_CODE_FUND
, XDI.MIRROR_LIMIT_CODE_INVEST
, XDI.ROUNDING_TYPE
, XDI.DAY_COUNT_TYPE
, XDI.ORIGINAL_AMOUNT
, XDI.YEAR_CALC_TYPE
, XDI.DATE_C
, XDI.BASIS_TYPE
, XDI.SECURITY_ID
, XDI.ACCEPTOR_CODE
, XDI.DRAWER_CODE
, XDI.ENDORSER_CODE
, XDI.SCHEDULE_A
, XDI.SCHEDULE_B
, XDI.OPTION_A
, XDI.MIRROR_DEAL_LINKING_CODE
, XDI.MIRROR_DEALER_CODE
, XDI.EXTERNAL_SOURCE
, XDI.SETTLEMENT_FLAG
, XDI.VALIDATION_FLAG
FROM XTR_DEALS_INTERFACE XDI
WHERE ((XDI.COMPANY_CODE IN (SELECT PARTY_CODE
FROM XTR_PARTIES_V
WHERE PARTY_TYPE = 'C')) OR (XDI.COMPANY_CODE NOT IN (SELECT PARTY_CODE
FROM XTR_PARTY_INFO
WHERE PARTY_TYPE = 'C')))