FND Design Data [Home] [Help]

View: XDP_SERVICES_VL

Product: XDP - Provisioning
Description: The view XDP_SERVICES_VL holds all the names assigned to a service offered by a service provider. NOTE: A service can also be a product name and are often interchangeable.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT B.ROWID ROW_ID
, B.SERVICE_ID
, B.SERVICE_NAME
, B.ROLE_NAME
, B.VERSION
, B.PROV_REQUIRED_FLAG
, B.VALID_DATE
, B.INVALID_DATE
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM XDP_SERVICES_TL T
, XDP_SERVICES B
WHERE B.SERVICE_ID = T.SERVICE_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
SERVICE_ID
SERVICE_NAME
ROLE_NAME
VERSION
PROV_REQUIRED_FLAG
VALID_DATE
INVALID_DATE
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
LAST_UPDATE_LOGIN
DISPLAY_NAME
DESCRIPTION