[Home] [Help]
View: OKL_RULE_GROUPS_UV
View Text
SELECT RG.ID ID
, RG.RGP_TYPE RGP_TYPE
, TL.SFWT_FLAG SFWT_FLAG
, RG.RGD_CODE RGD_CODE
, RG.CLE_ID CLE_ID
, RG.CHR_ID CHR_ID
, RG.DNZ_CHR_ID DNZ_CHR_ID
, RG.PARENT_RGP_ID PARENT_RGP_ID
, RG.SAT_CODE SAT_CODE
, TL.COMMENTS COMMENTS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKC_RULE_GROUP_DEF'
, RG.RGD_CODE
, 510
, 0) NAME
FROM OKC_RULE_GROUPS_TL TL
, OKC_RULE_GROUPS_B RG
WHERE RG.ID = TL.ID
AND TL.LANGUAGE = USERENV('LANG')
Columns
Name |
ID |
RGP_TYPE |
SFWT_FLAG |
RGD_CODE |
CLE_ID |
CHR_ID |
DNZ_CHR_ID |
PARENT_RGP_ID |
SAT_CODE |
COMMENTS |
NAME |