FND Design Data [Home] [Help]

View: XDP_FE_ATTRIBUTE_VAL_VL

Product: XDP - Provisioning
Description: This view contains the configuration data for SFM to communicate with a given fulfillmentelement. Example: 144.126.174.151 is the IP address for the logical name of 'FE 'ROUTER_NY1'.
Implementation/DBA Data: ViewAPPS.XDP_FE_ATTRIBUTE_VAL_VL
View Text

SELECT B.ROWID ROW_ID
, B.FE_ATTRIBUTE_ID
, B.FE_GENERIC_CONFIG_ID
, B.FE_ATTRIBUTE_VALUE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM XDP_FE_ATTRIBUTE_VAL_TL T
, XDP_FE_ATTRIBUTE_VAL B
WHERE B.FE_ATTRIBUTE_ID = T.FE_ATTRIBUTE_ID
AND B.FE_GENERIC_CONFIG_ID = T.FE_GENERIC_CONFIG_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
FE_ATTRIBUTE_ID
FE_GENERIC_CONFIG_ID
FE_ATTRIBUTE_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DISPLAY_NAME
DESCRIPTION