|
SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , b.TXN_CURRENCY_CD , C.OPRID , SUM(PYMNT_GROSS_AMT) ,MAX(B.INVOICE_DT) FROM ps_pymnt_vchr_xref a , PS_VOUCHER b , PS_SEC_BU_OPR c , PS_EM_ES_VCHR_VW vchr WHERE a.business_unit = b.business_unit AND a.business_unit = c.business_unit AND a.voucher_id = b.voucher_id AND b.ENTRY_STATUS NOT IN ('R', 'X') AND B.CLOSE_STATUS <> 'C' AND a.PYMNT_HOLD = 'Y' AND a.PYMNT_SELCT_STATUS <> 'P' AND a.PYMNT_SELCT_STATUS <> 'X' AND b.business_unit = vchr.business_unit AND b.voucher_id = vchr.voucher_id GROUP BY a.BUSINESS_UNIT, A.VOUCHER_ID,B.TXN_CURRENCY_CD,C.OPRID
|