[Home] [Help] [Dependency Information]
Object Name: | XDP_WORKITEMS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XDP.XDP_WORKITEMS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
The view XDP_WORKITEMS_VL is used to define an SFM workitem. An SFM workitem can be viewed as a job to fulfill a service offering/sales action. A typical workitem will consist of a list of fulfillment actions to be executed. The WI_TYPE_CODE column is used to identify what type of FA mapping approach needs to be used for this workitem. The valid values for the WI_TYPE_CODE are:
STATIC:
The list of all the FAs to be executed can be decided in configuration time. The user can define the FA mapping in the XDP_ WI_FA_MAPPING table.
DYNAMIC:
The list of all the FAs to be executed can only be decided at runtime when the order arrives. The user can define the mapping logic in the FA_EXEC_MAP_PROC and use API XDP_ENG_UTIL.Add_FA_toWI to create the FA list for this workitem at runtime.
WORKFLOW:
The list of all the FAs to be executed is conditional based on the execution result for each FA. The user can define the process flow in a user defined workflow. The user should identify which workflow to execute by populating the user_wf_item_type, user_wf_item_key, and user_wf_process_name in configuration time.
WORKFLOW_PROC:
The list of all the FAs to be executed is conditional based on the execution result of each FA. In addition, the process flow for this workitem can vary base on the order information. The user may define several workflows for this workitem and instruct SDP on which workflow to execute at runtime. In such cases, the user can use the WF_EXEC_PROC column to define a PL/SQL procedure which will create the appropriate workflow process at runtime and return the workflow item type, item key and process name to the SFM engine .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
WORKITEM_ID | NUMBER | Yes | Work Item identifier | |
WORKITEM_NAME | VARCHAR2 | (40) | Yes | Name of the Work Item |
ROLE_NAME | VARCHAR2 | (100) | Group to be nofified if problem occurs with the object. | |
VERSION | VARCHAR2 | (40) | Yes | Version of the Work Item |
WI_TYPE_CODE | VARCHAR2 | (40) | Yes | Internal code representing the type of Work Item. Can be "STATIC", "DYNAMIC", "USER DEFINED WORKFLOW", "WORKFLOW START PROCEDURE" |
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) | Fulfillment Action Dynamic Mapping Procedure for the Work Item | |
USER_WF_ITEM_TYPE | VARCHAR2 | (8) | The item type of the workflow mapped to the Work Item | |
USER_WF_ITEM_KEY_PREFIX | VARCHAR2 | (240) | The item key prefix of the workflow mapped to the Work Item | |
USER_WF_PROCESS_NAME | VARCHAR2 | (40) | Workflow process name mapped to the Work Item | |
WF_EXEC_PROC | VARCHAR2 | (80) | Workflow Start Procedure mapped to the Work Item | |
TIME_ESTIMATE | NUMBER | Estimate time to undertake the Work Item | ||
VALIDATION_PROCEDURE | VARCHAR2 | (80) | ||
VALIDATION_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Internal flag to indicate if the Work Item is protected or not (ie Seed Data) |
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 | |
DISPLAY_NAME | VARCHAR2 | (80) | Yes | Display Name of Work Item |
DESCRIPTION | VARCHAR2 | (2000) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, WORKITEM_ID
, WORKITEM_NAME
, ROLE_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
, VALIDATION_PROCEDURE
, VALIDATION_ENABLED_FLAG
, PROTECTED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, DISPLAY_NAME
, DESCRIPTION
FROM APPS.XDP_WORKITEMS_VL;
|
|
|