[Home] [Help] [Dependency Information]
Object Name: | IEB_WB_SVC_CATS |
---|---|
Object Type: | TABLE |
Owner: | IEB |
FND Design Data: | IEB.IEB_WB_SVC_CATS |
Subobject Name: | |
Status: | VALID |
Summary Information of service categories.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEB_WB_SVC_CATS_PK_U | NORMAL | UNIQUE | APPS_TS_TX_IDX | WBSC_ID |
IEB_WB_SVC_CATS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MEDIA_TYPE_ID |
IEB_WB_SVC_CATS_PARENT_FK_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_ID |
IEB_WB_SVC_CATS_SP_FK_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SVCPLN_SVCPLN_ID |
IEB_WB_SVC_CATS_WBSVR_FK_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WBSVR_WBSVR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WBSC_ID | NUMBER | (15) | Yes | Service Category ID |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SERVICE_CATEGORY_NAME | VARCHAR2 | (80) | Yes | Service Category Name |
CAMPAIGN_SERVER_NAME | VARCHAR2 | (80) | IEO Campaign Plus server name related to the Service Category, for outbound use only. | |
CAMPAIGN_NAME | VARCHAR2 | (80) | Name of the AMS Campaign related to the IEO Campaign Plus Server, for outbound use only. | |
ACTIVE_Y_N | VARCHAR2 | (1) | Yes | "Y" if the service category is active |
MEDIA_TYPE | VARCHAR2 | (80) | Yes | Media Type |
DESCRIPTION | VARCHAR2 | (1996) | Description | |
PRIORITY | NUMBER | (4) | Yes | Service Category priority |
DEPTH | NUMBER | (4) | Yes | Depth of the Service category node from the tree top. |
WBSVR_WBSVR_ID | NUMBER | (15) | Yes | WorkBending Server ID created by system |
PARENT_ID | NUMBER | (15) | Service Category ID | |
SVCPLN_SVCPLN_ID | NUMBER | (15) | Yes | Service Plan ID |
OBJECT_VERSION_NUMBER | NUMBER | Sequential number used for database locking control when usinging HTML as a user interface. | ||
SECURITY_GROUP_ID | NUMBER | (15) | This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber. | |
CAMPAIGN_SCHEDULE_ID | NUMBER | Campaign Schedule Id | ||
MEDIA_TYPE_ID | NUMBER | (15) | Media Type ID from the IEU_UWQ_MEDIA_TYPES_B table. | |
DEFAULT_FLAG | VARCHAR2 | (1) | Default Flag to indicate the required parent service categories. |
Cut, paste (and edit) the following text to query this object:
SELECT WBSC_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SERVICE_CATEGORY_NAME
, CAMPAIGN_SERVER_NAME
, CAMPAIGN_NAME
, ACTIVE_Y_N
, MEDIA_TYPE
, DESCRIPTION
, PRIORITY
, DEPTH
, WBSVR_WBSVR_ID
, PARENT_ID
, SVCPLN_SVCPLN_ID
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, CAMPAIGN_SCHEDULE_ID
, MEDIA_TYPE_ID
, DEFAULT_FLAG
FROM IEB.IEB_WB_SVC_CATS;
IEB.IEB_WB_SVC_CATS does not reference any database object
IEB.IEB_WB_SVC_CATS is referenced by following:
|
|
|