VIEW: APPS.PN_RIGHTS_HISTORY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'