VIEW: APPS.IEX_PAYMENT_REPORTS_V

Source

View Text - Preformatted

SELECT l.meaning payment_method , p.ipayment_status payment_status , p.campaign_sched_id campaign_schedule_id , c.source_code , p.creation_date payment_date , r.amount , p.payment_id , d.delinquency_id , p.resource_id , j.source_name collector , d.cust_account_id , d.transaction_id invoice_id , d.payment_schedule_id , s.class , s.amount_due_remaining , s.amount_due_original , r.currency_code , l.lookup_code payment_method_lookup_code from iex_delinquencies d , iex_payments p , ar_payment_schedules_all s , iex_del_pay_xref xdp , ams_source_codes c , jtf_rs_resource_extns j , iex_pay_receipt_xref xpr , ar_cash_receipts_all r , iex_lookups_v l WHERE xdp.payment_id = p.payment_id and xdp.DELINQUENCY_ID = d.DELINQUENCY_ID and d.payment_schedule_id = s.payment_schedule_id and c.source_code_id(+) = p.campaign_sched_id and p.resource_id = j.resource_id(+) and p.payment_id = xpr.payment_id and r.cash_receipt_id = xpr.cash_receipt_id and l.lookup_type = 'IEX_PAYMENT_TYPES' and p.payment_method = l.lookup_code

View Text - HTML Formatted

SELECT L.MEANING PAYMENT_METHOD
, P.IPAYMENT_STATUS PAYMENT_STATUS
, P.CAMPAIGN_SCHED_ID CAMPAIGN_SCHEDULE_ID
, C.SOURCE_CODE
, P.CREATION_DATE PAYMENT_DATE
, R.AMOUNT
, P.PAYMENT_ID
, D.DELINQUENCY_ID
, P.RESOURCE_ID
, J.SOURCE_NAME COLLECTOR
, D.CUST_ACCOUNT_ID
, D.TRANSACTION_ID INVOICE_ID
, D.PAYMENT_SCHEDULE_ID
, S.CLASS
, S.AMOUNT_DUE_REMAINING
, S.AMOUNT_DUE_ORIGINAL
, R.CURRENCY_CODE
, L.LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
FROM IEX_DELINQUENCIES D
, IEX_PAYMENTS P
, AR_PAYMENT_SCHEDULES_ALL S
, IEX_DEL_PAY_XREF XDP
, AMS_SOURCE_CODES C
, JTF_RS_RESOURCE_EXTNS J
, IEX_PAY_RECEIPT_XREF XPR
, AR_CASH_RECEIPTS_ALL R
, IEX_LOOKUPS_V L
WHERE XDP.PAYMENT_ID = P.PAYMENT_ID
AND XDP.DELINQUENCY_ID = D.DELINQUENCY_ID
AND D.PAYMENT_SCHEDULE_ID = S.PAYMENT_SCHEDULE_ID
AND C.SOURCE_CODE_ID(+) = P.CAMPAIGN_SCHED_ID
AND P.RESOURCE_ID = J.RESOURCE_ID(+)
AND P.PAYMENT_ID = XPR.PAYMENT_ID
AND R.CASH_RECEIPT_ID = XPR.CASH_RECEIPT_ID
AND L.LOOKUP_TYPE = 'IEX_PAYMENT_TYPES'
AND P.PAYMENT_METHOD = L.LOOKUP_CODE