VIEW: APPS.IEX_PAY_INVOICES_V

Source

View Text - Preformatted

SELECT psa.payment_schedule_id, psa.CUSTOMER_TRX_ID, psa.trx_number, psa.TRX_DATE, psa.TERMS_SEQUENCE_NUMBER, psa.due_date, psa.customer_id, psa.customer_site_use_id, psa.invoice_currency_code, psa.AMOUNT_DUE_REMAINING, psa.acctd_amount_due_remaining, psa.status, psa.class, del.delinquency_id, del.CAMPAIGN_SCHED_ID, del.status, lok.meaning FROM ar_payment_schedules psa, iex_delinquencies del, iex_lookups_v lok, RA_CUSTOMER_TRX trx WHERE psa.payment_schedule_id = del.payment_schedule_id(+) and psa.status = 'OP' and psa.AMOUNT_DUE_REMAINING > 0 and lok.lookup_type(+) = 'IEX_DELINQUENCY_STATUS' and lok.lookup_code(+) = del.status and psa.CUSTOMER_TRX_ID = trx.CUSTOMER_TRX_ID

View Text - HTML Formatted

SELECT PSA.PAYMENT_SCHEDULE_ID
, PSA.CUSTOMER_TRX_ID
, PSA.TRX_NUMBER
, PSA.TRX_DATE
, PSA.TERMS_SEQUENCE_NUMBER
, PSA.DUE_DATE
, PSA.CUSTOMER_ID
, PSA.CUSTOMER_SITE_USE_ID
, PSA.INVOICE_CURRENCY_CODE
, PSA.AMOUNT_DUE_REMAINING
, PSA.ACCTD_AMOUNT_DUE_REMAINING
, PSA.STATUS
, PSA.CLASS
, DEL.DELINQUENCY_ID
, DEL.CAMPAIGN_SCHED_ID
, DEL.STATUS
, LOK.MEANING
FROM AR_PAYMENT_SCHEDULES PSA
, IEX_DELINQUENCIES DEL
, IEX_LOOKUPS_V LOK
, RA_CUSTOMER_TRX TRX
WHERE PSA.PAYMENT_SCHEDULE_ID = DEL.PAYMENT_SCHEDULE_ID(+)
AND PSA.STATUS = 'OP'
AND PSA.AMOUNT_DUE_REMAINING > 0
AND LOK.LOOKUP_TYPE(+) = 'IEX_DELINQUENCY_STATUS'
AND LOK.LOOKUP_CODE(+) = DEL.STATUS
AND PSA.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID