[Home] [Help]
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
Name |
ID |
RGD_CODE |
CHR_ID |
DNZ_CHR_ID |
CLE_ID |
RULE_GROUP |
RULE |
DESCRIPTION |