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.IEX_INT_ACT_INV_PAYMENTS_V

Source

View Text - Preformatted


SELECT jia.interaction_id, jia.activity_id, jia.start_date_time, acr.cash_receipt_id, acr.receipt_number, acr.amount, acr.currency_code amount_cc, acr.receipt_date, acr.currency_code from iex_pay_receipt_xref iprx, iex_payments ip, jtf_ih_activities jia, ar_cash_receipts acr WHERE iprx.payment_id = ip.payment_id and jia.doc_id = ip.payment_id and acr.cash_receipt_id = iprx.cash_receipt_id order by receipt_number

View Text - HTML Formatted

SELECT JIA.INTERACTION_ID
, JIA.ACTIVITY_ID
, JIA.START_DATE_TIME
, ACR.CASH_RECEIPT_ID
, ACR.RECEIPT_NUMBER
, ACR.AMOUNT
, ACR.CURRENCY_CODE AMOUNT_CC
, ACR.RECEIPT_DATE
, ACR.CURRENCY_CODE
FROM IEX_PAY_RECEIPT_XREF IPRX
, IEX_PAYMENTS IP
, JTF_IH_ACTIVITIES JIA
, AR_CASH_RECEIPTS ACR
WHERE IPRX.PAYMENT_ID = IP.PAYMENT_ID
AND JIA.DOC_ID = IP.PAYMENT_ID
AND ACR.CASH_RECEIPT_ID = IPRX.CASH_RECEIPT_ID ORDER BY RECEIPT_NUMBER