View: OKL_BPD_INVEST_TRX_SUM_LN_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_INVEST_TRX_SUM_LN_UV

View Text

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

Columns