eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HRI.HRI_ADM_MSG_LOG#

Source

View Text - Preformatted


select MSG_LOG_ID MSG_LOG_ID, MTHD_ACTION_ID MTHD_ACTION_ID, MSG_TYPE MSG_TYPE, PACKAGE_NAME PACKAGE_NAME, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, JOB_ID JOB_ID, LOCATION_ID LOCATION_ID, EVENT_ID EVENT_ID, SUPERVISOR_ID SUPERVISOR_ID, PERSON_TYPE_ID PERSON_TYPE_ID, FORMULA_ID FORMULA_ID, OTHER_REF_ID OTHER_REF_ID, OTHER_REF_COLUMN OTHER_REF_COLUMN, MSG_GROUP MSG_GROUP, MSG_SUB_GROUP MSG_SUB_GROUP, SQL_ERR_CODE SQL_ERR_CODE, FND_MSG_NAME FND_MSG_NAME, NOTE NOTE, EFFECTIVE_DATE EFFECTIVE_DATE from "HRI"."HRI_ADM_MSG_LOG"

View Text - HTML Formatted

SELECT MSG_LOG_ID MSG_LOG_ID
, MTHD_ACTION_ID MTHD_ACTION_ID
, MSG_TYPE MSG_TYPE
, PACKAGE_NAME PACKAGE_NAME
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, JOB_ID JOB_ID
, LOCATION_ID LOCATION_ID
, EVENT_ID EVENT_ID
, SUPERVISOR_ID SUPERVISOR_ID
, PERSON_TYPE_ID PERSON_TYPE_ID
, FORMULA_ID FORMULA_ID
, OTHER_REF_ID OTHER_REF_ID
, OTHER_REF_COLUMN OTHER_REF_COLUMN
, MSG_GROUP MSG_GROUP
, MSG_SUB_GROUP MSG_SUB_GROUP
, SQL_ERR_CODE SQL_ERR_CODE
, FND_MSG_NAME FND_MSG_NAME
, NOTE NOTE
, EFFECTIVE_DATE EFFECTIVE_DATE
FROM "HRI"."HRI_ADM_MSG_LOG"