[Home] [Help] [Dependency Information]
Object Name: | XDP_FES |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | XDP.XDP_FES |
Subobject Name: | |
Status: | VALID |
XDP_FES is used to contain 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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_FES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | FE_ID |
XDP_FES_U3 | NORMAL | UNIQUE | APPS_TS_SEED | FULFILLMENT_ELEMENT_NAME |
XDP_FES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | GEO_AREA_ID |
XDP_FES_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | FETYPE_ID |
XDP_FES_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | VALID_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 it allows | |
MIN_CONNECTION | NUMBER | Yes | Minimum number of concurrent connections it allows | |
SESSION_CONTROLLER_ID | NUMBER | Reserved 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 Adapter | ||
CREATION_DATE | DATE | Yes | Standard whocolumn | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard whocolumn |
CREATED_BY | NUMBER | (15) | Yes | Standard whocolumn |
LAST_UPDATE_DATE | DATE | Yes | Standard whocolumn | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard whocolumn | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, SECURITY_GROUP_ID
FROM XDP.XDP_FES;
XDP.XDP_FES does not reference any database object
XDP.XDP_FES is referenced by following:
|
|
|