[Home] [Help]
View: OKCAUDET_RULE_GROUPS_HV
View Text
SELECT RG.ID ID
, RG.MAJOR_VERSION
, RG.RGD_CODE RGD_CODE
, RG.CHR_ID CHR_ID
, RG.DNZ_CHR_ID DNZ_CHR_ID
, RG.CLE_ID CLE_ID
, L.MEANING RULE_GROUP
, L2.MEANING RULE
, R.COMMENTS DESCRIPTION
FROM OKC_RULE_GROUPS_HV RG
, OKC_RULES_HV R
, FND_LOOKUPS L
, OKC_RULE_DEFS_V L2
WHERE RG.ID = R.RGP_ID
AND L.LOOKUP_CODE = RG.RGD_CODE
AND L.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF'
AND R.RULE_INFORMATION_CATEGORY = L2.RULE_CODE
Columns
Name |
ID |
MAJOR_VERSION |
RGD_CODE |
CHR_ID |
DNZ_CHR_ID |
CLE_ID |
RULE_GROUP |
RULE |
DESCRIPTION |