View: OKL_BPD_INVEST_INV_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	View for investor agreement invoices lov.
Implementation/DBA Data:	APPS.OKL_BPD_INVEST_INV_LOV_UV

View Text

SELECT CUST_TRX.TRX_NUMBER INVOICE_NUMBER
, CUST.PARTY_NAME CUSTOMER_NAME
, SITE.NAME ADDRESS
, CUST_TRX.INVOICE_CURRENCY_CODE
, PAY_SCH.TRX_DATE INVOICE_DATE
, PAY_SCH.DUE_DATE
, PAY_SCH.AMOUNT_DUE_ORIGINAL
, PAY_SCH.AMOUNT_DUE_REMAINING
FROM RA_CUSTOMER_TRX CUST_TRX
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
, OKX_CUST_SITE_USES_V SITE
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
WHERE CUST_TRX.INTERFACE_HEADER_CONTEXT = 'OKL_INVESTOR'
AND CUST_TRX.BILL_TO_CUSTOMER_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND CUST_TRX.BILL_TO_SITE_USE_ID = SITE.ID1
AND CUST_TRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID ORDER BY CUST_TRX.TRX_NUMBER

Columns