[Home] [Help]
View: OKS_EVENTS_V
Product: | OKS - Service Contracts |
Description: | View for Service Contracts Events |
Implementation/DBA Data: |
APPS.OKS_EVENTS_V
|
View Text
SELECT CNHB.ID
, CNHB.COUNTER_GROUP_ID
, CNHT.NAME
, CNHT.DESCRIPTION
, CNHB.ONE_TIME_YN
, CNHB.DATE_ACTIVE
, CNHB.DATE_INACTIVE
, CNHB.CNH_TYPE
, CNHB.TEMPLATE_YN
FROM OKC_CONDITION_HEADERS_B CNHB
, OKC_CONDITION_HEADERS_TL CNHT
WHERE CNHB.ID = CNHT.ID
AND CNHT.LANGUAGE = USERENV('LANG')
Columns
Name |
ID |
COUNTER_GROUP_ID |
NAME |
DESCRIPTION |
ONE_TIME_YN |
DATE_ACTIVE |
DATE_INACTIVE |
CNH_TYPE |
TEMPLATE_YN |