SELECT A.SRVC_IND_CD, A.SRVC_IND_REASON, B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.AUDIT_ACTN, A.PLACED_METHOD, A.AUDIT_OPRID, TO_CHAR(CAST((A.AUDIT_STAMP) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), TO_CHAR(SYSDATE,'YYYY-MM-DD') FROM PS_AUDIT_SRVC_IND A, PS_CU_BIO_VW B WHERE A.INSTITUTION = :1 AND A.SRVC_IND_CD = :2 AND B.EMPLID = A.EMPLID ORDER BY 3, 4, 5, 10 |