DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_FX_MULTIPLE_CONTRACTS

Object Details
Object Name: XTR_FX_MULTIPLE_CONTRACTS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_FX_MULTIPLE_CONTRACTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_FX_MULTIPLE_CONTRACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_NUM_CROSS_REF
Columns
Name Datatype Length Mandatory Comments
BUY_AMOUNT NUMBER
Yes Buy amount.
BUY_AMOUNT_HCE NUMBER
Yes Buy amount in home currency.
BUY_CCY VARCHAR2 (15) Yes Buy currency.
CPARTY_CODE VARCHAR2 (7) Yes Counterparty identifier. Foreign key to XTR_PARTIES_V.
DEAL_NUM_CROSS_REF NUMBER
Yes Cross referenced deal identifier. Foreign key to XTR_DEALS.
FORWARD_HCE_AMOUNT NUMBER

SELL_AMOUNT NUMBER
Yes
SELL_AMOUNT_HCE NUMBER
Yes
SELL_CCY VARCHAR2 (15) Yes Sell currency.
TRANS_RATE NUMBER
Yes
VALUE_DATE DATE
Yes
LIMIT_CODE VARCHAR2 (7)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUY_AMOUNT
,      BUY_AMOUNT_HCE
,      BUY_CCY
,      CPARTY_CODE
,      DEAL_NUM_CROSS_REF
,      FORWARD_HCE_AMOUNT
,      SELL_AMOUNT
,      SELL_AMOUNT_HCE
,      SELL_CCY
,      TRANS_RATE
,      VALUE_DATE
,      LIMIT_CODE
FROM XTR.XTR_FX_MULTIPLE_CONTRACTS;

Dependencies

[top of page]

XTR.XTR_FX_MULTIPLE_CONTRACTS does not reference any database object

XTR.XTR_FX_MULTIPLE_CONTRACTS is referenced by following:

SchemaXTR
ViewXTR_FX_MULTIPLE_CONTRACTS#