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_CNSLD_PAYMENTS_V

Source

View Text - Preformatted


SELECT jia.interaction_id, jia.activity_id, jia.start_date_time, obphv.consolidated_invoice_number, obphv.stream_id, obphv.stream_name, obphv.due_date, obphv.amount_due_original, obphv.currency_code, obphv.apply_date, obphv.amount_applied, obphv.currency_code, obphv.amount_due_remaining, obphv.currency_code from iex_pay_okl_xref ipox, iex_payments ip, jtf_ih_activities jia, okl_bpd_payment_history_v obphv WHERE ipox.payment_id = ip.payment_id and jia.doc_id = ip.payment_id and ipox.cnsld_invoice_id = obphv.consolidated_invoice_id and obphv.reference_number = 'IEX_'||ipox.payment_id order by stream_name, apply_date

View Text - HTML Formatted

SELECT JIA.INTERACTION_ID
, JIA.ACTIVITY_ID
, JIA.START_DATE_TIME
, OBPHV.CONSOLIDATED_INVOICE_NUMBER
, OBPHV.STREAM_ID
, OBPHV.STREAM_NAME
, OBPHV.DUE_DATE
, OBPHV.AMOUNT_DUE_ORIGINAL
, OBPHV.CURRENCY_CODE
, OBPHV.APPLY_DATE
, OBPHV.AMOUNT_APPLIED
, OBPHV.CURRENCY_CODE
, OBPHV.AMOUNT_DUE_REMAINING
, OBPHV.CURRENCY_CODE
FROM IEX_PAY_OKL_XREF IPOX
, IEX_PAYMENTS IP
, JTF_IH_ACTIVITIES JIA
, OKL_BPD_PAYMENT_HISTORY_V OBPHV
WHERE IPOX.PAYMENT_ID = IP.PAYMENT_ID
AND JIA.DOC_ID = IP.PAYMENT_ID
AND IPOX.CNSLD_INVOICE_ID = OBPHV.CONSOLIDATED_INVOICE_ID
AND OBPHV.REFERENCE_NUMBER = 'IEX_'||IPOX.PAYMENT_ID ORDER BY STREAM_NAME
, APPLY_DATE