VIEW: APPS.XTR_DEALS_INTERFACE_V

Source

View Text - Preformatted

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')))

View Text - HTML Formatted

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')))