VIEW: APPS.OKL_BPD_INVEST_INV_LOV_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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