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_SVE_WI_MAPPING_DISP_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
SERVICE_WI_MAP_ID	NUMBER		Yes	Service Work Item Mapping identifier
SERVICE_VAL_ACT_ID	NUMBER		Yes	Service Valid Action identifier for the Service Work Item Mapping
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier for Item Definition
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Identifier to which the WorkItem is mapped
ACTION_CODE	VARCHAR2	(30)		Internal code for the Action mapped to the Inventory Item
ACTION_SOURCE	VARCHAR2	(30)	Yes
WORKITEM_ID	NUMBER		Yes	Identifier of the Work Item mapped to the Service
MAPPING_TYPE	VARCHAR2	(40)	Yes	Internal code representing the type of mapping between the Service and Work Item
WORKITEM_DISPLAY_NAME	VARCHAR2	(80)	Yes	Display Name of the Work Item mapped to the Service
PROVISION_SEQ	NUMBER		Yes	Fulfillment Sequence for the Work Item mapped to the Service
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
DESCRIPTION	VARCHAR2	(2000)		Description

Query Text

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


SELECT ROW_ID
,      SERVICE_WI_MAP_ID
,      SERVICE_VAL_ACT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ACTION_CODE
,      ACTION_SOURCE
,      WORKITEM_ID
,      MAPPING_TYPE
,      WORKITEM_DISPLAY_NAME
,      PROVISION_SEQ
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
FROM APPS.XDP_SVE_WI_MAPPING_DISP_V;

Dependencies

[top of page]

APPS.XDP_SVE_WI_MAPPING_DISP_V references the following:

APPS: XDP_SERVICE_VAL_ACTS; XDP_SERVICE_WI_MAP; XDP_SERVICE_WI_MAP_TL; XDP_WORKITEMS; XDP_WORKITEMS_TL

APPS.XDP_SVE_WI_MAPPING_DISP_V is not referenced by any database object