[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | View for table OKR_PROP_PARTY_ROLES |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PPEB.ROWID
, PPEB.ID ID
, PPEB.IP_TYPE IP_TYPE
, OKR_UTIL_PUB.GET_IP_TYP_MEANING(PPEB.IP_TYPE) IP_TYPE_MEANING
, PPEB.ROLE_CODE ROLE_CODE
, ROL.MEANING ROLE_CODE_MEANING
, ROL.DESCRIPTION ROLE_CODE_DESC
, PPEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PPEB.CREATOR_YN CREATOR_YN
, PPEB.TRANSACT_YN TRANSACT_YN
, PPEB.PRIMARY_YN PRIMARY_YN
, PPEB.REQUIRED_YN REQUIRED_YN
, PPEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PPEB.ATTRIBUTE1 ATTRIBUTE1
, PPEB.ATTRIBUTE2 ATTRIBUTE2
, PPEB.ATTRIBUTE3 ATTRIBUTE3
, PPEB.ATTRIBUTE4 ATTRIBUTE4
, PPEB.ATTRIBUTE5 ATTRIBUTE5
, PPEB.ATTRIBUTE6 ATTRIBUTE6
, PPEB.ATTRIBUTE7 ATTRIBUTE7
, PPEB.ATTRIBUTE8 ATTRIBUTE8
, PPEB.ATTRIBUTE9 ATTRIBUTE9
, PPEB.ATTRIBUTE10 ATTRIBUTE10
, PPEB.ATTRIBUTE11 ATTRIBUTE11
, PPEB.ATTRIBUTE12 ATTRIBUTE12
, PPEB.ATTRIBUTE13 ATTRIBUTE13
, PPEB.ATTRIBUTE14 ATTRIBUTE14
, PPEB.ATTRIBUTE15 ATTRIBUTE15
, PPEB.CREATED_BY CREATED_BY
, PPEB.CREATION_DATE CREATION_DATE
, PPEB.LAST_UPDATED_BY LAST_UPDATED_BY
, PPEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PPEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_PARTY_ROLES PPEB
, FND_LOOKUPS ROL
WHERE ROL.LOOKUP_TYPE = 'OKR_PARTY_ROLES'
AND ROL.LOOKUP_CODE = PPEB.ROLE_CODE