[Home] [Help]
View: IEB_SVC_CAT_CLASSIFICATIONS_V
Product: | IEB - Interaction Blending |
Description: | This view combines the WB_SVC_CAT, WB_SERVER and WB_SVC_CAT_RULES tables to allow viewing service categories based on classifications |
Implementation/DBA Data: |
APPS.IEB_SVC_CAT_CLASSIFICATIONS_V
|
View Text
SELECT A.WB_SERVER_NAME
, B.WBSC_ID
, B.SERVICE_CATEGORY_NAME
, B.DESCRIPTION
, C.CLASSIFICATION
, B.MEDIA_TYPE
, B.ACTIVE_Y_N
FROM IEB_WB_SERVERS A
, IEB_WB_SVC_CATS B
, IEB_WB_SVC_CAT_RULES C
WHERE A.WBSVR_ID = B.WBSVR_WBSVR_ID
AND B.WBSC_ID = C.WBSC_WBSC_ID
Columns
Name |
WB_SERVER_NAME |
WBSC_ID |
SERVICE_CATEGORY_NAME |
DESCRIPTION |
CLASSIFICATION |
MEDIA_TYPE |
ACTIVE_Y_N |