[Home] [Help]
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
Name |
WBSC_ID |
SVCPLN_SVCPLN_ID |
MEDIA_TYPE |
DEPTH |
PARENT_ID |
ORIGINAL_NAME |
ACTIVE_Y_N |
SERVICE_CATEGORY_NAME |
DESCRIPTION |