View: OKCAUDET_RULE_GROUPS_V

Product:	OKC - Contracts Core
Description:	View for detailed information on rule groups and rules for a contract
Implementation/DBA Data:	APPS.OKCAUDET_RULE_GROUPS_V

View Text

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

Columns