[Home] [Help] [Dependency Information]
Object Name: | HRI_ADM_MSG_LOG# |
---|---|
Object Type: | VIEW |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSG_LOG_ID | NUMBER | Yes | ||
MTHD_ACTION_ID | NUMBER | |||
MSG_TYPE | VARCHAR2 | (30) | Yes | |
PACKAGE_NAME | VARCHAR2 | (30) | ||
PERSON_ID | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
JOB_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
EVENT_ID | NUMBER | |||
SUPERVISOR_ID | NUMBER | |||
PERSON_TYPE_ID | NUMBER | |||
FORMULA_ID | NUMBER | |||
OTHER_REF_ID | NUMBER | |||
OTHER_REF_COLUMN | VARCHAR2 | (30) | ||
MSG_GROUP | VARCHAR2 | (30) | ||
MSG_SUB_GROUP | VARCHAR2 | (30) | ||
SQL_ERR_CODE | VARCHAR2 | (30) | ||
FND_MSG_NAME | VARCHAR2 | (30) | ||
NOTE | VARCHAR2 | (4000) | ||
EFFECTIVE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT MSG_LOG_ID
, MTHD_ACTION_ID
, MSG_TYPE
, PACKAGE_NAME
, PERSON_ID
, ASSIGNMENT_ID
, JOB_ID
, LOCATION_ID
, EVENT_ID
, SUPERVISOR_ID
, PERSON_TYPE_ID
, FORMULA_ID
, OTHER_REF_ID
, OTHER_REF_COLUMN
, MSG_GROUP
, MSG_SUB_GROUP
, SQL_ERR_CODE
, FND_MSG_NAME
, NOTE
, EFFECTIVE_DATE
FROM HRI.HRI_ADM_MSG_LOG#;
|
|
|