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: HR.PQH_ROUTING_CATEGORIES#

Source

View Text - Preformatted


select ROUTING_CATEGORY_ID ROUTING_CATEGORY_ID, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID, ROUTING_LIST_ID ROUTING_LIST_ID, POSITION_STRUCTURE_ID POSITION_STRUCTURE_ID, OVERRIDE_POSITION_ID OVERRIDE_POSITION_ID, OVERRIDE_ASSIGNMENT_ID OVERRIDE_ASSIGNMENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, OVERRIDE_ROLE_ID OVERRIDE_ROLE_ID, OVERRIDE_USER_ID OVERRIDE_USER_ID, ENABLE_FLAG ENABLE_FLAG, DEFAULT_FLAG DEFAULT_FLAG, DELETE_FLAG DELETE_FLAG from "HR"."PQH_ROUTING_CATEGORIES"

View Text - HTML Formatted

SELECT ROUTING_CATEGORY_ID ROUTING_CATEGORY_ID
, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, ROUTING_LIST_ID ROUTING_LIST_ID
, POSITION_STRUCTURE_ID POSITION_STRUCTURE_ID
, OVERRIDE_POSITION_ID OVERRIDE_POSITION_ID
, OVERRIDE_ASSIGNMENT_ID OVERRIDE_ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, OVERRIDE_ROLE_ID OVERRIDE_ROLE_ID
, OVERRIDE_USER_ID OVERRIDE_USER_ID
, ENABLE_FLAG ENABLE_FLAG
, DEFAULT_FLAG DEFAULT_FLAG
, DELETE_FLAG DELETE_FLAG
FROM "HR"."PQH_ROUTING_CATEGORIES"