[Home] [Help] [Dependency Information]
Object Name: | XDP_WORKITEMS |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_WORKITEMS |
Subobject Name: | |
Status: | VALID |
XDP_WORKITEMS is used to define a work item. A work item can be viewed as a job to fulfill a valid service action offering. A typical work item will consist of a list of fulfillment actions to be executed.
The WI_TYPE_CODE column is used to identify what type of fulfillment mapping needs to be used for this work item. The valid values for the mapping type are:
STATIC -
The list of all fulfillment actions to be executed can be decided at the configuration time. You can configure the work item fulfillment action mapping.
DYNAMIC -
The list of all fulfillment actions to be executed can only be decided at the runtime when the order arrives. You can define the dynamic mapping logic in a PL/SQL procedure specified by FA_EXEC_MAP_PROC column and use API XDP_ENG_UTIL.Add_FA_ToWI to create the fulfillment action list for this work item at runtime.
WORKFLOW -
The list of all fulfillment actions to be executed is conditional based on the execution result for each fulfillment action. You can define your own workflow for this work item. User defined workflow is identified by the columns USER_WF_ITEM_TYPE, USER_WF_ITEM_KEY and USER_WF_PROCESS_NAME which are required to be updated at configuration time.
WORKFLOW_PROC -
The list of all fulfillment actions to be executed is conditional based on the execution result of each fulfillment action and can vary on basis of the order information. You may define several workflows for this work item and instruct application about which workflow should be executed at runtime. Column WF_EXEC_PROC should be updated at the configuration time with a PL/SQL procedure which will dynamically create the appropriate workflow process at runtime and return the workflow item type, item key and process name to the provisioning engine
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_WORKITEMS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
WORKITEM_ID
ZD_EDITION_NAME |
XDP_WORKITEMS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
WORKITEM_NAME
VERSION ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKITEM_ID | NUMBER | Yes | Work item identifier | |
WORKITEM_NAME | VARCHAR2 | (40) | Yes | Work item name |
VERSION | VARCHAR2 | (40) | Yes | Work item version |
WI_TYPE_CODE | VARCHAR2 | (40) | Yes | Internal code representing the type of work item |
VALID_DATE | DATE | Date indicating when the work item is active for use | ||
INVALID_DATE | DATE | Date indicating when the work item is inactive for use | ||
FA_EXEC_MAP_PROC | VARCHAR2 | (80) | Dynamic mapping procedure for fulfillment actions for work item | |
USER_WF_ITEM_TYPE | VARCHAR2 | (8) | The item type of the user defined workflow for the work item | |
USER_WF_ITEM_KEY_PREFIX | VARCHAR2 | (240) | The item key prefix of the user defined workflow for the work item | |
USER_WF_PROCESS_NAME | VARCHAR2 | (40) | The process name of the user defined workflow for the work item | |
WF_EXEC_PROC | VARCHAR2 | (80) | Dynamic procedure which initiates appropriate user defined workflow for the work item | |
TIME_ESTIMATE | NUMBER | Not used. For future use | ||
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Internal flag to indicate if the work item is seeded data or not |
ROLE_NAME | VARCHAR2 | (100) | Owner role name | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
VALIDATION_PROCEDURE | VARCHAR2 | (80) | Validation procedure to validate Workitem when order is submitted | |
VALIDATION_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whetherthe validation procedure shall be executed when an order is submitted |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT WORKITEM_ID
, WORKITEM_NAME
, VERSION
, WI_TYPE_CODE
, VALID_DATE
, INVALID_DATE
, FA_EXEC_MAP_PROC
, USER_WF_ITEM_TYPE
, USER_WF_ITEM_KEY_PREFIX
, USER_WF_PROCESS_NAME
, WF_EXEC_PROC
, TIME_ESTIMATE
, PROTECTED_FLAG
, ROLE_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, VALIDATION_PROCEDURE
, VALIDATION_ENABLED_FLAG
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM XDP.XDP_WORKITEMS;
XDP.XDP_WORKITEMS does not reference any database object
XDP.XDP_WORKITEMS is referenced by following:
|
|
|