Image of CU_BAR_HR_00011:

Query SQL:

 Query SQL:
 
SELECT A.POSITION_NBR, CASE A.EFF_STATUS WHEN 'I' THEN 'Open' END, 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, B.DESCR, A.JOBCODE, C.DESCR, 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'),B.SETID,B.DEPTID,TO_CHAR(B.EFFDT,'YYYY-MM-DD'),C.SETID,C.JOBCODE,TO_CHAR(C.EFFDT,'YYYY-MM-DD')
FROM PS_POSITION_DATA A, PS_POSTN_SRCH_QRY A1, PS_DEPT_TBL B, PS_JOBCODE_TBL C
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 = 'I'
AND A.BUSINESS_UNIT = 'BAR01'
AND B.DEPTID = A.DEPTID
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_DEPT_TBL B_ED
WHERE B.SETID = B_ED.SETID
AND B.DEPTID = B_ED.DEPTID
AND B_ED.EFFDT <= SYSDATE)
AND B.SETID = 'BAR01'
AND B.SETID_LOCATION = 'BAR01'
AND C.JOBCODE = A.JOBCODE
AND C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_JOBCODE_TBL C_ED
WHERE C.SETID = C_ED.SETID
AND C.JOBCODE = C_ED.JOBCODE
AND C_ED.EFFDT <= SYSDATE)
AND C.SETID = 'SHARE' )
ORDER BY 1
  • No labels