DBA Data[Home] [Help] [Dependency Information]

VIEW: PV.PV_ASSIGNMENT_LOGS#

Object Details
Object Name: PV_ASSIGNMENT_LOGS#
Object Type: VIEW
Owner: PV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
LEAD_ASSIGNMENT_ID NUMBER

PARTNER_ID NUMBER

ASSIGN_SEQUENCE NUMBER

CM_ID NUMBER

LEAD_ID NUMBER
Yes
DURATION NUMBER

FROM_LEAD_STATUS VARCHAR2 (30)
TO_LEAD_STATUS VARCHAR2 (30)
STATUS VARCHAR2 (30)
STATUS_DATE DATE

WF_ITEM_TYPE VARCHAR2 (30)
WF_ITEM_KEY VARCHAR2 (30)
WF_PT_USER VARCHAR2 (30)
WF_CM_USER VARCHAR2 (30)
WORKFLOW_ID NUMBER

ERROR_TXT VARCHAR2 (255)
TRANS_TYPE NUMBER (15)
STATUS_CHANGE_COMMENTS VARCHAR2 (60)
SECURITY_GROUP_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PV.PV_ASSIGNMENT_LOGS# references the following:

SchemaPV
TablePV_ASSIGNMENT_LOGS
PV.PV_ASSIGNMENT_LOGS# is referenced by following:

SchemaAPPS
SynonymPV_ASSIGNMENT_LOGS