[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_R_DEALS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_R_DEALS
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_R_DEALS_N1 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
 DEAL_NO
|
| XTR_R_DEALS_N2 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
CPARTY_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCEPTOR_CODE | VARCHAR2 | (7) | Acceptor identifier. The counterparty or company accepting the deal. Foreign key to XTR_PARTIES_V. ??? | |
| ACCEPTOR_NAME | VARCHAR2 | (20) | Name of the acceptor of the deal. The counterparty or company accepting the deal. ??? | |
| ACCRUAL_FROM | DATE | Start date of accrual. | ||
| ACCRUAL_TO | DATE | End date of accrual. | ||
| ACCRUED_INTEREST_PRICE | NUMBER | |||
| ACTION_STATUS | VARCHAR2 | (20) | ||
| ARCHIVE_BY | VARCHAR2 | (30) | Date on which this record is archived. | |
| ARCHIVE_DATE | DATE | Date on which this record is archived. | ||
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached). | |
| AUDIT_INDICATOR | VARCHAR2 | (1) | ||
| BASE_DATE | DATE | |||
| BASE_RATE | NUMBER | |||
| BKGE_SETTLED_REFERENCE | NUMBER | |||
| BOND_ISSUE | VARCHAR2 | (7) | ||
| BOND_PROFIT_LOSS | NUMBER | |||
| BOND_RENEG_DATE | DATE | |||
| BOND_RESALE_DATE | DATE | |||
| BOND_SALE_DATE | DATE | |||
| BROKER | VARCHAR2 | (7) | ||
| BROKERAGE_AMOUNT | NUMBER | |||
| BROKERAGE_AMOUNT_HCE | NUMBER | |||
| BROKERAGE_CODE | VARCHAR2 | (7) | ||
| BROKERAGE_CURRENCY | VARCHAR2 | (15) | ||
| BROKERAGE_RATE | NUMBER | |||
| BUY_ACCOUNT_NO | VARCHAR2 | (20) | ||
| BUY_AMOUNT | NUMBER | Buy amount. | ||
| BUY_HCE_AMOUNT | NUMBER | Buy amount in home currency. | ||
| CALC_BASIS | VARCHAR2 | (8) | ||
| CAPITAL_PRICE | NUMBER | |||
| CAP_OR_FLOOR | VARCHAR2 | (5) | ||
| CLIENT_ADVICE | VARCHAR2 | (1) | Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried). | |
| CLIENT_CODE | VARCHAR2 | (7) | Client identifier. Foreign key to XTR_PARTIES_V. | |
| CLIENT_REF | VARCHAR2 | (7) | ||
| COMMENCE_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (255) | Additional note for knock in option. | |
| COMPANY_CODE | VARCHAR2 | (7) | Yes | Company identifier. Foreign key to XTR_PARTIES_V. |
| CONTRACT_COMMISSION | NUMBER | |||
| CONTRACT_FEES | NUMBER | |||
| CONTRACT_NOS | NUMBER | |||
| CONTRACT_RATE | NUMBER | |||
| COUPON_ACTION | VARCHAR2 | (3) | ||
| COUPON_RATE | NUMBER | |||
| CPARTY_ADVICE | VARCHAR2 | (1) | ||
| CPARTY_CODE | VARCHAR2 | (7) | Yes | Counterparty identifier. Foreign key to XTR_PARTIES_V. |
| CPARTY_REF | VARCHAR2 | (7) | ||
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record. |
| CREATED_ON | DATE | Yes | Date on which this record is created. | |
| CTY_CCY | VARCHAR2 | (15) | ||
| CUM_COUPON_DATE | DATE | |||
| CURRENCY | VARCHAR2 | (15) | ||
| CURRENCY_BUY | VARCHAR2 | (15) | ||
| CURRENCY_SELL | VARCHAR2 | (15) | ||
| DEALER_CODE | VARCHAR2 | (10) | Dealer identifier. Foreign key to XTR_DEALER_CODES. | |
| DEAL_DATE | DATE | Yes | ||
| DEAL_LINKING_CODE | VARCHAR2 | (8) | ||
| DEAL_NO | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES. |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM. |
| DISCOUNT | VARCHAR2 | (1) | ||
| DRAWER_CODE | VARCHAR2 | (7) | ||
| DRAWER_NAME | VARCHAR2 | (20) | ||
| DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | User who dual authorised this record. | |
| DUAL_AUTHORISATION_ON | DATE | Date on which this record is dual authorised. | ||
| ENDORSER_CODE | VARCHAR2 | (7) | ||
| ENDORSER_NAME | VARCHAR2 | (20) | ||
| ENTER_INTO_SWAP | VARCHAR2 | (1) | ||
| EXCHANGE_CODE | VARCHAR2 | (7) | ||
| EXERCISE | VARCHAR2 | (1) | Indicates if the FX Option is exercised. Valid values are: Y (exercised) or N (not exercised). | |
| EXPIRY_DATE | DATE | |||
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
| EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | ||
| FACE_VALUE_AMOUNT | NUMBER | |||
| FACE_VALUE_HCE_AMOUNT | NUMBER | |||
| FIRST_REVAL | VARCHAR2 | (1) | ||
| FIXED_OR_FLOATING_RATE | VARCHAR2 | (5) | ||
| FIXED_TERM_MY | VARCHAR2 | (3) | ||
| FRA_DESCRIPTION | VARCHAR2 | (20) | ||
| FREQUENCY | NUMBER | |||
| FXD_DEAL_NO | NUMBER | |||
| FXO_DEAL_NO | NUMBER | |||
| FX_COVER_CROSS_REF | NUMBER | |||
| FX_PD_DEAL_NO | NUMBER | |||
| FX_REVALUED_ON_DATE | DATE | |||
| FX_RO_DEAL_NO | NUMBER | |||
| FX_SUBSIDIARY_BALANCE_AMOUNT | NUMBER | |||
| FX_WHOLESALE_REF | NUMBER | |||
| INSERT_FOR_CASHFLOW | VARCHAR2 | (1) | ||
| FORWARD_HCE_AMOUNT | NUMBER | |||
| INTEREST_AMOUNT | NUMBER | |||
| INTEREST_CUTOFF | VARCHAR2 | (1) | ||
| INTEREST_HCE_AMOUNT | NUMBER | |||
| INTEREST_RATE | NUMBER | |||
| INTERNAL_TICKET_NO | VARCHAR2 | (15) | ||
| INT_SWAP_REF | VARCHAR2 | (10) | ||
| KNOCK_EXECUTED_BY | VARCHAR2 | (10) | User who executed the knock option. | |
| KNOCK_EXECUTED_ON | DATE | Date on which knock option is executed. | ||
| KNOCK_INSERT_TYPE | VARCHAR2 | (1) | Knock In type. Valid values are: D (Diary Notes) or N (Normal Expiry Notes). ??? | |
| KNOCK_LEVEL | NUMBER | Knock rate. | ||
| KNOCK_TYPE | VARCHAR2 | (10) | Knock option. Valid values are: I (Knock In) or O (Knock Out). | |
| LIMIT_AMOUNT | NUMBER | |||
| LIMIT_CODE | VARCHAR2 | (7) | ||
| MARGIN | NUMBER | |||
| MATURITY_ACCOUNT_NO | VARCHAR2 | (20) | ||
| MATURITY_AMOUNT | NUMBER | |||
| MATURITY_BALANCE_AMOUNT | NUMBER | |||
| MATURITY_BALANCE_HCE_AMOUNT | NUMBER | |||
| MATURITY_DATE | DATE | |||
| MATURITY_HCE_AMOUNT | NUMBER | |||
| NEXT_COUPON_DATE | DATE | |||
| NI_DEAL_NO | NUMBER | |||
| NI_PROFIT_LOSS | NUMBER | |||
| NO_OF_DAYS | NUMBER | |||
| OPTION_AMOUNT | NUMBER | |||
| OPTION_COMMENCEMENT | DATE | |||
| OPTION_HCE_AMOUNT | NUMBER | |||
| OPTION_POINTS | NUMBER | |||
| OPTION_TYPE | VARCHAR2 | (8) | ||
| PAYMENT_FREQ | VARCHAR2 | (12) | ||
| PAYMENT_SCHEDULE_CODE | VARCHAR2 | (7) | ||
| PI_AMOUNT_DUE | NUMBER | |||
| PORTFOLIO_AMOUNT | NUMBER | |||
| PORTFOLIO_CODE | VARCHAR2 | (7) | ||
| PREMIUM_ACCOUNT_NO | VARCHAR2 | (20) | ||
| PREMIUM_ACTION | VARCHAR2 | (7) | ||
| PREMIUM_AMOUNT | NUMBER | |||
| PREMIUM_AMOUNT_TYPE | VARCHAR2 | (7) | ||
| PREMIUM_CURRENCY | VARCHAR2 | (15) | ||
| PREMIUM_DATE | DATE | |||
| PREMIUM_HCE_AMOUNT | NUMBER | |||
| PREMIUM_NO_OF_DAYS | NUMBER | |||
| PRINCIPAL_SETTLED_BY | VARCHAR2 | (1) | ||
| PRINTED_CPARTY_ADVICE | VARCHAR2 | (1) | ||
| PRINTED_YN | VARCHAR2 | (1) | ||
| PRODUCT_TYPE | VARCHAR2 | (10) | Deal product type identifier. Composite key to XTR_PRODUCT_TYPES. | |
| QUICK_INPUT | VARCHAR2 | (1) | ||
| RATE_BASIS | VARCHAR2 | (5) | ||
| REF_CCY | VARCHAR2 | (15) | ||
| RENEG_DATE | DATE | |||
| RISKPARTY_CODE | VARCHAR2 | (7) | ||
| RISKPARTY_LIMIT_CODE | VARCHAR2 | (7) | ||
| SECURITY_NAME | VARCHAR2 | (10) | ||
| SELL_ACCOUNT_NO | VARCHAR2 | (20) | ||
| SELL_AMOUNT | NUMBER | |||
| SELL_HCE_AMOUNT | NUMBER | |||
| SETTLE_ACCOUNT_NO | VARCHAR2 | (20) | ||
| SETTLE_ACTION | VARCHAR2 | (7) | ||
| SETTLE_AMOUNT | NUMBER | |||
| SETTLE_AMOUNT_TYPE | VARCHAR2 | (7) | ||
| SETTLE_DATE | DATE | |||
| SETTLE_DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | ||
| SETTLE_DUAL_AUTHORISATION_ON | DATE | |||
| SETTLE_HCE_AMOUNT | NUMBER | |||
| SETTLE_NO_OF_DAYS | NUMBER | |||
| SETTLE_RATE | NUMBER | |||
| SPOT_RATE_ON_VALUATION | NUMBER | |||
| START_ACCOUNT_NO | VARCHAR2 | (20) | ||
| START_AMOUNT | NUMBER | |||
| START_DATE | DATE | |||
| START_HCE_AMOUNT | NUMBER | |||
| STATUS_CODE | VARCHAR2 | (10) | Yes | Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'. |
| SWAP_DEPO_ADJUSTMENT | NUMBER | |||
| SWAP_DEPO_FLAG | VARCHAR2 | (1) | ||
| SWAP_DEPO_INT_RATE | NUMBER | |||
| SWAP_DEPO_TOTAL_RECEIPT | NUMBER | |||
| SWAP_REF | VARCHAR2 | (10) | ||
| SYNTHETIC_PRINTED_YN | VARCHAR2 | (1) | ||
| TAX_AMOUNT | NUMBER | |||
| TAX_AMOUNT_HCE | NUMBER | |||
| TAX_CODE | VARCHAR2 | (7) | ||
| TAX_RATE | NUMBER | |||
| TAX_SETTLED_REFERENCE | NUMBER | |||
| TERM_MY | VARCHAR2 | (4) | ||
| TOTAL_PRICE | NUMBER | |||
| TRANSACTION_CROSS_REF | VARCHAR2 | (7) | ||
| TRANSACTION_NO | NUMBER | |||
| TRANSACTION_RATE | NUMBER | |||
| UPDATED_BY | VARCHAR2 | (30) | Last updated user. | |
| UPDATED_ON | DATE | Last updated date. | ||
| VALUE_DATE | DATE | |||
| YEAR_BASIS | NUMBER | |||
| YEAR_CALC_TYPE | VARCHAR2 | (15) | ||
| YIELD_AMOUNT | NUMBER | |||
| YIELD_HCE_AMOUNT | NUMBER | |||
| SECURITY_ID | VARCHAR2 | (10) | ||
| EXERCISE_PRICE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCEPTOR_CODE
, ACCEPTOR_NAME
, ACCRUAL_FROM
, ACCRUAL_TO
, ACCRUED_INTEREST_PRICE
, ACTION_STATUS
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_INDICATOR
, BASE_DATE
, BASE_RATE
, BKGE_SETTLED_REFERENCE
, BOND_ISSUE
, BOND_PROFIT_LOSS
, BOND_RENEG_DATE
, BOND_RESALE_DATE
, BOND_SALE_DATE
, BROKER
, BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE
, BROKERAGE_CURRENCY
, BROKERAGE_RATE
, BUY_ACCOUNT_NO
, BUY_AMOUNT
, BUY_HCE_AMOUNT
, CALC_BASIS
, CAPITAL_PRICE
, CAP_OR_FLOOR
, CLIENT_ADVICE
, CLIENT_CODE
, CLIENT_REF
, COMMENCE_DATE
, COMMENTS
, COMPANY_CODE
, CONTRACT_COMMISSION
, CONTRACT_FEES
, CONTRACT_NOS
, CONTRACT_RATE
, COUPON_ACTION
, COUPON_RATE
, CPARTY_ADVICE
, CPARTY_CODE
, CPARTY_REF
, CREATED_BY
, CREATED_ON
, CTY_CCY
, CUM_COUPON_DATE
, CURRENCY
, CURRENCY_BUY
, CURRENCY_SELL
, DEALER_CODE
, DEAL_DATE
, DEAL_LINKING_CODE
, DEAL_NO
, DEAL_SUBTYPE
, DEAL_TYPE
, DISCOUNT
, DRAWER_CODE
, DRAWER_NAME
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, ENDORSER_CODE
, ENDORSER_NAME
, ENTER_INTO_SWAP
, EXCHANGE_CODE
, EXERCISE
, EXPIRY_DATE
, EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO
, FACE_VALUE_AMOUNT
, FACE_VALUE_HCE_AMOUNT
, FIRST_REVAL
, FIXED_OR_FLOATING_RATE
, FIXED_TERM_MY
, FRA_DESCRIPTION
, FREQUENCY
, FXD_DEAL_NO
, FXO_DEAL_NO
, FX_COVER_CROSS_REF
, FX_PD_DEAL_NO
, FX_REVALUED_ON_DATE
, FX_RO_DEAL_NO
, FX_SUBSIDIARY_BALANCE_AMOUNT
, FX_WHOLESALE_REF
, INSERT_FOR_CASHFLOW
, FORWARD_HCE_AMOUNT
, INTEREST_AMOUNT
, INTEREST_CUTOFF
, INTEREST_HCE_AMOUNT
, INTEREST_RATE
, INTERNAL_TICKET_NO
, INT_SWAP_REF
, KNOCK_EXECUTED_BY
, KNOCK_EXECUTED_ON
, KNOCK_INSERT_TYPE
, KNOCK_LEVEL
, KNOCK_TYPE
, LIMIT_AMOUNT
, LIMIT_CODE
, MARGIN
, MATURITY_ACCOUNT_NO
, MATURITY_AMOUNT
, MATURITY_BALANCE_AMOUNT
, MATURITY_BALANCE_HCE_AMOUNT
, MATURITY_DATE
, MATURITY_HCE_AMOUNT
, NEXT_COUPON_DATE
, NI_DEAL_NO
, NI_PROFIT_LOSS
, NO_OF_DAYS
, OPTION_AMOUNT
, OPTION_COMMENCEMENT
, OPTION_HCE_AMOUNT
, OPTION_POINTS
, OPTION_TYPE
, PAYMENT_FREQ
, PAYMENT_SCHEDULE_CODE
, PI_AMOUNT_DUE
, PORTFOLIO_AMOUNT
, PORTFOLIO_CODE
, PREMIUM_ACCOUNT_NO
, PREMIUM_ACTION
, PREMIUM_AMOUNT
, PREMIUM_AMOUNT_TYPE
, PREMIUM_CURRENCY
, PREMIUM_DATE
, PREMIUM_HCE_AMOUNT
, PREMIUM_NO_OF_DAYS
, PRINCIPAL_SETTLED_BY
, PRINTED_CPARTY_ADVICE
, PRINTED_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RATE_BASIS
, REF_CCY
, RENEG_DATE
, RISKPARTY_CODE
, RISKPARTY_LIMIT_CODE
, SECURITY_NAME
, SELL_ACCOUNT_NO
, SELL_AMOUNT
, SELL_HCE_AMOUNT
, SETTLE_ACCOUNT_NO
, SETTLE_ACTION
, SETTLE_AMOUNT
, SETTLE_AMOUNT_TYPE
, SETTLE_DATE
, SETTLE_DUAL_AUTHORISATION_BY
, SETTLE_DUAL_AUTHORISATION_ON
, SETTLE_HCE_AMOUNT
, SETTLE_NO_OF_DAYS
, SETTLE_RATE
, SPOT_RATE_ON_VALUATION
, START_ACCOUNT_NO
, START_AMOUNT
, START_DATE
, START_HCE_AMOUNT
, STATUS_CODE
, SWAP_DEPO_ADJUSTMENT
, SWAP_DEPO_FLAG
, SWAP_DEPO_INT_RATE
, SWAP_DEPO_TOTAL_RECEIPT
, SWAP_REF
, SYNTHETIC_PRINTED_YN
, TAX_AMOUNT
, TAX_AMOUNT_HCE
, TAX_CODE
, TAX_RATE
, TAX_SETTLED_REFERENCE
, TERM_MY
, TOTAL_PRICE
, TRANSACTION_CROSS_REF
, TRANSACTION_NO
, TRANSACTION_RATE
, UPDATED_BY
, UPDATED_ON
, VALUE_DATE
, YEAR_BASIS
, YEAR_CALC_TYPE
, YIELD_AMOUNT
, YIELD_HCE_AMOUNT
, SECURITY_ID
, EXERCISE_PRICE
FROM XTR.XTR_R_DEALS;
XTR.XTR_R_DEALS does not reference any database object
XTR.XTR_R_DEALS is referenced by following:
XTR
XTR_R_DEALS#
|
|
|
|