SELECT REMTXN.M2ICUSTID,REMTXN.TRACKNO,REMTXN.ACTDATE,REMTXN.M2IPRODID,REMTXN.REMITAMOUNT
,SMST.VALUE,CMST.EMAILID,CMST.GENDER,MCRNC.CURRDESC
FROM M2IREMITTXN REMTXN,
M2IPRODUCTMASTER MPRDMST,
STATUSMASTER STA,
SYSTEMMASTER SMST,
M2ICUSTMASTER CMST,
IRPSMSTCURRENCY MCRNC
WHERE REMTXN.STATID =STA.STATID
AND MPRDMST.INSTTYPE IN(1,2)
AND MPRDMST.M2IPRODID = REMTXN.M2IPRODID AND
STA.STATCODE = 'ONREQUEST' AND
REMTXN.MATCHED_FLAG = 'N'
AND SMST.SYSCODE='TXNREMDAY'
AND CMST.M2ICUSTID = REMTXN.M2ICUSTID
AND REMTXN.CURRENCYID = MCRNC.CURRENCYID
I need to fire this Sql on Hebernate (HQL)
|