[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | Complete View for table OKR_PROP_PARTY_RELS_B, FND_LOOKUPS and OKX_PARTIES_V |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PPRB.PPR_ID PPR_ID
, PPRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PPRT.SFWT_FLAG SFWT_FLAG
, PPRB.IP_ID IP_ID
, PPRB.IP_TYPE IP_TYPE
, PPRB.ROLE_CODE ROLE_CODE
, ROL.MEANING ROLE_CODE_MEANING
, PPRB.OBJECT1_ID1 OBJECT1_ID1
, PPRB.OBJECT1_ID2 OBJECT1_ID2
, PPRB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, PPRB.PARENT_PPR_ID PARENT_PPR_ID
, OKR_UTIL_PUB.GET_CONTRIB_PARTY_NAME(PPRB.JTOT_OBJECT1_CODE
, PPRB.OBJECT1_ID1
, PPRB.OBJECT1_ID2) PARTY_NAME
, PPRB.START_DATE START_DATE
, PPRB.END_DATE END_DATE
, PPRT.DESCRIPTION DESCRIPTION
, PPRT.NOTE NOTE
, PPRB.DISPLAY_ORDER DISPLAY_ORDER
, PPRB.WORK_FOR_HIRE WORK_FOR_HIRE
, PPRT.CHARACTER CHARACTER
, PPRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PPRB.ATTRIBUTE1 ATTRIBUTE1
, PPRB.ATTRIBUTE2 ATTRIBUTE2
, PPRB.ATTRIBUTE3 ATTRIBUTE3
, PPRB.ATTRIBUTE4 ATTRIBUTE4
, PPRB.ATTRIBUTE5 ATTRIBUTE5
, PPRB.ATTRIBUTE6 ATTRIBUTE6
, PPRB.ATTRIBUTE7 ATTRIBUTE7
, PPRB.ATTRIBUTE8 ATTRIBUTE8
, PPRB.ATTRIBUTE9 ATTRIBUTE9
, PPRB.ATTRIBUTE10 ATTRIBUTE10
, PPRB.ATTRIBUTE11 ATTRIBUTE11
, PPRB.ATTRIBUTE12 ATTRIBUTE12
, PPRB.ATTRIBUTE13 ATTRIBUTE13
, PPRB.ATTRIBUTE14 ATTRIBUTE14
, PPRB.ATTRIBUTE15 ATTRIBUTE15
, PPRB.CREATED_BY CREATED_BY
, PPRB.CREATION_DATE CREATION_DATE
, PPRB.LAST_UPDATED_BY LAST_UPDATED_BY
, PPRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PPRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKR_IP_PARTY_RELS_B PPRB
, OKR_IP_PARTY_RELS_TL PPRT
, FND_LOOKUPS ROL
WHERE PPRB.PPR_ID = PPRT.PPR_ID
AND PPRT.LANGUAGE = USERENV('LANG')
AND ROL.LOOKUP_TYPE = 'OKR_PARTY_ROLES'
AND ROL.LOOKUP_CODE = PPRB.ROLE_CODE