[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view is designed to retrieve all information on the visas that are stored for a person. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PV.ROWID ROW_ID
, PV.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
, L1.MEANING VISA_ISSUING_POST_M
, PV.VISA_ISSUING_COUNTRY
, TER.TERRITORY_SHORT_NAME MEANING
, PV.PASSPORT_ID
, PP.PASSPORT_NUMBER PASSPORT_NUMBER
, PV.AGENT_ORG_UNIT_CD
, OU.PARTY_NAME ORG_DESC
, OU.START_DT AGENT_OU_START_DATE
, PV.AGENT_CONTACT_NAME
, PV.AGENT_PERSON_ID
, PE.PERSON_NUMBER AGENT_PERSON_NUMBER
, PE.FULL_NAME PERSON_FULL_NAME
, PV.ATTRIBUTE_CATEGORY
, PV.ATTRIBUTE1
, PV.ATTRIBUTE2
, PV.ATTRIBUTE3
, PV.ATTRIBUTE4
, PV.ATTRIBUTE5
, PV.ATTRIBUTE6
, PV.ATTRIBUTE7
, PV.ATTRIBUTE8
, PV.ATTRIBUTE9
, PV.ATTRIBUTE10
, PV.ATTRIBUTE11
, PV.ATTRIBUTE12
, PV.ATTRIBUTE13
, PV.ATTRIBUTE14
, PV.ATTRIBUTE15
, PV.ATTRIBUTE16
, PV.ATTRIBUTE17
, PV.ATTRIBUTE18
, PV.ATTRIBUTE19
, PV.ATTRIBUTE20
, PV.CREATED_BY
, PV.CREATION_DATE
, PV.LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN
FROM IGS_PE_VISA PV
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PE_PERSON_BASE_V PE
, IGS_LOOKUP_VALUES L1
, IGS_PE_PASSPORT PP
, FND_TERRITORIES_VL TER
WHERE PV.AGENT_ORG_UNIT_CD = OU.PARTY_NUMBER (+)
AND PV.AGENT_PERSON_ID = PE.PERSON_ID (+)
AND PV. VISA_ISSUING_POST = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_US_VISA_ISSUE_LOC'
AND PV.PASSPORT_ID = PP.PASSPORT_ID(+)
AND PV.VISA_ISSUING_COUNTRY = TER.TERRITORY_CODE(+)