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

Source

View Text - Preformatted


select TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID, NAME NAME, SHORT_NAME SHORT_NAME, CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID, MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID, CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME, CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME, FORM_NAME FORM_NAME, FREEZE_STATUS_CD FREEZE_STATUS_CD, FUTURE_ACTION_CD FUTURE_ACTION_CD, MEMBER_CD MEMBER_CD, POST_STYLE_CD POST_STYLE_CD, POST_TXN_FUNCTION POST_TXN_FUNCTION, ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG, TIMEOUT_DAYS TIMEOUT_DAYS, WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG, 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, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SETUP_TYPE_CD SETUP_TYPE_CD, ENABLE_FLAG ENABLE_FLAG, PREVENT_APPROVER_SKIP PREVENT_APPROVER_SKIP, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PQH_TRANSACTION_CATEGORIES"

View Text - HTML Formatted

SELECT TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, NAME NAME
, SHORT_NAME SHORT_NAME
, CONSOLIDATED_TABLE_ROUTE_ID CONSOLIDATED_TABLE_ROUTE_ID
, MASTER_TABLE_ROUTE_ID MASTER_TABLE_ROUTE_ID
, CUSTOM_WF_PROCESS_NAME CUSTOM_WF_PROCESS_NAME
, CUSTOM_WORKFLOW_NAME CUSTOM_WORKFLOW_NAME
, FORM_NAME FORM_NAME
, FREEZE_STATUS_CD FREEZE_STATUS_CD
, FUTURE_ACTION_CD FUTURE_ACTION_CD
, MEMBER_CD MEMBER_CD
, POST_STYLE_CD POST_STYLE_CD
, POST_TXN_FUNCTION POST_TXN_FUNCTION
, ROUTE_VALIDATED_TXN_FLAG ROUTE_VALIDATED_TXN_FLAG
, TIMEOUT_DAYS TIMEOUT_DAYS
, WORKFLOW_ENABLE_FLAG WORKFLOW_ENABLE_FLAG
, 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
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SETUP_TYPE_CD SETUP_TYPE_CD
, ENABLE_FLAG ENABLE_FLAG
, PREVENT_APPROVER_SKIP PREVENT_APPROVER_SKIP
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PQH_TRANSACTION_CATEGORIES"