DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IEB_SVC_CAT_TEMPLATES

Object Details
Object Name: IEB_SVC_CAT_TEMPLATES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIEB.IEB_SVC_CAT_TEMPLATES
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.IEB_SVC_CAT_TEMPLATES references the following:

SchemaAPPS
SynonymIEB_SVC_CAT_TEMPS_B
SynonymIEB_SVC_CAT_TEMPS_TL

APPS.IEB_SVC_CAT_TEMPLATES is not referenced by any database object