IBY_PAYMENTS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
TRANSACTIONID PAYEEID ECAPPID SCHEDDATE SCHEDMODE NLSLANG PAYMENTMETHODNAME TANGIBLEID AMOUNT CURRENCYNAMECODE ACCTNO REFINFO MEMO PAYERID PAYERINSTRID INSTRTYPE ORG_ID

Name

TRANSACTIONID

PAYEEID

ECAPPID

SCHEDDATE

SCHEDMODE

NLSLANG

PAYMENTMETHODNAME

TANGIBLEID

AMOUNT

CURRENCYNAMECODE

ACCTNO

REFINFO

MEMO

PAYERID

PAYERINSTRID

INSTRTYPE

ORG_ID

Query

SQL_Statement
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') )

SQL_Statement

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') )