SELECT H.TRANSACTION_NBR 流程单号,
H.TITLE 流程名称,
C.EOAWDTTM_MODIFIED 流程提交时间,
L.EMPLID 离职员工ID,
L.NAME 离职员工姓名,
S.EOAWSTEP_STATUS 节点状态,
UL.DESCR 审批节点,
US.OPRID 审批人,
US.EOAWDTTM_MODIFIED 审批时间
FROM PS_DC_AWE_LZBL_HDR L,
PS_GPS_AWE_HDR H,
PS_GPS_AWE_XREF X,
PS_GPS_AWE_STA C,
PS_EOAW_STEPINST S
LEFT JOIN PS_EOAW_USERINST US
ON S.EOAWSTEP_INSTANCE = US.EOAWSTEP_INSTANCE, PS_EOAW_STEP SD,
PS_EOAWUSER_LIST UL
WHERE L.TRANSACTION_NBR = H.TRANSACTION_NBR
AND H.TRANSACTION_NBR = X.TRANSACTION_NBR
AND X.EOAWTHREAD_ID =
(SELECT MAX(EOAWTHREAD_ID)
FROM PS_GPS_AWE_XREF X1
WHERE X1.TRANSACTION_NBR = X.TRANSACTION_NBR)
AND X.EOAWPRCS_ID = 'DC_AWE_LZBL'
AND X.TRANSACTION_NBR = 6580
AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID
AND X.TRANSACTION_NBR = C.TRANSACTION_NBR
AND C.HR_WF_ACTION = 'SUB'
AND S.EOAWPRCS_ID = SD.EOAWPRCS_ID
AND S.EOAWDEFN_ID = SD.EOAWDEFN_ID
AND S.EFFDT = SD.EFFDT
AND S.EOAWSTAGE_NBR = SD.EOAWSTAGE_NBR
AND S.EOAWPATH_ID = SD.EOAWPATH_ID
AND FLOOR(S.EOAWSTEP_NBR) = SD.EOAWSTEP_NBR
AND SD.EOAWAPPROVER_LIST = UL.EOAWUSER_LIST_ID
AND X.EOAWTHREAD_STATUS <> 'T'
AND S.EOAWSTEP_STATUS NOT IN ('K', 'L', 'G', 'N')
AND US.EOAWSTEP_STATUS NOT IN('G')
ORDER BY S.EOAWPRCS_ID,S.EOAWDEFN_ID,S.EFFDT,S.EOAWSTAGE_NBR,S.EOAWPATH_ID,S.EOAWSTEP_INSTANCE ASC, L.TRANSACTION_NBR