View: IGS_SV_EDT_TRAVEL_V

Product:	IGS - Student System
Description:	View for fetching modified legal informations for Non-Immigrant
Implementation/DBA Data:	APPS.IGS_SV_EDT_TRAVEL_V

View Text

SELECT LGL.PERSON_ID
, LGL.BATCH_ID
, LGL.PSPRT_NUMBER
, LGL.PSPRT_ISSUING_CNTRY_CODE PSPT_ISSUING_CNTRY
, LGL.PSPRT_EXP_DATE PSPRT_EXPIRY_DATE
, LGL.VISA_NUMBER
, LGL.VISA_ISSUING_CNTRY_CODE VISA_ISSUING_CNTRY
, LGL.VISA_EXPIRATION_DATE VISA_EXPIRY_DATE
, LGL.I94_NUMBER ADMISSION_NUMBER
, LGL.PORT_OF_ENTRY
, LGL.DATE_OF_ENTRY
, LGL.REMARKS
, LGL.VISA_ISSUE_DATE
FROM IGS_SV_LEGAL_INFO LGL
, IGS_SV_BTCH_SUMMARY TRAVELSUMM
WHERE LGL.PERSON_ID = TRAVELSUMM.PERSON_ID
AND LGL.BATCH_ID = TRAVELSUMM.BATCH_ID
AND TRAVELSUMM.TAG_CODE = 'SV_LEGAL'
AND TRAVELSUMM.ADM_ACTION_CODE = 'SEND'

Columns