Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View designed to retrieve all the visit history information on a person. |
Implementation/DBA Data: | Not implemented in this database |
SELECT VV.ROWID ROW_ID
, VV.PORT_OF_ENTRY
, L1.MEANING PORT_OF_ENTRY_M
, VV.CNTRY_ENTRY_FORM_NUM
, VV.VISA_ID
, PV.PERSON_ID
, PV.VISA_TYPE
, PV.VISA_NUMBER
, PV.VISA_ISSUE_DATE
, PV.VISA_EXPIRY_DATE
, PV.VISA_CATEGORY
, PV.VISA_ISSUING_POST
, PV.PASSPORT_ID
, VV.VISIT_START_DATE
, VV.VISIT_END_DATE
, VV.REMARKS
, VV.ATTRIBUTE_CATEGORY
, VV.ATTRIBUTE1
, VV.ATTRIBUTE2
, VV.ATTRIBUTE3
, VV.ATTRIBUTE4
, VV.ATTRIBUTE5
, VV.ATTRIBUTE6
, VV.ATTRIBUTE7
, VV.ATTRIBUTE8
, VV.ATTRIBUTE9
, VV.ATTRIBUTE10
, VV.ATTRIBUTE11
, VV.ATTRIBUTE12
, VV.ATTRIBUTE13
, VV.ATTRIBUTE14
, VV.ATTRIBUTE15
, VV.ATTRIBUTE16
, VV.ATTRIBUTE17
, VV.ATTRIBUTE18
, VV.ATTRIBUTE19
, VV.ATTRIBUTE20
, VV.CREATED_BY
, VV.CREATION_DATE
, VV.LAST_UPDATED_BY
, VV.LAST_UPDATE_DATE
, VV.LAST_UPDATE_LOGIN
FROM IGS_PE_VISIT_HISTRY VV
, IGS_PE_VISA PV
, IGS_LOOKUP_VALUES L1
WHERE PV.VISA_ID = VV.VISA_ID
AND VV.PORT_OF_ENTRY = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_US_PORT_OF_ENTRY'