Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_NOTE_HEADERS_V |
SELECT NOTES.ROWID ROW_ID
, NOTES.NOTE_HEADER_ID NOTE_HEADER_ID
, NOTES.LAST_UPDATED_BY LAST_UPDATED_BY
, NOTES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NOTES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FNR.USER_NAME UPDATED_BY_USER_NAME
, NOTES.CREATED_BY CREATED_BY
, NOTES.CREATION_DATE CREATION_DATE
, NOTES.NOTE_DATE NOTE_DATE
, NOTES.NOTE_TYPE_LOOKUP_CODE NOTE_TYPE_LOOKUP_CODE
, NOTES.LEASE_ID LEASE_ID
, LOOK.MEANING NOTE_TYPE
, NOTES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, NOTES.ATTRIBUTE1 ATTRIBUTE1
, NOTES.ATTRIBUTE2 ATTRIBUTE2
, NOTES.ATTRIBUTE3 ATTRIBUTE3
, NOTES.ATTRIBUTE4 ATTRIBUTE4
, NOTES.ATTRIBUTE5 ATTRIBUTE5
, NOTES.ATTRIBUTE6 ATTRIBUTE6
, NOTES.ATTRIBUTE7 ATTRIBUTE7
, NOTES.ATTRIBUTE8 ATTRIBUTE8
, NOTES.ATTRIBUTE9 ATTRIBUTE9
, NOTES.ATTRIBUTE10 ATTRIBUTE10
, NOTES.ATTRIBUTE11 ATTRIBUTE11
, NOTES.ATTRIBUTE12 ATTRIBUTE12
, NOTES.ATTRIBUTE13 ATTRIBUTE13
, NOTES.ATTRIBUTE14 ATTRIBUTE14
, NOTES.ATTRIBUTE15 ATTRIBUTE15
FROM FND_USER FNR
, FND_LOOKUPS LOOK
, PN_NOTE_HEADERS NOTES
WHERE LOOK.LOOKUP_TYPE = 'PN_NOTE_TYPE'
AND LOOK.LOOKUP_CODE = NOTES.NOTE_TYPE_LOOKUP_CODE
AND FNR.USER_ID = NOTES.LAST_UPDATED_BY