VIEW: XTR.XTR_DEALS_INTERFACE#

Source

View Text - Preformatted

select EXTERNAL_DEAL_ID EXTERNAL_DEAL_ID, DEAL_TYPE DEAL_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOAD_STATUS_CODE LOAD_STATUS_CODE, BROKERAGE_CODE BROKERAGE_CODE, BROKERAGE_CURRENCY BROKERAGE_CURRENCY, ACCOUNT_NO_A ACCOUNT_NO_A, ACCOUNT_NO_B ACCOUNT_NO_B, CLIENT_CODE CLIENT_CODE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CPARTY_CODE CPARTY_CODE, CPARTY_REF CPARTY_REF, CURRENCY_A CURRENCY_A, CURRENCY_B CURRENCY_B, DEALER_CODE DEALER_CODE, DEAL_LINKING_CODE DEAL_LINKING_CODE, DEAL_SUBTYPE DEAL_SUBTYPE, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO, INTERNAL_TICKET_NO INTERNAL_TICKET_NO, LIMIT_CODE LIMIT_CODE, PORTFOLIO_CODE PORTFOLIO_CODE, PRODUCT_TYPE PRODUCT_TYPE, STATUS_CODE STATUS_CODE, AMOUNT_A AMOUNT_A, AMOUNT_B AMOUNT_B, AMOUNT_C AMOUNT_C, RATE_A RATE_A, RATE_B RATE_B, RATE_C RATE_C, DATE_A DATE_A, DATE_B DATE_B, NO_OF_DAYS NO_OF_DAYS, ACTION_CODE ACTION_CODE, AMOUNT_TYPE AMOUNT_TYPE, AMOUNT_HCE AMOUNT_HCE, EXPOSURE_TYPE EXPOSURE_TYPE, SETTLE_ACTION_REQD SETTLE_ACTION_REQD, BANK_CODE_FROM BANK_CODE_FROM, BANK_CODE_TO BANK_CODE_TO, MARKET_DATA_SET MARKET_DATA_SET, PRICING_MODEL PRICING_MODEL, OVERRIDE_LIMIT OVERRIDE_LIMIT, DUAL_AUTHORIZATION_BY DUAL_AUTHORIZATION_BY, DUAL_AUTHORIZATION_ON DUAL_AUTHORIZATION_ON, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, LIMIT_CODE_B LIMIT_CODE_B, MIRROR_PORTFOLIO_CODE MIRROR_PORTFOLIO_CODE, MIRROR_PRODUCT_TYPE MIRROR_PRODUCT_TYPE, MIRROR_LIMIT_CODE_INVEST MIRROR_LIMIT_CODE_INVEST, MIRROR_LIMIT_CODE_FUND MIRROR_LIMIT_CODE_FUND, ROUNDING_TYPE ROUNDING_TYPE, DAY_COUNT_TYPE DAY_COUNT_TYPE, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, YEAR_CALC_TYPE YEAR_CALC_TYPE, DATE_C DATE_C, BASIS_TYPE BASIS_TYPE, SECURITY_ID SECURITY_ID, ACCEPTOR_CODE ACCEPTOR_CODE, DRAWER_CODE DRAWER_CODE, ENDORSER_CODE ENDORSER_CODE, SCHEDULE_A SCHEDULE_A, SCHEDULE_B SCHEDULE_B, OPTION_A OPTION_A, MIRROR_PRICING_MODEL MIRROR_PRICING_MODEL, FROM_BANK_BRANCH_ID FROM_BANK_BRANCH_ID, TO_BANK_BRANCH_ID TO_BANK_BRANCH_ID, COMPANY_ACCT_A_USE_ID COMPANY_ACCT_A_USE_ID, COMPANY_ACCT_B_USE_ID COMPANY_ACCT_B_USE_ID, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO, MIRROR_DEAL_LINKING_CODE MIRROR_DEAL_LINKING_CODE, MIRROR_DEALER_CODE MIRROR_DEALER_CODE, EXTERNAL_SOURCE EXTERNAL_SOURCE, VALIDATION_FLAG VALIDATION_FLAG, SETTLEMENT_FLAG SETTLEMENT_FLAG from "XTR"."XTR_DEALS_INTERFACE"

View Text - HTML Formatted

SELECT EXTERNAL_DEAL_ID EXTERNAL_DEAL_ID
, DEAL_TYPE DEAL_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOAD_STATUS_CODE LOAD_STATUS_CODE
, BROKERAGE_CODE BROKERAGE_CODE
, BROKERAGE_CURRENCY BROKERAGE_CURRENCY
, ACCOUNT_NO_A ACCOUNT_NO_A
, ACCOUNT_NO_B ACCOUNT_NO_B
, CLIENT_CODE CLIENT_CODE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CPARTY_CODE CPARTY_CODE
, CPARTY_REF CPARTY_REF
, CURRENCY_A CURRENCY_A
, CURRENCY_B CURRENCY_B
, DEALER_CODE DEALER_CODE
, DEAL_LINKING_CODE DEAL_LINKING_CODE
, DEAL_SUBTYPE DEAL_SUBTYPE
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO EXTERNAL_CPARTY_NO
, INTERNAL_TICKET_NO INTERNAL_TICKET_NO
, LIMIT_CODE LIMIT_CODE
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRODUCT_TYPE PRODUCT_TYPE
, STATUS_CODE STATUS_CODE
, AMOUNT_A AMOUNT_A
, AMOUNT_B AMOUNT_B
, AMOUNT_C AMOUNT_C
, RATE_A RATE_A
, RATE_B RATE_B
, RATE_C RATE_C
, DATE_A DATE_A
, DATE_B DATE_B
, NO_OF_DAYS NO_OF_DAYS
, ACTION_CODE ACTION_CODE
, AMOUNT_TYPE AMOUNT_TYPE
, AMOUNT_HCE AMOUNT_HCE
, EXPOSURE_TYPE EXPOSURE_TYPE
, SETTLE_ACTION_REQD SETTLE_ACTION_REQD
, BANK_CODE_FROM BANK_CODE_FROM
, BANK_CODE_TO BANK_CODE_TO
, MARKET_DATA_SET MARKET_DATA_SET
, PRICING_MODEL PRICING_MODEL
, OVERRIDE_LIMIT OVERRIDE_LIMIT
, DUAL_AUTHORIZATION_BY DUAL_AUTHORIZATION_BY
, DUAL_AUTHORIZATION_ON DUAL_AUTHORIZATION_ON
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, LIMIT_CODE_B LIMIT_CODE_B
, MIRROR_PORTFOLIO_CODE MIRROR_PORTFOLIO_CODE
, MIRROR_PRODUCT_TYPE MIRROR_PRODUCT_TYPE
, MIRROR_LIMIT_CODE_INVEST MIRROR_LIMIT_CODE_INVEST
, MIRROR_LIMIT_CODE_FUND MIRROR_LIMIT_CODE_FUND
, ROUNDING_TYPE ROUNDING_TYPE
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, YEAR_CALC_TYPE YEAR_CALC_TYPE
, DATE_C DATE_C
, BASIS_TYPE BASIS_TYPE
, SECURITY_ID SECURITY_ID
, ACCEPTOR_CODE ACCEPTOR_CODE
, DRAWER_CODE DRAWER_CODE
, ENDORSER_CODE ENDORSER_CODE
, SCHEDULE_A SCHEDULE_A
, SCHEDULE_B SCHEDULE_B
, OPTION_A OPTION_A
, MIRROR_PRICING_MODEL MIRROR_PRICING_MODEL
, FROM_BANK_BRANCH_ID FROM_BANK_BRANCH_ID
, TO_BANK_BRANCH_ID TO_BANK_BRANCH_ID
, COMPANY_ACCT_A_USE_ID COMPANY_ACCT_A_USE_ID
, COMPANY_ACCT_B_USE_ID COMPANY_ACCT_B_USE_ID
, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID
, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO
, MIRROR_DEAL_LINKING_CODE MIRROR_DEAL_LINKING_CODE
, MIRROR_DEALER_CODE MIRROR_DEALER_CODE
, EXTERNAL_SOURCE EXTERNAL_SOURCE
, VALIDATION_FLAG VALIDATION_FLAG
, SETTLEMENT_FLAG SETTLEMENT_FLAG
FROM "XTR"."XTR_DEALS_INTERFACE"