Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_RIGHTS_HISTORY_V |
SELECT PN_RIGHTS.ROWID ROW_ID
, TO_NUMBER(NULL) RIGHT_HISTORY_ID
, PN_RIGHTS.RIGHT_ID RIGHT_ID
, PN_RIGHTS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PN_RIGHTS.LAST_UPDATED_BY LAST_UPDATED_BY
, PN_RIGHTS.CREATION_DATE CREATION_DATE
, PN_RIGHTS.CREATED_BY CREATED_BY
, PN_RIGHTS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PN_RIGHTS.LEASE_ID LEASE_ID
, PN_RIGHTS.LEASE_CHANGE_ID LEASE_CHANGE_ID
, TO_NUMBER(NULL) NEW_LEASE_CHANGE_ID
, PN_RIGHTS.RIGHT_NUM RIGHT_NUM
, PN_RIGHTS.RIGHT_TYPE_CODE RIGHT_TYPE_CODE
, TLOOK.MEANING RIGHT_TYPE
, PN_RIGHTS.RIGHT_STATUS_CODE RIGHT_STATUS_CODE
, RLOOK.MEANING RIGHT_STATUS
, PN_RIGHTS.RIGHT_REFERENCE RIGHT_REFERENCE
, PN_RIGHTS.START_DATE START_DATE
, PN_RIGHTS.EXPIRATION_DATE EXPIRATION_DATE
, PN_RIGHTS.RIGHT_COMMENTS RIGHT_COMMENTS
, PN_RIGHTS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PN_RIGHTS.ATTRIBUTE1 ATTRIBUTE1
, PN_RIGHTS.ATTRIBUTE2 ATTRIBUTE2
, PN_RIGHTS.ATTRIBUTE3 ATTRIBUTE3
, PN_RIGHTS.ATTRIBUTE4 ATTRIBUTE4
, PN_RIGHTS.ATTRIBUTE5 ATTRIBUTE5
, PN_RIGHTS.ATTRIBUTE6 ATTRIBUTE6
, PN_RIGHTS.ATTRIBUTE7 ATTRIBUTE7
, PN_RIGHTS.ATTRIBUTE8 ATTRIBUTE8
, PN_RIGHTS.ATTRIBUTE9 ATTRIBUTE9
, PN_RIGHTS.ATTRIBUTE10 ATTRIBUTE10
, PN_RIGHTS.ATTRIBUTE11 ATTRIBUTE11
, PN_RIGHTS.ATTRIBUTE12 ATTRIBUTE12
, PN_RIGHTS.ATTRIBUTE13 ATTRIBUTE13
, PN_RIGHTS.ATTRIBUTE14 ATTRIBUTE14
, PN_RIGHTS.ATTRIBUTE15 ATTRIBUTE15
, 'Y' CURRENT_FLAG
FROM PN_RIGHTS
, FND_LOOKUPS TLOOK
, FND_LOOKUPS RLOOK
WHERE TLOOK.LOOKUP_CODE = PN_RIGHTS.RIGHT_TYPE_CODE
AND TLOOK.LOOKUP_TYPE = 'PN_RIGHTS_TYPE'
AND RLOOK.LOOKUP_CODE = PN_RIGHTS.RIGHT_STATUS_CODE
AND RLOOK.LOOKUP_TYPE = 'PN_RIGHT_STATUS_TYPE' UNION ALL SELECT PN_RIGHTS_HISTORY.ROWID ROW_ID
, PN_RIGHTS_HISTORY.RIGHT_HISTORY_ID RIGHT_HISTORY_ID
, PN_RIGHTS_HISTORY.RIGHT_ID RIGHT_ID
, PN_RIGHTS_HISTORY.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PN_RIGHTS_HISTORY.LAST_UPDATED_BY LAST_UPDATED_BY
, PN_RIGHTS_HISTORY.CREATION_DATE CREATION_DATE
, PN_RIGHTS_HISTORY.CREATED_BY CREATED_BY
, PN_RIGHTS_HISTORY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PN_RIGHTS_HISTORY.LEASE_ID LEASE_ID
, PN_RIGHTS_HISTORY.LEASE_CHANGE_ID LEASE_CHANGE_D
, PN_RIGHTS_HISTORY.NEW_LEASE_CHANGE_ID NEW_LEASE_CHANGE_ID
, PN_RIGHTS_HISTORY.RIGHT_NUM RIGHT_NUM
, PN_RIGHTS_HISTORY.RIGHT_TYPE_CODE RIGHT_TYPE_CODE
, TLOOK.MEANING RIGHT_TYPE
, PN_RIGHTS_HISTORY.RIGHT_STATUS_CODE RIGHT_STATUS_CODE
, RLOOK.MEANING RIGHT_STATUS
, PN_RIGHTS_HISTORY.RIGHT_REFERENCE RIGHT_REFERENCE
, PN_RIGHTS_HISTORY.START_DATE START_DATE
, PN_RIGHTS_HISTORY.EXPIRATION_DATE EXPIRATION_DATE
, PN_RIGHTS_HISTORY.RIGHT_COMMENTS RIGHT_COMMENTS
, PN_RIGHTS_HISTORY.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PN_RIGHTS_HISTORY.ATTRIBUTE1 ATTRIBUTE1
, PN_RIGHTS_HISTORY.ATTRIBUTE2 ATTRIBUTE2
, PN_RIGHTS_HISTORY.ATTRIBUTE3 ATTRIBUTE3
, PN_RIGHTS_HISTORY.ATTRIBUTE4 ATTRIBUTE4
, PN_RIGHTS_HISTORY.ATTRIBUTE5 ATTRIBUTE5
, PN_RIGHTS_HISTORY.ATTRIBUTE6 ATTRIBUTE6
, PN_RIGHTS_HISTORY.ATTRIBUTE7 ATTRIBUTE7
, PN_RIGHTS_HISTORY.ATTRIBUTE8 ATTRIBUTE8
, PN_RIGHTS_HISTORY.ATTRIBUTE9 ATTRIBUTE9
, PN_RIGHTS_HISTORY.ATTRIBUTE10 ATTRIBUTE10
, PN_RIGHTS_HISTORY.ATTRIBUTE11 ATTRIBUTE11
, PN_RIGHTS_HISTORY.ATTRIBUTE12 ATTRIBUTE12
, PN_RIGHTS_HISTORY.ATTRIBUTE13 ATTRIBUTE13
, PN_RIGHTS_HISTORY.ATTRIBUTE14 ATTRIBUTE14
, PN_RIGHTS_HISTORY.ATTRIBUTE15 ATTRIBUTE15
, 'N' CURRENT_FLAG
FROM PN_RIGHTS_HISTORY
, FND_LOOKUPS TLOOK
, FND_LOOKUPS RLOOK
WHERE TLOOK.LOOKUP_CODE = PN_RIGHTS_HISTORY.RIGHT_TYPE_CODE
AND TLOOK.LOOKUP_TYPE = 'PN_RIGHT_TYPE'
AND RLOOK.LOOKUP_CODE = PN_RIGHTS_HISTORY.RIGHT_STATUS_CODE
AND RLOOK.LOOKUP_TYPE = 'PN_RIGHT_STATUS_TYPE'