[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 |