[Home] [Help] [Dependency Information]
Object Name: | IEB_SVC_CAT_TEMPLATES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IEB.IEB_SVC_CAT_TEMPLATES |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IEB_SVC_CAT_TEMPLATES is a view of service category templates. Service Category Templates contain the predefined properties for top level service categories. Whenever a new Interaction Blending Server is created, Interaction Blending Server Admin utility automatically creates the top level service categories for the server using the service category properties defined in the templates.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WBSC_ID | NUMBER | (15) | Yes | Service Category ID |
SVCPLN_SVCPLN_ID | NUMBER | (15) | Yes | ID of the service plan used by this service category |
MEDIA_TYPE | VARCHAR2 | (80) | Yes | Media type of the tasks in this service category |
DEPTH | NUMBER | (4) | Yes | Depth of the service category node. |
PARENT_ID | NUMBER | (15) | ID of the parent service category | |
ORIGINAL_NAME | VARCHAR2 | (80) | Yes | Service Category's Original English Name |
ACTIVE_Y_N | VARCHAR2 | (1) | Yes | Flag indicating if this service category entry is active. |
SERVICE_CATEGORY_NAME | VARCHAR2 | (80) | Yes | Service Category's translated name in user language. |
DESCRIPTION | VARCHAR2 | (1996) | Description of the service category in user's language. |
Cut, paste (and edit) the following text to query this object:
SELECT WBSC_ID
, SVCPLN_SVCPLN_ID
, MEDIA_TYPE
, DEPTH
, PARENT_ID
, ORIGINAL_NAME
, ACTIVE_Y_N
, SERVICE_CATEGORY_NAME
, DESCRIPTION
FROM APPS.IEB_SVC_CAT_TEMPLATES;
APPS.IEB_SVC_CAT_TEMPLATES is not referenced by any database object
|
|
|