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

TABLE: XTR.XTR_LIMIT_TYPES

Object Details
Object Name: XTR_LIMIT_TYPES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_LIMIT_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIMIT_TYPE
Columns
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
Query Text

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;

Dependencies

[top of page]

XTR.XTR_LIMIT_TYPES does not reference any database object

XTR.XTR_LIMIT_TYPES is referenced by following:

SchemaXTR
ViewXTR_LIMIT_TYPES#