[Home] [Help] [Dependency Information]
Object Name: | OKC_DEL_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_DEL_MESSAGES |
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_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_DEL_MESSAGES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | MESSAGE_NAME |
OKC_DEL_MESSAGES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
START_EVT_BEFORE_AFTER
REPEATING_FREQUENCY_UOM END_EVT_BEFORE_AFTER RELATIVE_ST_DATE_UOM RELATIVE_END_DATE_UOM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MESSAGE_NAME | VARCHAR2 | (30) | Yes | Code to represent the text of a Deliverable due date definition. |
REPEATING_FREQUENCY_UOM | VARCHAR2 | (10) | This column describes the period type of the repeating frequency for a recurring deliverable definition. Valid values are `Weeks` and `Months`. Points to fnd lookup type OKC_DEL_REPEAT_FREQ. | |
RELATIVE_ST_DATE_UOM | VARCHAR2 | (10) | Indicates the code value for the period type (Days, Weeks or Months) that is part of the due date definition. Pionts to fnd Lookup_type OKC_DELIVERABLE_TIME_UNITS. | |
RELATIVE_END_DATE_UOM | VARCHAR2 | (10) | Indicates the code value for the period type (Days, Weeks or Months) that is part of the due date definition. Points to fnd Lookup_type OKC_DELIVERABLE_TIME_UNITS. | |
START_EVT_BEFORE_AFTER | VARCHAR2 | (1) | Code Value to signify whether the given Deliverable is due before or after the specified start event of a Deliverable. Points to fnd lookup type OKC_DEL_BEF_AFT. | |
END_EVT_BEFORE_AFTER | VARCHAR2 | (1) | Code Value to signify whether the given Deliverable is due before or after the specified end event of a Deliverable. Points to fnd lookup type OKC_DEL_BEF_AFT. | |
START_FIXED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate that the Due Date definition of a Deliverable has a fixed start date. Valid values are Y and N. |
END_FIXED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate that the Due Date definition of a Deliverable has a fixed end date. Valid values are Y and N. |
RECURRING_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate a recurring Deliverable. Valid values are Y and N. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT MESSAGE_NAME
, REPEATING_FREQUENCY_UOM
, RELATIVE_ST_DATE_UOM
, RELATIVE_END_DATE_UOM
, START_EVT_BEFORE_AFTER
, END_EVT_BEFORE_AFTER
, START_FIXED_FLAG
, END_FIXED_FLAG
, RECURRING_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKC.OKC_DEL_MESSAGES;
OKC.OKC_DEL_MESSAGES does not reference any database object
OKC.OKC_DEL_MESSAGES is referenced by following:
|
|
|