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.

[Home] [Help]

View: XDP_SERVICE_WI_MAP_VL

Product:	XDP - Provisioning
Description:	The view XDP_SERVICE_WI_MAPPING_VL is used define the list of workitem which need to be executed to fulfill the given service sales action.
Implementation/DBA Data:	APPS.XDP_SERVICE_WI_MAP_VL

View Text

SELECT B.ROWID ROW_ID
, B.SERVICE_WI_MAP_ID
, B.SERVICE_VAL_ACT_ID
, B.WORKITEM_ID
, B.MAPPING_TYPE
, B.PROVISION_SEQ
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION
FROM XDP_SERVICE_WI_MAP_TL T
, XDP_SERVICE_WI_MAP B
WHERE B.SERVICE_WI_MAP_ID = T.SERVICE_WI_MAP_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
SERVICE_WI_MAP_ID
SERVICE_VAL_ACT_ID
WORKITEM_ID
MAPPING_TYPE
PROVISION_SEQ
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
LAST_UPDATE_LOGIN
DESCRIPTION