[Home] [Help]
View: OKC_RG_BLK_HV
View Text
SELECT RG.DNZ_CHR_ID
, RG.RGP_TYPE
, RG.CHR_ID
, RG.CLE_ID
, RG.SAT_CODE
, RG.RGD_CODE
, RG.ID
, RG.OBJECT_VERSION_NUMBER
, LKP.MEANING GROUP_NAME
, RG.COMMENTS
, RG.CREATED_BY
, RG.CREATION_DATE
, RG.LAST_UPDATED_BY
, RG.LAST_UPDATE_DATE
, RG.LAST_UPDATE_LOGIN
, RG.MAJOR_VERSION
FROM OKC_RULE_GROUPS_HV RG
, FND_LOOKUPS LKP
WHERE RG.RGD_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF'
Columns
Name |
DNZ_CHR_ID |
RGP_TYPE |
CHR_ID |
CLE_ID |
SAT_CODE |
RGD_CODE |
ID |
OBJECT_VERSION_NUMBER |
GROUP_NAME |
COMMENTS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
MAJOR_VERSION |