eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.XDP_SERVICE_VAL_ACTS_VL

Object Details

Object Name:	XDP_SERVICE_VAL_ACTS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XDP.XDP_SERVICE_VAL_ACTS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

The view XDP_SERVICE_VAL_ACTS_VL is used to define the valid sales action for a given service. For example, the action 'ADD' for service 'ISDN'. Each service action will then map to a list of workitem to be executed. In some cases the list of the workitems to be executed can not be determined at configuration time because it may vary based on the order information. The WI_MAPPING_PROC column is designed to be used for such case. The user can specify his mapping logic in this procedure base on the order information and use XDP_OA_UTIL.Add_WI_toLine API to create the workitem mapping at runtime. SFM engine will then execute this procedure to create the order line fulfillment wok list.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
SERVICE_VAL_ACT_ID	NUMBER		Yes	Service Valid Action identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier for Item Definition
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Identifier to which Action is mapped
ACTION_CODE	VARCHAR2	(30)		Action Code
ACTION_SOURCE	VARCHAR2	(30)	Yes
VALID_DATE	DATE			Date indicating when the Service Action is active for use
INVALID_DATE	DATE			Date indicating when the Service Action is inactive for use
WI_MAPPING_PROC	VARCHAR2	(80)		Dynamic Mapping Procedure for the Service Valid Action
WI_MAPPING_TYPE	VARCHAR2	(40)		Type of Work Item Mapping procedure for the Service Valid Action. Can have a value of "STATIC" or "DYNAMIC"
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
DESCRIPTION	VARCHAR2	(2000)		Description

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      SERVICE_VAL_ACT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ACTION_CODE
,      ACTION_SOURCE
,      VALID_DATE
,      INVALID_DATE
,      WI_MAPPING_PROC
,      WI_MAPPING_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
FROM APPS.XDP_SERVICE_VAL_ACTS_VL;

Dependencies

[top of page]

APPS.XDP_SERVICE_VAL_ACTS_VL references the following:

APPS: XDP_SERVICE_VAL_ACTS; XDP_SERVICE_VAL_ACTS_TL

APPS.XDP_SERVICE_VAL_ACTS_VL is not referenced by any database object