VIEW: APPS.IEB_SVC_CAT_CLASSIFICATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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