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