VIEW: APPS.IGS_PE_VISA_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)