VIEW: APPS.IGS_PE_PERS_NOTE_V

Source

View Text - Preformatted

SELECT t.rowid row_id, t.person_id, t.pe_note_type, l1.meaning pe_note_type_desc, t.reference_number, t.created_by, t.creation_date, t.last_updated_by, t.last_update_date, t.last_update_login, t.start_date, t.end_date FROM igs_pe_pers_note t, igs_lookup_values l1 WHERE l1.lookup_code = t.pe_note_type AND l1.lookup_type = 'PE_NOTE_TYPE'

View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.PERSON_ID
, T.PE_NOTE_TYPE
, L1.MEANING PE_NOTE_TYPE_DESC
, T.REFERENCE_NUMBER
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.START_DATE
, T.END_DATE
FROM IGS_PE_PERS_NOTE T
, IGS_LOOKUP_VALUES L1
WHERE L1.LOOKUP_CODE = T.PE_NOTE_TYPE
AND L1.LOOKUP_TYPE = 'PE_NOTE_TYPE'