Query SQL: | |
---|---|
SELECT A.POSITION_NBR, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFF_STATUS, A.DESCR, A.DESCRSHORT, A.ACTION, A.ACTION_REASON, TO_CHAR(A.ACTION_DT,'YYYY-MM-DD'), A.BUSINESS_UNIT, A.DEPTID, A.JOBCODE, A.POSN_STATUS, TO_CHAR(A.STATUS_DT,'YYYY-MM-DD'), A.BUDGETED_POSN, A.CONFIDENTIAL_POSN, A.KEY_POSITION, A.MAX_HEAD_COUNT, A.REPORTS_TO, A.FULL_PART_TIME, TO_CHAR(CAST((A.LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), A.LASTUPDOPRID, TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD') FROM PS_POSITION_DATA A, PS_POSTN_SRCH_QRY A1 WHERE A.POSITION_NBR = A1.POSITION_NBR AND A1.OPRID = '23420211' AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_POSITION_DATA A_ED WHERE A.POSITION_NBR = A_ED.POSITION_NBR AND A_ED.EFFDT <= SYSDATE) AND A.FULL_PART_TIME = 'F' AND A.EFF_STATUS = 'A' AND A.BUSINESS_UNIT = 'BAR01' ORDER BY 1 |