[Home] [Help] [Dependency Information]
Object Name: | XDP_FES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XDP.XDP_FES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
FE_ID | NUMBER | Yes | Fulfillment Element identifier | |
FETYPE_ID | NUMBER | Yes | Fulfillment Element Type identifier | |
FULFILLMENT_ELEMENT_NAME | VARCHAR2 | (40) | Yes | Name of the Fulfillment Element |
MAX_CONNECTION | NUMBER | Yes | Maximum number of concurrent connections the Fulfillment Element allows | |
MIN_CONNECTION | NUMBER | Yes | Minimum number of concurrent connections the Fulfillment Element allows | |
SESSION_CONTROLLER_ID | NUMBER | Not used. For future use | ||
VALID_DATE | DATE | Date indicating when the Fulfillment Element is active for use | ||
INVALID_DATE | DATE | Date indicating when the Fulfillment Element is inactive for use | ||
GEO_AREA_ID | NUMBER | Geographic area for the Fulfillment Element. | ||
ROLE_NAME | VARCHAR2 | (100) | Group to be notified if problem occurs with the object. | |
NETWORK_UNIT_ID | NUMBER | Network Unit identifier for the Fulfillment Element | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
DISPLAY_NAME | VARCHAR2 | (80) | Yes | Display Name of the Fulfillment Element |
DESCRIPTION | VARCHAR2 | (2000) | Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FE_ID
, FETYPE_ID
, FULFILLMENT_ELEMENT_NAME
, MAX_CONNECTION
, MIN_CONNECTION
, SESSION_CONTROLLER_ID
, VALID_DATE
, INVALID_DATE
, GEO_AREA_ID
, ROLE_NAME
, NETWORK_UNIT_ID
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DISPLAY_NAME
, DESCRIPTION
FROM APPS.XDP_FES_VL;
|
|
|