VIEW: APPS.IGSFV_VISAS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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