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')
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')
|
|
|