[Home] [Help]
View: IBY_PAYMENTS_V
View Text
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') )
Columns
Name |
TRANSACTIONID |
PAYEEID |
ECAPPID |
SCHEDDATE |
SCHEDMODE |
NLSLANG |
PAYMENTMETHODNAME |
TANGIBLEID |
AMOUNT |
CURRENCYNAMECODE |
ACCTNO |
REFINFO |
MEMO |
PAYERID |
PAYERINSTRID |
INSTRTYPE |
ORG_ID |