[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_ALL_CONTRACTS_V is not referenced by any database object
|
|
|