SELECT DISTINCT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.ACAD_CAREER, A.STRM, A.UNT_TAKEN_PRGRSS, B.PHONE, B.EMAIL_ADDR, C.COUNTRY, C.VISA_PERMIT_TYPE, C.VISA_WRKPMT_STATUS, TO_CHAR(C.STATUS_DT,'YYYY-MM-DD'), TO_CHAR(C.DT_ISSUED,'YYYY-MM-DD'), TO_CHAR(C.EXPIRATN_DT,'YYYY-MM-DD'), C.VISA_WRKPMT_NBR, TO_CHAR(SYSDATE,'YYYY-MM-DD') FROM PS_STDNT_CAR_TERM A, PS_CU_BIO_VW B, PS_SCC_VISA_P_QVW C WHERE ( A.INSTITUTION = :1 AND A.STRM = :2 AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND C.EFFDT = (SELECT max ( D.EFFDT) FROM PS_SCC_VISA_P_QVW D WHERE ( D.EMPLID = C.EMPLID AND D.DEPENDENT_ID = C.DEPENDENT_ID AND D.COUNTRY = C.COUNTRY )) AND C.VISA_PERMIT_TYPE IN ('J-1','F-1') ) ORDER BY 1, 2, 3 |
...