[Home] [Help] [Dependency Information]
Object Name: | XTR_AUTH_CCY_COMBINATIONS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_AUTH_CCY_COMBINATIONS |
Subobject Name: | |
Status: | VALID |
XTR_AUTH_CCY_COMBINATIONS contains information on currency combinations. Each row in this table contains the base and the contra currency for the currency combination. It also contains a flag that indicates whether or not the currency combination is authorized for use in deal transactions. You can only create a foreign exchange deal using an authorized currency combination. Each time a currency combination is authorized a database trigger fires to insert two rows into XTR_BUY_SELL_COMBINATIONS, one where the buy currency is the base currency and the other where buy currency is the contra currency, assuming those combinations do not already exist.
This table corresponds to the Combination Details region in the Currency Details window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_AUTH_CCY_COMBINATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CURRENCY_QUOTE_FIRST
CURRENCY_QUOTE_SECOND |
XTR_AUTH_CCY_COMBINATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_QUOTE_SECOND |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | Yes | Flag to indicate if the currency combination is authorized for use (Y), or not (N) |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
CURRENCY_QUOTE_FIRST | VARCHAR2 | (15) | Yes | Base currency |
CURRENCY_QUOTE_SECOND | VARCHAR2 | (15) | Yes | Contra currency in a foreign exchange currency quote |
FX_SEQ_NO | NUMBER | No longer used | ||
LAST_TRANSACTION_CHANGED | DATE | Date the transaction was last changed | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
FORWARD_POINT_FACTOR | NUMBER | The exponent for basis points in forward point entry. |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, CREATED_BY
, CREATED_ON
, CURRENCY_QUOTE_FIRST
, CURRENCY_QUOTE_SECOND
, FX_SEQ_NO
, LAST_TRANSACTION_CHANGED
, UPDATED_BY
, UPDATED_ON
, FORWARD_POINT_FACTOR
FROM XTR.XTR_AUTH_CCY_COMBINATIONS;
XTR.XTR_AUTH_CCY_COMBINATIONS does not reference any database object
XTR.XTR_AUTH_CCY_COMBINATIONS is referenced by following:
|
|
|