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: PV.PV_OPPTY_ROUTING_LOGS#

Source

View Text - Preformatted


select OPPTY_ROUTING_LOG_ID OPPTY_ROUTING_LOG_ID, EVENT EVENT, LEAD_ID LEAD_ID, LEAD_WORKFLOW_ID LEAD_WORKFLOW_ID, ROUTING_TYPE ROUTING_TYPE, LATEST_ROUTING_FLAG LATEST_ROUTING_FLAG, BYPASS_CM_FLAG BYPASS_CM_FLAG, LEAD_ASSIGNMENT_ID LEAD_ASSIGNMENT_ID, EVENT_DATE EVENT_DATE, VENDOR_USER_ID VENDOR_USER_ID, PT_CONTACT_USER_ID PT_CONTACT_USER_ID, USER_RESPONSE USER_RESPONSE, REASON_CODE REASON_CODE, USER_TYPE USER_TYPE, VENDOR_BUSINESS_UNIT_ID VENDOR_BUSINESS_UNIT_ID from "PV"."PV_OPPTY_ROUTING_LOGS"

View Text - HTML Formatted

SELECT OPPTY_ROUTING_LOG_ID OPPTY_ROUTING_LOG_ID
, EVENT EVENT
, LEAD_ID LEAD_ID
, LEAD_WORKFLOW_ID LEAD_WORKFLOW_ID
, ROUTING_TYPE ROUTING_TYPE
, LATEST_ROUTING_FLAG LATEST_ROUTING_FLAG
, BYPASS_CM_FLAG BYPASS_CM_FLAG
, LEAD_ASSIGNMENT_ID LEAD_ASSIGNMENT_ID
, EVENT_DATE EVENT_DATE
, VENDOR_USER_ID VENDOR_USER_ID
, PT_CONTACT_USER_ID PT_CONTACT_USER_ID
, USER_RESPONSE USER_RESPONSE
, REASON_CODE REASON_CODE
, USER_TYPE USER_TYPE
, VENDOR_BUSINESS_UNIT_ID VENDOR_BUSINESS_UNIT_ID
FROM "PV"."PV_OPPTY_ROUTING_LOGS"