[Home] [Help] [Dependency Information]
Object Name: | PV_LEAD_WORKFLOWS |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_LEAD_WORKFLOWS |
Subobject Name: | |
Status: | VALID |
PV_LEAD_WORKFLOWS stores the lead statuses whether this lead is assigned to the partner or not, if so in what state the lead is. Notifications are sent to the all concerned when ever the lead is assigned to the partner or the lead status is changed.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_LEAD_WORKFLOWS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LEAD_WORKFLOW_ID |
PV_LEAD_WORKFLOWS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WF_ITEM_TYPE
WF_ITEM_KEY |
PV_LEAD_WORKFLOWS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LEAD_ID |
PV_LEAD_WORKFLOWS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ROUTING_STATUS
ROUTING_TYPE LATEST_ROUTING_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_WORKFLOW_ID | NUMBER | (15) | Yes | Lead Workflow identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
LEAD_ID | NUMBER | (15) | Yes | Lead identifier |
WF_ITEM_TYPE | VARCHAR2 | (30) | Yes | Workflow item type, part of unique identifier to workflow |
WF_ITEM_KEY | VARCHAR2 | (30) | Yes | Workflow item key, part of unique identifier to workflow |
WF_STATUS | VARCHAR2 | (30) | Workflow status indicates whether the lead is assigned to partner or not | |
SECURITY_GROUP_ID | NUMBER | (15) | Security group identifier | |
MATCHED_DUE_DATE | DATE | Due date for matching opportunities to the partners | ||
OFFERED_DUE_DATE | DATE | Due date for offered opportunities to the partners | ||
BYPASS_CM_OK_FLAG | VARCHAR2 | (1) | Flag to bypass cm | |
LATEST_ROUTING_FLAG | VARCHAR2 | (1) | Flag to specify whether the current routing is latest or not | |
ROUTING_STATUS | VARCHAR2 | (30) | Routing status | |
ENTITY | VARCHAR2 | (30) | Yes | Entity - opportunity |
FAILURE_CODE | VARCHAR2 | (30) | Failure Code | |
FAILURE_MESSAGE | VARCHAR2 | (500) | Failure Message | |
ROUTING_TYPE | VARCHAR2 | (30) | Routing type |
Cut, paste (and edit) the following text to query this object:
SELECT LEAD_WORKFLOW_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, LEAD_ID
, WF_ITEM_TYPE
, WF_ITEM_KEY
, WF_STATUS
, SECURITY_GROUP_ID
, MATCHED_DUE_DATE
, OFFERED_DUE_DATE
, BYPASS_CM_OK_FLAG
, LATEST_ROUTING_FLAG
, ROUTING_STATUS
, ENTITY
, FAILURE_CODE
, FAILURE_MESSAGE
, ROUTING_TYPE
FROM PV.PV_LEAD_WORKFLOWS;
PV.PV_LEAD_WORKFLOWS does not reference any database object
PV.PV_LEAD_WORKFLOWS is referenced by following:
|
|
|