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.

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

VIEW: APPS.PV_ROUTING_HISTORY_V

Object Details

Object Name:	PV_ROUTING_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_ROUTING_HISTORY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ASSIGNMENT_ID	NUMBER		Assignment identifier
ROUTING_EVENT	VARCHAR2	(30)	Routing event (e.g. ACTIVE, ABANDONED, OFFERED, MATCHED, etc)
EVENT_DATE	DATE		Event date
PARTNER_ID	NUMBER		Partner identifier
CATEGORY	VARCHAR2	(30)	Category (e.g. PARTY, EMPLOYEE)
LEAD_ID	NUMBER	(15)	Opportunity identifier
REASON_CODE	VARCHAR2	(30)	Reason code
RESOURCE_NAME	VARCHAR2	(0)	Resource name
LEAD_WF_ID	NUMBER	(15)	Lead workflow identifer
LAST_UPDATE_DATE	DATE		Last update date
ORG_NAME	VARCHAR2	(0)	Organization name
LAST_UPDATE_BY	NUMBER	(15)	Last update by
NOTIFICATION_CODE	VARCHAR2	(2)	Notification code (e.g. CM, PT)
RESPONSE_CODE	VARCHAR2	(30)	Response code
RESOURCE_ID	NUMBER		Resouce identifier
ROUTING_STATUS	VARCHAR2	(30)	Routing status
RESPONSE_MEANING	VARCHAR2	(0)	Response code meaning
RESPONSE_DATE	DATE		Response date
LATEST_ROUTING_FLAG	VARCHAR2	(1)	Indicates whether the current record is the latest routing for the opportunity
ROUTING_TYPE	VARCHAR2	(30)	Routing type (e.g. SINGLE, SERIAL)
BYPASS_CM_OK_FLAG	VARCHAR2	(1)	Bypass channel manager approval flag

Query Text

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


SELECT ASSIGNMENT_ID
,      ROUTING_EVENT
,      EVENT_DATE
,      PARTNER_ID
,      CATEGORY
,      LEAD_ID
,      REASON_CODE
,      RESOURCE_NAME
,      LEAD_WF_ID
,      LAST_UPDATE_DATE
,      ORG_NAME
,      LAST_UPDATE_BY
,      NOTIFICATION_CODE
,      RESPONSE_CODE
,      RESOURCE_ID
,      ROUTING_STATUS
,      RESPONSE_MEANING
,      RESPONSE_DATE
,      LATEST_ROUTING_FLAG
,      ROUTING_TYPE
,      BYPASS_CM_OK_FLAG
FROM APPS.PV_ROUTING_HISTORY_V;

Dependencies

[top of page]

APPS.PV_ROUTING_HISTORY_V references the following:

APPS: JTF_RS_RESOURCE_EXTNS; PV_ASSIGNMENT_LOGS; PV_LEAD_ASSIGNMENTS; PV_LEAD_WORKFLOWS; PV_PARTY_NOTIFICATIONS

APPS.PV_ROUTING_HISTORY_V is not referenced by any database object