VIEW: APPS.IGSBV_VISAS

Source

View Text - Preformatted

SELECT HZP.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, PEV.AGENT_CONTACT_NAME, PEV.PERSON_ID, PEV.VISA_ID, PEV.PASSPORT_ID, PEV.AGENT_PERSON_ID, PEV.CREATION_DATE, PEV.CREATED_BY, PEV.LAST_UPDATED_BY, PEV.LAST_UPDATE_DATE FROM IGS_PE_VISA PEV, HZ_PARTIES HZP WHERE PEV.PERSON_ID=HZP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HZP.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
, PEV.AGENT_CONTACT_NAME
, PEV.PERSON_ID
, PEV.VISA_ID
, PEV.PASSPORT_ID
, PEV.AGENT_PERSON_ID
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE
FROM IGS_PE_VISA PEV
, HZ_PARTIES HZP
WHERE PEV.PERSON_ID=HZP.PARTY_ID WITH READ ONLY