View: XDP_SVE_VAL_ACTION_DISP_V

Product:	XDP - Provisioning
Description:	The view XDP_SERVICE_VAL_ACTION_DISP_V 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
Implementation/DBA Data:	APPS.XDP_SVE_VAL_ACTION_DISP_V

View Text

SELECT B.ROWID ROW_ID
, B.SERVICE_VAL_ACT_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ACTION_SOURCE
, F.LOOKUP_CODE ACTION_CODE
, F.MEANING ACTION_DISPLAY_NAME
, B.WI_MAPPING_TYPE
, B.WI_MAPPING_PROC
, B.VALID_DATE
, B.INVALID_DATE
, 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
, FND_LOOKUPS F
WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
AND B.ACTION_SOURCE = 'XDP'
AND B.ACTION_CODE = F.LOOKUP_CODE
AND F.LOOKUP_TYPE = 'XDP_ACTIONS'
AND T.LANGUAGE = USERENV('LANG') UNION SELECT B.ROWID ROW_ID
, B.SERVICE_VAL_ACT_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ACTION_SOURCE
, TO_CHAR(OT.TRANSACTION_TYPE_ID) ACTION_CODE
, OT.NAME ACTION_DISPLAY_NAME
, B.WI_MAPPING_TYPE
, B.WI_MAPPING_PROC
, B.VALID_DATE
, B.INVALID_DATE
, 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
, OE_TRANSACTION_TYPES_TL OT
WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
AND B.ACTION_SOURCE = 'SALES'
AND OT.TRANSACTION_TYPE_ID = TO_NUMBER(B.ACTION_CODE)
AND T.LANGUAGE = USERENV('LANG')
AND OT.LANGUAGE = USERENV('LANG')

Columns