SELECT B.NAME, A.CASHIER, A.SF_REGISTER, A.VOID_REASON_CD, A.RECEIPT_NBR, TO_CHAR(A.CURRENT_BUS_DT,'YYYY-MM-DD'), A.TOTAL_AMOUNT_SF, A.SSF_APPR_STATUS, TO_CHAR(SYSDATE,'YYYY-MM-DD')
FROM PS_CSH_OFF_RECEIPT A, PS_NAMES B, PS_PERALL_SEC_QRY B1
WHERE B.EMPLID = B1.EMPLID
AND B1.OPRID = '11002650'
AND ( A.BUSINESS_UNIT = :1
AND A.TRANS_DT BETWEEN TO_DATE(:2,'YYYY-MM-DD') AND TO_DATE(:3,'YYYY-MM-DD')
AND A.VOID_REASON_CD <> ' '
AND B.EMPLID = A.CASHIER
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_NAMES B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.NAME_TYPE = B_ED.NAME_TYPE
AND B_ED.EFFDT <= SYSDATE)
AND B.NAME_TYPE = 'PRI' )
ORDER BY 1
  • No labels