SELECT '_LA:PVH.PORT_OF_ENTRY:IGS_LOOKUP_VALUES:PE_US_PORT_OF_ENTRY:MEANING', PVH.CNTRY_ENTRY_FORM_NUM, PVH.VISIT_START_DATE, PVH.VISIT_END_DATE, PVH.REMARKS, HZP.PARTY_NUMBER, PEV.VISA_TYPE, PEV.VISA_ISSUE_DATE, PVH.VISA_ID, PVH.CREATION_DATE, PVH.CREATED_BY, PVH.LAST_UPDATED_BY, PVH.LAST_UPDATE_DATE FROM IGS_PE_VISIT_HISTRY PVH, IGS_PE_VISA PEV, HZ_PARTIES HZP WHERE PVH.VISA_ID=PEV.VISA_ID AND HZP.PARTY_ID=PEV.PERSON_ID WITH READ ONLY
SELECT '_LA:PVH.PORT_OF_ENTRY:IGS_LOOKUP_VALUES:PE_US_PORT_OF_ENTRY:MEANING'
, PVH.CNTRY_ENTRY_FORM_NUM
, PVH.VISIT_START_DATE
, PVH.VISIT_END_DATE
, PVH.REMARKS
, HZP.PARTY_NUMBER
, PEV.VISA_TYPE
, PEV.VISA_ISSUE_DATE
, PVH.VISA_ID
, PVH.CREATION_DATE
, PVH.CREATED_BY
, PVH.LAST_UPDATED_BY
, PVH.LAST_UPDATE_DATE
FROM IGS_PE_VISIT_HISTRY PVH
, IGS_PE_VISA PEV
, HZ_PARTIES HZP
WHERE PVH.VISA_ID=PEV.VISA_ID
AND HZP.PARTY_ID=PEV.PERSON_ID WITH READ ONLY
|
|
|