eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKC_RG_BLK_HV

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.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