View: IEB_SVC_CAT_TEMPLATES

Product:	IEB - Interaction Blending
Description:	This is a view of service category templates.
Implementation/DBA Data:	APPS.IEB_SVC_CAT_TEMPLATES

View Text

SELECT SCTEMPB.WBSC_ID
, SCTEMPB.SVCPLN_SVCPLN_ID
, SCTEMPB.MEDIA_TYPE
, SCTEMPB.DEPTH
, SCTEMPB.PARENT_ID
, SCTEMPB.ORIGINAL_NAME
, SCTEMPB.ACTIVE_Y_N
, SCTEMPTL.SERVICE_CATEGORY_NAME
, SCTEMPTL.DESCRIPTION
FROM IEB_SVC_CAT_TEMPS_B SCTEMPB
, IEB_SVC_CAT_TEMPS_TL SCTEMPTL
WHERE SCTEMPB.WBSC_ID = SCTEMPTL.WBSC_ID
AND SCTEMPTL.LANGUAGE = USERENV('LANG')

Columns