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.

[Home] [Help]

View: IBY_PAYMENTS_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.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