HRT_NOTES_R10

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

NOTE_ID ENTERPRISE_ID NOTE_TYPE_CODE NOTE_TEXT OBJECT_TYPE OBJECT_ID AUTHOR_ID VISIBILITY_FLAG NOTE_LAST_UPDATE_DATE NOTE_CREATION_DATE OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATION_DATE

Query

SQL_Statement

select NOTE_ID , ENTERPRISE_ID , NOTE_TYPE_CODE , NOTE_TEXT , OBJECT_TYPE , decode (object_type, 'HRR_DASHBOARD',decode(receiver_id,null,OBJECT_ID,NVL((SELECT min(HD.dashboard_id) FROM hrr_dashboards HD WHERE HD.meeting_id = object_id and HD.person_id = receiver_id AND enterprise_id = HD.business_group_id),OBJECT_ID)),OBJECT_ID) as OBJECT_ID, AUTHOR_ID , VISIBILITY_FLAG , NOTE_LAST_UPDATE_DATE , NOTE_CREATION_DATE , OBJECT_VERSION_NUMBER , ATTRIBUTE_CATEGORY , ATTRIBUTE_NUMBER1 , ATTRIBUTE_NUMBER2 , ATTRIBUTE_NUMBER3 , ATTRIBUTE_NUMBER4 , ATTRIBUTE_NUMBER5 , ATTRIBUTE_NUMBER6 , ATTRIBUTE_NUMBER7 , ATTRIBUTE_NUMBER8 , ATTRIBUTE_NUMBER9 , ATTRIBUTE_NUMBER10 , ATTRIBUTE_NUMBER11 , ATTRIBUTE_NUMBER12 , ATTRIBUTE_NUMBER13 , ATTRIBUTE_NUMBER14 , ATTRIBUTE_NUMBER15 , ATTRIBUTE_DATE1 , ATTRIBUTE_DATE2 , ATTRIBUTE_DATE3 , ATTRIBUTE_DATE4 , ATTRIBUTE_DATE5 , ATTRIBUTE_DATE6 , ATTRIBUTE_DATE7 , ATTRIBUTE_DATE8 , ATTRIBUTE_DATE9 , ATTRIBUTE_DATE10 , ATTRIBUTE_DATE11 , ATTRIBUTE_DATE12 , ATTRIBUTE_DATE13 , ATTRIBUTE_DATE14 , ATTRIBUTE_DATE15 , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CREATED_BY , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CREATION_DATE from hrt_notes hn