[Home] [Help] [Dependency Information]
Object Name: | PSP_EFFORT_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | PSP |
FND Design Data: | PSP.PSP_EFFORT_MESSAGES |
Subobject Name: | |
Status: | VALID |
PSP_EFFORT_MESSAGES contains the standard message that appears in the
dialog box for accepting and certifying reports. This message is
printed on the hard copy of the effort report. This table also
contains messages used by the employee when declining an effort
report.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSP_EFFORT_MESSAGES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | MESSAGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MESSAGE_ID | NUMBER | (5) | Yes | System-generated message identifier |
EFFORT_REPORT_MESSAGE_TYPE | VARCHAR2 | (1) | Yes | Message type. Values are Certify or Review. |
TEXT | VARCHAR2 | (2000) | Yes | Message description |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT MESSAGE_ID
, EFFORT_REPORT_MESSAGE_TYPE
, TEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSP.PSP_EFFORT_MESSAGES;
PSP.PSP_EFFORT_MESSAGES does not reference any database object
PSP.PSP_EFFORT_MESSAGES is referenced by following:
|
|
|