Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about a person's visa details. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZP1.PARTY_NUMBER
, PEV.VISA_TYPE
, PEV.VISA_ISSUE_DATE
, PEV.VISA_NUMBER
, PEV.VISA_CATEGORY
, '_LA:PEV.VISA_TYPE:HR_LOOKUPS:PER_US_VISA_TYPES:MEANING'
, '_LA:PEV.VISA_ISSUING_POST:IGS_LOOKUP_VALUES:PE_US_VISA_ISSUE_LOC:MEANING'
, '_LA:PEV.VISA_ISSUING_COUNTRY:HR_LOOKUPS:PER_US_COUNTRY_CODE:MEANING'
, PEV.VISA_EXPIRY_DATE
, PEV.AGENT_ORG_UNIT_CD
, '_DF:IGS:IGS_PE_INTL_VISA_FLEX:PEV'
, HZP2.PARTY_NAME
, HZP3.PARTY_NUMBER
, PEV.AGENT_CONTACT_NAME
, PEP.PASSPORT_NUMBER
, '_LA:PEP.PASSPORT_CNTRY_CODE:HR_LOOKUPS:PER_US_COUNTRY_CODE:MEANING'
, PEV.PERSON_ID
, PEV.VISA_ID
, PEV.AGENT_PERSON_ID
, PEV.PASSPORT_ID
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE
FROM IGS_PE_VISA PEV
, HZ_PARTIES HZP1
, HZ_PARTIES HZP2
, HZ_PARTIES HZP3
, IGS_PE_PASSPORT PEP
WHERE PEV.PERSON_ID=HZP1.PARTY_ID
AND PEV.AGENT_ORG_UNIT_CD=HZP2.PARTY_NUMBER(+)
AND PEV.AGENT_PERSON_ID=HZP3.PARTY_ID(+)
AND PEV.PASSPORT_ID=PEP.PASSPORT_ID(+) WITH READ ONLY