VIEW: APPS.OKCAUDET_RULE_GROUPS_V

Source

View Text - Preformatted

SELECT rg.id ID, 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_v rg, okc_rules_v 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

View Text - HTML Formatted

SELECT RG.ID ID
, 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_V RG
, OKC_RULES_V 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