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

Source

View Text - Preformatted


SELECT inv_hdr.customer_trx_id invoice_id , inv_hdr.interface_header_attribute1 investor_agreement , acct.account_number investor_number , cust.party_name investor_name , inv_hdr.trx_number invoice_number , inv_hdr.invoice_currency_code , inv_hdr.trx_date invoice_date , pay_sched.due_date , rcpt_mthd.name payment_method , term.name payment_term , cust_site_uses.address1 , cust_site_uses.address2 , cust_site_uses.address3 , cust_site_uses.address4 , cust_site_uses.city , cust_site_uses.state , cust_site_uses.postal_code , cust_site_uses.country , okl_accounting_util.format_amount(nvl(pay_sched.amount_due_original, 0), inv_hdr.invoice_currency_code) invoice_amount , okl_accounting_util.format_amount(nvl(pay_sched.amount_due_remaining, 0), inv_hdr.invoice_currency_code) balance , inv_hdr.interface_header_attribute5 stream_type , inv_lines.line_number , inv_lines.line_type , okl_accounting_util.format_amount(NVL(inv_lines.extended_amount, 0), inv_hdr.invoice_currency_code) invoice_line_amount FROM RA_CUSTOMER_TRX INV_HDR,RA_CUSTOMER_TRX_LINES_ALL INV_LINES,HZ_CUST_ACCOUNTS ACCT,HZ_PARTIES CUST,AR_RECEIPT_METHODS RCPT_MTHD,AR_PAYMENT_SCHEDULES_ALL PAY_SCHED,RA_TERMS_VL TERM,OKX_CUST_SITE_USES_V CUST_SITE_USES WHERE inv_hdr.customer_trx_id = inv_lines.customer_trx_id and inv_hdr.interface_header_context = 'OKL_INVESTOR' and inv_hdr.bill_to_customer_id = acct.cust_account_id and acct.party_id = cust.party_id and inv_hdr.receipt_method_id = rcpt_mthd.receipt_method_id(+) and inv_hdr.bill_to_site_use_id = cust_site_uses.id1 and inv_hdr.customer_trx_id = pay_sched.customer_trx_id and inv_hdr.term_id = term.term_id ORDER BY inv_hdr.trx_number , inv_lines.line_number

View Text - HTML Formatted

SELECT INV_HDR.CUSTOMER_TRX_ID INVOICE_ID
, INV_HDR.INTERFACE_HEADER_ATTRIBUTE1 INVESTOR_AGREEMENT
, ACCT.ACCOUNT_NUMBER INVESTOR_NUMBER
, CUST.PARTY_NAME INVESTOR_NAME
, INV_HDR.TRX_NUMBER INVOICE_NUMBER
, INV_HDR.INVOICE_CURRENCY_CODE
, INV_HDR.TRX_DATE INVOICE_DATE
, PAY_SCHED.DUE_DATE
, RCPT_MTHD.NAME PAYMENT_METHOD
, TERM.NAME PAYMENT_TERM
, CUST_SITE_USES.ADDRESS1
, CUST_SITE_USES.ADDRESS2
, CUST_SITE_USES.ADDRESS3
, CUST_SITE_USES.ADDRESS4
, CUST_SITE_USES.CITY
, CUST_SITE_USES.STATE
, CUST_SITE_USES.POSTAL_CODE
, CUST_SITE_USES.COUNTRY
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(PAY_SCHED.AMOUNT_DUE_ORIGINAL
, 0)
, INV_HDR.INVOICE_CURRENCY_CODE) INVOICE_AMOUNT
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(PAY_SCHED.AMOUNT_DUE_REMAINING
, 0)
, INV_HDR.INVOICE_CURRENCY_CODE) BALANCE
, INV_HDR.INTERFACE_HEADER_ATTRIBUTE5 STREAM_TYPE
, INV_LINES.LINE_NUMBER
, INV_LINES.LINE_TYPE
, OKL_ACCOUNTING_UTIL.FORMAT_AMOUNT(NVL(INV_LINES.EXTENDED_AMOUNT
, 0)
, INV_HDR.INVOICE_CURRENCY_CODE) INVOICE_LINE_AMOUNT
FROM RA_CUSTOMER_TRX INV_HDR
, RA_CUSTOMER_TRX_LINES_ALL INV_LINES
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
, AR_RECEIPT_METHODS RCPT_MTHD
, AR_PAYMENT_SCHEDULES_ALL PAY_SCHED
, RA_TERMS_VL TERM
, OKX_CUST_SITE_USES_V CUST_SITE_USES
WHERE INV_HDR.CUSTOMER_TRX_ID = INV_LINES.CUSTOMER_TRX_ID
AND INV_HDR.INTERFACE_HEADER_CONTEXT = 'OKL_INVESTOR'
AND INV_HDR.BILL_TO_CUSTOMER_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND INV_HDR.RECEIPT_METHOD_ID = RCPT_MTHD.RECEIPT_METHOD_ID(+)
AND INV_HDR.BILL_TO_SITE_USE_ID = CUST_SITE_USES.ID1
AND INV_HDR.CUSTOMER_TRX_ID = PAY_SCHED.CUSTOMER_TRX_ID
AND INV_HDR.TERM_ID = TERM.TERM_ID ORDER BY INV_HDR.TRX_NUMBER
, INV_LINES.LINE_NUMBER