View: XDP_SERVICE_VAL_ACTS_VL

Product:	XDP - Provisioning
Description:	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
Implementation/DBA Data:	APPS.XDP_SERVICE_VAL_ACTS_VL

View Text

SELECT B.ROWID ROW_ID
, B.SERVICE_VAL_ACT_ID
, B.ORGANIZATION_ID
, B.INVENTORY_ITEM_ID
, B.ACTION_CODE
, B.ACTION_SOURCE
, B.VALID_DATE
, B.INVALID_DATE
, B.WI_MAPPING_PROC
, B.WI_MAPPING_TYPE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION
FROM XDP_SERVICE_VAL_ACTS_TL T
, XDP_SERVICE_VAL_ACTS B
WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
AND T.LANGUAGE = USERENV('LANG')

Columns