Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PRS.ROWID
, PRS.ID ID
, PRS.PARTY_ROLE_ID PARTY_ROLE_ID
, PRS.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, PRS.START_DATE START_DATE
, PRS.END_DATE END_DATE
, PRL.IP_TYPE
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(PRL.IP_TYPE) IP_TYPE_MEANING
, PRL.ROLE_CODE
, OKR_UTIL_PUB.GET_LU_MEANING('OKR_PARTY_ROLES'
, PRL.ROLE_CODE) ROLE_CODE_MEANING
, PRS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRS.CREATED_BY CREATED_BY
, PRS.CREATION_DATE CREATION_DATE
, PRS.LAST_UPDATED_BY LAST_UPDATED_BY
, PRS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PRS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRS.ACCESS_LEVEL ACCESS_LEVEL
FROM OKR_PTY_RLE_SRCS PRS
, OKR_PARTY_ROLES PRL
WHERE PRS.PARTY_ROLE_ID = PRL.ID