Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RGM.ROWID ROW_ID
, RGM.RGP_ID
, PRGT.NAME
, PRGT.DESCRIPTION
, PRGB.IP_TYPE IP_TYPE
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(PRGB.IP_TYPE) IP_TYPE_MEANING
, RGM.VAL_PTRT_ID VAL_PTRT_ID
, VPR.RGTP_ID RGTP_ID
, RTYT.NAME RTY_NAME
, RTYT.DESCRIPTION RTY_DESCRIPTION
, RGM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RGM.CREATED_BY CREATED_BY
, RGM.CREATION_DATE CREATION_DATE
, RGM.LAST_UPDATED_BY LAST_UPDATED_BY
, RGM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RGM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_RGT_GRP_MEMS RGM
, OKR_PROP_RGT_GRPS_B PRGB
, OKR_PROP_RGT_GRPS_TL PRGT
, OKR_RIGHT_TYPES_B RTYB
, OKR_RIGHT_TYPES_TL RTYT
, OKR_VALID_PROP_RGTS VPR
WHERE RGM.RGP_ID = PRGB.ID
AND PRGB.ID = PRGT.ID
AND PRGT.LANGUAGE = USERENV('LANG')
AND RGM.VAL_PTRT_ID = VPR.ID
AND VPR.RGTP_ID = RTYB.ID
AND RTYB.ID = RTYT.ID
AND RTYT.LANGUAGE = USERENV('LANG')