View: PN_RIGHTS_V

Product:	PN - Property Manager
Description:	Form view used to input rights information
Implementation/DBA Data:	APPS.PN_RIGHTS_V

View Text

SELECT PNR.ROWID ROW_ID
, PNR.RIGHT_ID RIGHT_ID
, PNR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PNR.LAST_UPDATED_BY LAST_UPDATED_BY
, PNR.CREATION_DATE CREATION_DATE
, PNR.CREATED_BY CREATED_BY
, PNR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PNR.LEASE_ID LEASE_ID
, PNR.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PNR.RIGHT_NUM RIGHT_NUM
, PNR.RIGHT_TYPE_CODE RIGHT_TYPE_CODE
, TLK.MEANING RIGHT_TYPE
, PNR.RIGHT_STATUS_CODE RIGHT_STATUS_CODE
, RLK.MEANING RIGHT_STATUS
, PNR.RIGHT_REFERENCE RIGHT_REFERENCE
, PNR.START_DATE START_DATE
, PNR.EXPIRATION_DATE EXPIRATION_DATE
, PNR.RIGHT_COMMENTS RIGHT_COMMENTS
, PNR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PNR.ATTRIBUTE1 ATTRIBUTE1
, PNR.ATTRIBUTE2 ATTRIBUTE2
, PNR.ATTRIBUTE3 ATTRIBUTE3
, PNR.ATTRIBUTE4 ATTRIBUTE4
, PNR.ATTRIBUTE5 ATTRIBUTE5
, PNR.ATTRIBUTE6 ATTRIBUTE6
, PNR.ATTRIBUTE7 ATTRIBUTE7
, PNR.ATTRIBUTE8 ATTRIBUTE8
, PNR.ATTRIBUTE9 ATTRIBUTE9
, PNR.ATTRIBUTE10 ATTRIBUTE10
, PNR.ATTRIBUTE11 ATTRIBUTE11
, PNR.ATTRIBUTE12 ATTRIBUTE12
, PNR.ATTRIBUTE13 ATTRIBUTE13
, PNR.ATTRIBUTE14 ATTRIBUTE14
, PNR.ATTRIBUTE15 ATTRIBUTE15
, PNR.ORG_ID ORG_ID
FROM PN_RIGHTS PNR
, FND_LOOKUPS TLK
, FND_LOOKUPS RLK
WHERE TLK.LOOKUP_CODE = PNR.RIGHT_TYPE_CODE
AND TLK.LOOKUP_TYPE = 'PN_RIGHTS_TYPE'
AND RLK.LOOKUP_CODE = PNR.RIGHT_STATUS_CODE
AND RLK.LOOKUP_TYPE = 'PN_RIGHT_STATUS_TYPE'

Columns