[Home] [Help] [Dependency Information]
Object Name: | XDP_SERVICE_WI_MAP |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_SERVICE_WI_MAP |
Subobject Name: | |
Status: | VALID |
XDP_SERVICE_WI_MAP is used define the list of work items that need to be executed to fulfill the given service action
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_SERVICE_WI_MAP_U1 | NORMAL | UNIQUE | APPS_TS_SEED | SERVICE_WI_MAP_ID |
XDP_SERVICE_WI_MAP_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | WORKITEM_ID |
XDP_SERVICE_WI_MAP_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | SERVICE_VAL_ACT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_WI_MAP_ID | NUMBER | Yes | Service work item mapping identifier | |
SERVICE_VAL_ACT_ID | NUMBER | Yes | Valid service action identifier for the service work item mapping | |
WORKITEM_ID | NUMBER | Yes | Work item indentifier which is mapped to the service | |
PROVISION_SEQ | NUMBER | Yes | Fulfillment sequence for the work item mapped to the service | |
MAPPING_TYPE | VARCHAR2 | (40) | Yes | Type of mapping between the service and the work item |
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 | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT SERVICE_WI_MAP_ID
, SERVICE_VAL_ACT_ID
, WORKITEM_ID
, PROVISION_SEQ
, MAPPING_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XDP.XDP_SERVICE_WI_MAP;
XDP.XDP_SERVICE_WI_MAP does not reference any database object
XDP.XDP_SERVICE_WI_MAP is referenced by following:
|
|
|