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.

VIEW: AP.AP_HOLD_CODES#

Source

View Text - Preformatted


select HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE, HOLD_TYPE HOLD_TYPE, DESCRIPTION DESCRIPTION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG, USER_UPDATEABLE_FLAG USER_UPDATEABLE_FLAG, INACTIVE_DATE INACTIVE_DATE, POSTABLE_FLAG POSTABLE_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, EXTERNAL_DESCRIPTION EXTERNAL_DESCRIPTION, HOLD_INSTRUCTION HOLD_INSTRUCTION, WAIT_BEFORE_NOTIFY_DAYS WAIT_BEFORE_NOTIFY_DAYS, REMINDER_DAYS REMINDER_DAYS, INITIATE_WORKFLOW_FLAG INITIATE_WORKFLOW_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "AP"."AP_HOLD_CODES"

View Text - HTML Formatted

SELECT HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE
, HOLD_TYPE HOLD_TYPE
, DESCRIPTION DESCRIPTION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG
, USER_UPDATEABLE_FLAG USER_UPDATEABLE_FLAG
, INACTIVE_DATE INACTIVE_DATE
, POSTABLE_FLAG POSTABLE_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, EXTERNAL_DESCRIPTION EXTERNAL_DESCRIPTION
, HOLD_INSTRUCTION HOLD_INSTRUCTION
, WAIT_BEFORE_NOTIFY_DAYS WAIT_BEFORE_NOTIFY_DAYS
, REMINDER_DAYS REMINDER_DAYS
, INITIATE_WORKFLOW_FLAG INITIATE_WORKFLOW_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AP"."AP_HOLD_CODES"