VIEW: APPS.OKL_RULE_GROUPS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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