[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_A_ALL_CONTRACTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_A_ALL_CONTRACTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONTRACT_NO | NUMBER | Deal identifier. Foreign key to XTR_DEALS. | ||
| ROLLOVER_TRANSACTION_NO | NUMBER | |||
| COMPANY | VARCHAR2 | (7) | ||
| COUNTERPARTY | VARCHAR2 | (7) | ||
| CLIENT | VARCHAR2 | (7) | ||
| ACCEPTOR | VARCHAR2 | (20) | ||
| ENDORSER | VARCHAR2 | (20) | ||
| DRAWER | VARCHAR2 | (20) | ||
| CONTRACT_SUBTYPE | VARCHAR2 | (7) | ||
| USER_DEAL_SUBTYPE | VARCHAR2 | (7) | ||
| PRODUCT | VARCHAR2 | (10) | ||
| PORTFOLIO | VARCHAR2 | (10) | ||
| CURRENCY | VARCHAR2 | (15) | ||
| CURRENCY_SELL | VARCHAR2 | (15) | ||
| CONTRACT_DEALT_ON | DATE | |||
| COMMENCE_DATE | DATE | |||
| MATURITY_DATE | DATE | |||
| SETTLEMENT_DATE | DATE | |||
| PREMIUM_DATE | DATE | |||
| OPTION_EXPIRY | DATE | |||
| AMOUNT | NUMBER | |||
| SELL_AMOUNT | NUMBER | |||
| CONSIDERATION_AMOUNT | NUMBER | |||
| SETTLEMENT_AMOUNT | NUMBER | |||
| PREMIUM_AMOUNT | NUMBER | |||
| BROKER_AMOUNT | NUMBER | |||
| TAX_AMOUNT | NUMBER | |||
| CONTRACT_RATE | NUMBER | |||
| COUPON_RATE | NUMBER | |||
| BROKER_RATE | NUMBER | |||
| TAX_RATE | NUMBER | |||
| SETTLEMENT_RATE | NUMBER | |||
| UPDATED_ON_DATE | DATE | |||
| UPDATED_BY_USER | VARCHAR2 | (30) | ||
| COMPANY_DEALER | VARCHAR2 | (10) | ||
| COMPANY_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
| COUNTERPARTY_ACCT_REF | VARCHAR2 | (7) | ||
| PREMIUM_ACCT | VARCHAR2 | (20) | ||
| FX_BUY_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
| FX_SELL_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
| SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
| CONTRACT_STATUS | VARCHAR2 | (10) | ||
| USER_STATUS_CODE | VARCHAR2 | (10) | ||
| LIMIT_CODE | VARCHAR2 | (7) | ||
| FIXED_FLOAT_BASIS | VARCHAR2 | (5) | ||
| CONTRACT_LINK_CODE | VARCHAR2 | (8) | ||
| BROKER_CODE | VARCHAR2 | (7) | ||
| TAX_CODE | VARCHAR2 | (7) | ||
| PAY_REC_SETTLEMENT | VARCHAR2 | (7) | ||
| PAY_REC_PREMIUM | VARCHAR2 | (7) | ||
| COMMENTS | VARCHAR2 | (255) | ||
| AUDIT_DATE_STORED | DATE | |||
| ORDERING_COLUMN | CHAR | (1) | ||
| CREATED_BY_USER | VARCHAR2 | (30) | ||
| CREATED_ON_DATE | DATE | |||
| PRICING_MODEL | VARCHAR2 | (30) | ||
| MARKET_DATA_SET | VARCHAR2 | (30) | ||
| DAY_COUNT_TYPE | VARCHAR2 | (1) | ||
| ROUNDING_TYPE | VARCHAR2 | (1) | ||
| SETTLE_DAY_COUNT_TYPE | VARCHAR2 | (1) | ||
| SETTLE_ROUNDING_TYPE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NO
, ROLLOVER_TRANSACTION_NO
, COMPANY
, COUNTERPARTY
, CLIENT
, ACCEPTOR
, ENDORSER
, DRAWER
, CONTRACT_SUBTYPE
, USER_DEAL_SUBTYPE
, PRODUCT
, PORTFOLIO
, CURRENCY
, CURRENCY_SELL
, CONTRACT_DEALT_ON
, COMMENCE_DATE
, MATURITY_DATE
, SETTLEMENT_DATE
, PREMIUM_DATE
, OPTION_EXPIRY
, AMOUNT
, SELL_AMOUNT
, CONSIDERATION_AMOUNT
, SETTLEMENT_AMOUNT
, PREMIUM_AMOUNT
, BROKER_AMOUNT
, TAX_AMOUNT
, CONTRACT_RATE
, COUPON_RATE
, BROKER_RATE
, TAX_RATE
, SETTLEMENT_RATE
, UPDATED_ON_DATE
, UPDATED_BY_USER
, COMPANY_DEALER
, COMPANY_SETTLEMENT_ACCT
, COUNTERPARTY_ACCT_REF
, PREMIUM_ACCT
, FX_BUY_SETTLEMENT_ACCT
, FX_SELL_SETTLEMENT_ACCT
, SETTLEMENT_ACCT
, CONTRACT_STATUS
, USER_STATUS_CODE
, LIMIT_CODE
, FIXED_FLOAT_BASIS
, CONTRACT_LINK_CODE
, BROKER_CODE
, TAX_CODE
, PAY_REC_SETTLEMENT
, PAY_REC_PREMIUM
, COMMENTS
, AUDIT_DATE_STORED
, ORDERING_COLUMN
, CREATED_BY_USER
, CREATED_ON_DATE
, PRICING_MODEL
, MARKET_DATA_SET
, DAY_COUNT_TYPE
, ROUNDING_TYPE
, SETTLE_DAY_COUNT_TYPE
, SETTLE_ROUNDING_TYPE
FROM APPS.XTR_A_ALL_CONTRACTS_V;
APPS
XTR_A_DEALS
XTR_A_ROLLOVER_TRANSACTIONS
XTR_DEALS_V
XTR_DEAL_STATUSES
XTR_DEAL_SUBTYPES
XTR_ROLLOVER_TRANSACTIONS_V
XTR_USER_ACCESS
- show dependent code
APPS.XTR_A_ALL_CONTRACTS_V is not referenced by any database object
|
|
|
|