Product: | XDP - Provisioning |
---|---|
Description: | The XDP_FES_VL view will hold all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element.Example: FE or NE is a DMS200, a Cisco CPC, HA Server. |
Implementation/DBA Data: | APPS.XDP_FES_VL |
SELECT B.ROWID ROW_ID
, B.FE_ID
, B.FETYPE_ID
, B.FULFILLMENT_ELEMENT_NAME
, B.MAX_CONNECTION
, B.MIN_CONNECTION
, B.SESSION_CONTROLLER_ID
, B.VALID_DATE
, B.INVALID_DATE
, B.GEO_AREA_ID
, B.ROLE_NAME
, B.NETWORK_UNIT_ID
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM XDP_FES_TL T
, XDP_FES B
WHERE B.FE_ID = T.FE_ID
AND T.LANGUAGE= USERENV('LANG')