Search Results visa_issuing_post_m

Overview

IGS_PE_VISA_V is a reporting view in the Oracle E-Business Suite IGS (Student System) product, which is documented as obsolete in ETRM. Its stated purpose is to retrieve all information on the visas that are stored for a person, consolidating visa detail held at the person level with related passport, lookup, territory, agent organization, and agent person descriptive data. The view is intended for read-only reporting and integration rather than transactional maintenance; the underlying visa records are maintained in IGS_PE_VISA, while the view supplies the denormalised presentation layer.

In the context of the user search term "visa_issuing_post", the view is significant because it exposes both the raw code column VISA_ISSUING_POST and a decoded meaning column, VISA_ISSUING_POST_M. That pairing allows reports to show a human-readable issuing post without a separate lookup join.

Underlying Base Objects

The view is defined over six objects using Oracle outer-join (+) syntax:

• IGS_PE_VISA PV — the driving table holding visa records per person.
• IGS_OR_INST_ORG_BASE_V OU — supplies agent organization details, joined on AGENT_ORG_UNIT_CD = OU.PARTY_NUMBER (+).
• IGS_PE_PERSON_BASE_V PE — supplies agent person details, joined on AGENT_PERSON_ID = PE.PERSON_ID (+).
• IGS_LOOKUP_VALUES L1 — decodes VISA_ISSUING_POST, joined on VISA_ISSUING_POST = L1.LOOKUP_CODE (+) with L1.LOOKUP_TYPE (+) = 'PE_US_VISA_ISSUE_LOC'.
• IGS_PE_PASSPORT PP — supplies passport number, joined on PASSPORT_ID = PP.PASSPORT_ID (+).
• FND_TERRITORIES_VL TER — supplies the issuing country short name, joined on VISA_ISSUING_COUNTRY = TER.TERRITORY_CODE (+).

All joins are outer joins, so visa rows are retained even where agent, passport, lookup, or territory detail is absent. No referenced base objects are separately documented for 12.2.2, and the object is not implemented in this database.

Key Columns

• VISA_ID, PERSON_ID — primary visa identifier and the person the visa belongs to.
• VISA_TYPE, VISA_NUMBER, VISA_CATEGORY — classification and identifying number of the visa.
• VISA_ISSUE_DATE, VISA_EXPIRY_DATE — validity dates used for status reporting.
• VISA_ISSUING_POST / VISA_ISSUING_POST_M — the issuing post code and its decoded lookup meaning.
• VISA_ISSUING_COUNTRY / VISA_ISSUING_COUNTRY_DESC — issuing country code and territory short name.
• PASSPORT_ID, PASSPORT_NUMBER — associated passport.
• AGENT_ORG_UNIT_CD, ORG_DESC, AGENT_OU_START_DATE, AGENT_CONTACT_NAME, AGENT_PERSON_ID, AGENT_PERSON_NUMBER, PERSON_FULL_NAME — agent organization and contact detail.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–20 — descriptive flexfield values.
• ROW_ID — ROWID of the IGS_PE_VISA row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns.

Common Use Cases and Queries

Typical scenarios include visa register reporting, expiry monitoring, and integration extracts to immigration or compliance systems. To list visas by issuing post for a person:

SELECT person_id, visa_number, visa_type,
       visa_issuing_post, visa_issuing_post_m,
       visa_issuing_country_desc
FROM   igs_pe_visa_v
WHERE  person_id = :p_person_id;

To find visas approaching expiry:

SELECT person_id, visa_number, visa_expiry_date
FROM   igs_pe_visa_v
WHERE  visa_expiry_date BETWEEN SYSDATE AND SYSDATE + 90;

Because IGS is obsolete, replacement solutions such as Oracle Campus Solutions should be used for new development; existing queries remain valid against historical data where the view is deployed.