[Home] [Help] [Dependency Information]
Object Name: | XDP_FULFILL_WORKLIST |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_FULFILL_WORKLIST |
Subobject Name: | |
Status: | VALID |
XDP_FULFILL_WORKLIST contains the list of all work items to be executed for a given order by the order processor.
Work items with the lowest fulfillment sequence number is executed first.
All work items in the list that have the same fulfillment sequence number are executed
in parallel.
It is possible to have work items sequence number to be executed in parallel or sequential or a combination of both.
Example: W1 1, W2 1, W3 2, W4 3, W5 3 => combination of sequential and parallel order execution, W1 and W2 are executed in parallel and W3 is not execute until W1 and W2 have completed. Then W4 and W5 will be executed.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_FULFILL_WORKLIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WORKITEM_INSTANCE_ID
WORKITEM_ID |
XDP_FULFILL_WORKLIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORDER_ID
LINE_NUMBER |
XDP_FULFILL_WORKLIST_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_ITEM_ID |
XDP_FULFILL_WORKLIST_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WORKITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKITEM_INSTANCE_ID | NUMBER | Yes | Work item instance identifier | |
LINE_ITEM_ID | NUMBER | Yes | Order line item identifier | |
ORDER_ID | NUMBER | Yes | Current order ID | |
LINE_NUMBER | NUMBER | Yes | The index number of the line within the order | |
WORKITEM_ID | NUMBER | Yes | Work Item identifier | |
STATUS_CODE | VARCHAR2 | (40) | Yes | Work Item instance fulfillment status |
STATE | VARCHAR2 | (40) | Not Used | |
PROVISIONING_DATE | DATE | Yes | The date when fulfillment starts | |
WI_SEQUENCE | NUMBER | Yes | The optional fulfillment sequence among the order work items | |
WI_RUNTIME_MESSAGE_ID | RAW | (16) | A handle to a runtime AQ message | |
PRIORITY | NUMBER | Fulfillment priority | ||
DUE_DATE | DATE | The date when this work item is due | ||
CUSTOMER_REQUIRED_DATE | DATE | Customer required date for the completion of the order | ||
COMPLETION_DATE | DATE | The date when the fulfillment is completed | ||
CANCEL_PROVISIONING_DATE | DATE | The date when the order is cancelled | ||
CANCELED_BY | VARCHAR2 | (40) | The user ID of who cancelled the order | |
HOLD_PROVISIONING_DATE | DATE | For future use | ||
HELD_BY | VARCHAR2 | (40) | For future use | |
RESUME_PROVISIONING_DATE | DATE | For future use | ||
RESUMED_BY | VARCHAR2 | (40) | For future use | |
WF_ITEM_TYPE | VARCHAR2 | (8) | Workflow item type for this work item instance | |
WF_ITEM_KEY | VARCHAR2 | (240) | Workflow item key for this work item instance | |
ERROR_REF_ID | NUMBER | A handle to the error table | ||
MSGID | RAW | (16) | A handle to the work item process queue | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ACTUAL_PROVISIONING_DATE | DATE | Actual Fulfillment Date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Attribute Category | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexvfeld | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexvfeld |
Cut, paste (and edit) the following text to query this object:
SELECT WORKITEM_INSTANCE_ID
, LINE_ITEM_ID
, ORDER_ID
, LINE_NUMBER
, WORKITEM_ID
, STATUS_CODE
, STATE
, PROVISIONING_DATE
, WI_SEQUENCE
, WI_RUNTIME_MESSAGE_ID
, PRIORITY
, DUE_DATE
, CUSTOMER_REQUIRED_DATE
, COMPLETION_DATE
, CANCEL_PROVISIONING_DATE
, CANCELED_BY
, HOLD_PROVISIONING_DATE
, HELD_BY
, RESUME_PROVISIONING_DATE
, RESUMED_BY
, WF_ITEM_TYPE
, WF_ITEM_KEY
, ERROR_REF_ID
, MSGID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ACTUAL_PROVISIONING_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM XDP.XDP_FULFILL_WORKLIST;
XDP.XDP_FULFILL_WORKLIST does not reference any database object
XDP.XDP_FULFILL_WORKLIST is referenced by following:
|
|
|