[Home] [Help] [Dependency Information]
Object Name: | XTR_FX_ROLL_PRE_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_FX_ROLL_PRE_DETAILS |
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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_RATE | NUMBER | Yes | ||
BUY_AMOUNT | NUMBER | Yes | Buy amount. | |
CLIENT_CODE | VARCHAR2 | (7) | Client identifier. Foreign key to XTR_PARTIES_V. | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company identifier. Foreign key to XTR_PARTIES_V. |
COMP_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
CPARTY_CODE | VARCHAR2 | (7) | Yes | Counterparty identifier. Foreign key to XTR_PARTIES_V. |
CURRENCY_BUY | VARCHAR2 | (15) | Yes | |
CURRENCY_SELL | VARCHAR2 | (15) | Yes | |
DEALER_CODE | VARCHAR2 | (10) | Dealer identifier. Foreign key to XTR_DEALER_CODES. | |
DEAL_DATE | DATE | Yes | ||
DEAL_NO | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
LIMIT_CODE | VARCHAR2 | (7) | Limit code identifier. Composite key to XTR_COMPANY_LIMITS. | |
MULTIPLE_TRANS_YN | VARCHAR2 | (3) | Yes | |
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PREV_DEAL_NO | NUMBER | |||
REF_NUMBER | NUMBER | Yes | ||
ROLL_PRE | VARCHAR2 | (3) | ||
ROLL_PRE_ON | DATE | |||
SELL_AMOUNT | NUMBER | Yes | ||
SETTLED_CURRENT | VARCHAR2 | (1) | Yes | |
SETTLEMENT_PARTY | VARCHAR2 | (7) | ||
SETTLEMENT_PARTY_ACCT | VARCHAR2 | (20) | ||
TRANS_RATE | NUMBER | Yes | ||
VALUE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_RATE
, BUY_AMOUNT
, CLIENT_CODE
, COMPANY_CODE
, COMP_SETTLEMENT_ACCT
, CPARTY_CODE
, CURRENCY_BUY
, CURRENCY_SELL
, DEALER_CODE
, DEAL_DATE
, DEAL_NO
, LIMIT_CODE
, MULTIPLE_TRANS_YN
, PORTFOLIO_CODE
, PREV_DEAL_NO
, REF_NUMBER
, ROLL_PRE
, ROLL_PRE_ON
, SELL_AMOUNT
, SETTLED_CURRENT
, SETTLEMENT_PARTY
, SETTLEMENT_PARTY_ACCT
, TRANS_RATE
, VALUE_DATE
FROM XTR.XTR_FX_ROLL_PRE_DETAILS;
XTR.XTR_FX_ROLL_PRE_DETAILS does not reference any database object
XTR.XTR_FX_ROLL_PRE_DETAILS is referenced by following:
|
|
|