VIEW: PV.PV_ASSIGNMENT_LOGS#

Source

View Text - Preformatted

select ASSIGNMENT_ID ASSIGNMENT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LEAD_ASSIGNMENT_ID LEAD_ASSIGNMENT_ID, PARTNER_ID PARTNER_ID, ASSIGN_SEQUENCE ASSIGN_SEQUENCE, CM_ID CM_ID, LEAD_ID LEAD_ID, DURATION DURATION, FROM_LEAD_STATUS FROM_LEAD_STATUS, TO_LEAD_STATUS TO_LEAD_STATUS, STATUS STATUS, STATUS_DATE STATUS_DATE, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, WF_PT_USER WF_PT_USER, WF_CM_USER WF_CM_USER, WORKFLOW_ID WORKFLOW_ID, ERROR_TXT ERROR_TXT, TRANS_TYPE TRANS_TYPE, STATUS_CHANGE_COMMENTS STATUS_CHANGE_COMMENTS, SECURITY_GROUP_ID SECURITY_GROUP_ID from "PV"."PV_ASSIGNMENT_LOGS"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LEAD_ASSIGNMENT_ID LEAD_ASSIGNMENT_ID
, PARTNER_ID PARTNER_ID
, ASSIGN_SEQUENCE ASSIGN_SEQUENCE
, CM_ID CM_ID
, LEAD_ID LEAD_ID
, DURATION DURATION
, FROM_LEAD_STATUS FROM_LEAD_STATUS
, TO_LEAD_STATUS TO_LEAD_STATUS
, STATUS STATUS
, STATUS_DATE STATUS_DATE
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, WF_PT_USER WF_PT_USER
, WF_CM_USER WF_CM_USER
, WORKFLOW_ID WORKFLOW_ID
, ERROR_TXT ERROR_TXT
, TRANS_TYPE TRANS_TYPE
, STATUS_CHANGE_COMMENTS STATUS_CHANGE_COMMENTS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "PV"."PV_ASSIGNMENT_LOGS"