VIEW: APPS.IGS_PE_VISIT_HISTRY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'