[Home] [Help] [Dependency Information]
Object Name: | XTR_DATE_TYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DATE_TYPES |
Subobject Name: | |
Status: | VALID |
XTR_DATE_TYPES contains the pre-defined date types for a deal types. Each row corresponds to a date type. Many date types can be defined for a deal type. Along with amount actions and amount types, date types help define the journals structure. The date types in XTR_DEAL_DATE_AMOUNTS are derived from this table.
This table corresponds to the Date Types tabbed region in the Deal Types / Product Types / Deal Subtypes window.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DATE_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
DATE_TYPE |
XTR_DATE_TYPES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
USER_DATE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATE_NAME | VARCHAR2 | (80) | Yes | User-defined date type description |
DATE_TYPE | VARCHAR2 | (7) | Yes | Date type tied to specific deal types (for example, accrual, maturity, start, and dealt date) |
USER_DATE_TYPE | VARCHAR2 | (7) | Yes | User-defined date type code |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
SEEDED_DESCRIPTION | VARCHAR2 | (80) | Yes | Pre-defined date type description |
JOURNAL_USE | VARCHAR2 | (1) | Yes | Flag to indicate if the date type can be used to define journal structures (pre-defined as Y or N) |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record |
Cut, paste (and edit) the following text to query this object:
SELECT DATE_NAME
, DATE_TYPE
, USER_DATE_TYPE
, DEAL_TYPE
, SEEDED_DESCRIPTION
, JOURNAL_USE
, UPDATED_BY
FROM XTR.XTR_DATE_TYPES;
XTR.XTR_DATE_TYPES does not reference any database object
XTR.XTR_DATE_TYPES is referenced by following:
|
|
|