[Home] [Help] [Dependency Information]
Object Name: | XTR_LIMIT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_LIMIT_TYPES |
Subobject Name: | |
Status: | VALID |
XTR_LIMIT_TYPES contains limit type information. Each row corresponds to one limit type, each of which belongs to one of four investment categories. The categories are X (for foreign exchange), I (for investment), F (for funding), and OD (for overdraft). Limit types allow you to combine global and group limits.
This table corresponds to the Limit Types region in the Limit Types window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_LIMIT_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LIMIT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
FX_INVEST_FUND_TYPE | VARCHAR2 | (2) | Limit investment category (F for fund, I for invest, X for foreign exchange, or OD for overdraft) | |
LIMIT_TYPE | VARCHAR2 | (2) | Yes | Limit type code (tied to one of four limit categories) |
NAME | VARCHAR2 | (20) | Yes | Limit type name |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated |
Cut, paste (and edit) the following text to query this object:
SELECT CREATED_BY
, CREATED_ON
, FX_INVEST_FUND_TYPE
, LIMIT_TYPE
, NAME
, UPDATED_BY
, UPDATED_ON
FROM XTR.XTR_LIMIT_TYPES;
XTR.XTR_LIMIT_TYPES does not reference any database object
XTR.XTR_LIMIT_TYPES is referenced by following:
|
|
|