[Home] [Help] [Dependency Information]
Object Name: | XTR_MIRROR_DDA_LIM_ROW_TMP |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_MIRROR_DDA_LIM_ROW_TMP |
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 |
---|---|---|---|---|
ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number. | |
AMOUNT | NUMBER | Yes | ||
AMOUNT_DATE | DATE | |||
AMOUNT_INDIC | NUMBER | |||
COMMENCE_DATE | DATE | |||
COMPANY_CODE | VARCHAR2 | (7) | Company identifier. Foreign key to XTR_PARTIES_V. | |
CONTRA_CCY | VARCHAR2 | (15) | ||
COUNTRY_CODE | VARCHAR2 | (2) | Country identifier. Foreign key to XTR_COUNTRY_CODES. | |
CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | ||
CURRENCY | VARCHAR2 | (15) | ||
CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
DATE_LAST_SET | DATE | Yes | ||
DEALER_CODE | VARCHAR2 | (10) | Dealer identifier. Foreign key to XTR_DEALER_CODES. | |
DEAL_NUMBER | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES. | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM. |
HCE_AMOUNT | NUMBER | Yes | Amount in home currency. | |
HCE_UTILISED_AMOUNT | NUMBER | Utilised amount in home currency. | ||
LIMIT_CODE | VARCHAR2 | (7) | Limit code identifier. Composite key to XTR_COMPANY_LIMITS. | |
LIMIT_PARTY | VARCHAR2 | (7) | ||
LIMIT_TYPE | VARCHAR2 | (2) | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | Deal product type identifier. Composite key to XTR_PRODUCT_TYPES. | |
STATUS_CODE | VARCHAR2 | (10) | Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'. | |
TRANSACTION_NUMBER | NUMBER | Yes | Rollover transaction identifier. Composite key to XTR_ROLLOVER_TRANSACTIONS. | |
TRANSACTION_RATE | NUMBER | |||
UTILISED_AMOUNT | NUMBER | Utilised amount calculated using limit weighting. | ||
BANK_ACCT_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NO
, AMOUNT
, AMOUNT_DATE
, AMOUNT_INDIC
, COMMENCE_DATE
, COMPANY_CODE
, CONTRA_CCY
, COUNTRY_CODE
, CROSS_REF_TO_OTHER_PARTY
, CURRENCY
, CURRENCY_COMBINATION
, DATE_LAST_SET
, DEALER_CODE
, DEAL_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, HCE_AMOUNT
, HCE_UTILISED_AMOUNT
, LIMIT_CODE
, LIMIT_PARTY
, LIMIT_TYPE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, STATUS_CODE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, UTILISED_AMOUNT
, BANK_ACCT_USE_ID
FROM XTR.XTR_MIRROR_DDA_LIM_ROW_TMP;
XTR.XTR_MIRROR_DDA_LIM_ROW_TMP does not reference any database object
XTR.XTR_MIRROR_DDA_LIM_ROW_TMP is referenced by following:
|
|
|