eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IBY_PAYMENTS_V

Source

View Text - Preformatted


SELECT pts.transactionid transactionid, pts.payeeid payeeid, pts.ecappid ecappid, pts.settledate scheddate, decode(pts.settledate,NULL,'ONLINE', 'OFFLINE') schedmode, pts.nlslang nlslang, pts.paymentmethodname paymentmethodname, pt.tangibleid tangibleid, pt.amount amount, pt.currencyNameCode currencyNameCode, pt.acctNo acctNo, pt.refInfo refInfo, pt.memo memo, pts. payerid, pts.payerinstrid, pts.instrtype , pts.org_id from iby_trxn_summaries_all pts, iby_tangible pt WHERE pts.mtangibleid = pt.mtangibleid and pts.reqtype IN ( 'ORAPMTREQ','ORAPMTCREDIT') and pts.reqdate = ( select max(reqdate) from iby_trxn_summaries_all pts1 where pts1.transactionid = pts.transactionId and reqtype IN ( 'ORAPMTREQ','ORAPMTCREDIT') )

View Text - HTML Formatted

SELECT PTS.TRANSACTIONID TRANSACTIONID
, PTS.PAYEEID PAYEEID
, PTS.ECAPPID ECAPPID
, PTS.SETTLEDATE SCHEDDATE
, DECODE(PTS.SETTLEDATE
, NULL
, 'ONLINE'
, 'OFFLINE') SCHEDMODE
, PTS.NLSLANG NLSLANG
, PTS.PAYMENTMETHODNAME PAYMENTMETHODNAME
, PT.TANGIBLEID TANGIBLEID
, PT.AMOUNT AMOUNT
, PT.CURRENCYNAMECODE CURRENCYNAMECODE
, PT.ACCTNO ACCTNO
, PT.REFINFO REFINFO
, PT.MEMO MEMO
, PTS. PAYERID
, PTS.PAYERINSTRID
, PTS.INSTRTYPE
, PTS.ORG_ID
FROM IBY_TRXN_SUMMARIES_ALL PTS
, IBY_TANGIBLE PT
WHERE PTS.MTANGIBLEID = PT.MTANGIBLEID
AND PTS.REQTYPE IN ( 'ORAPMTREQ'
, 'ORAPMTCREDIT')
AND PTS.REQDATE = ( SELECT MAX(REQDATE)
FROM IBY_TRXN_SUMMARIES_ALL PTS1
WHERE PTS1.TRANSACTIONID = PTS.TRANSACTIONID
AND REQTYPE IN ( 'ORAPMTREQ'
, 'ORAPMTCREDIT') )