View: OKL_BPD_INV_SRCH_V

Product:	OKL - Lease and Finance Management
Description:	View for Search page Details -- Context region.
Implementation/DBA Data:	APPS.OKL_BPD_INV_SRCH_V

View Text

SELECT ARV.IXX_ID IXX_ID
, NULL CNR_ID
, ARV.DUE_DATE DUE_DATE
, PY.PARTY_NAME PARTY_NAME
, ARV.CURRENCY_CODE CURRENCY_CODE
, ARV.TRX_NUMBER CONSOLIDATED_INVOICE_NUMBER
, ARV.INVOICE_ID RECEIVABLES_INVOICE_ID
, ARV.DATE_CONSOLIDATED DATE_CONSOLIDATED
, ARV.RECEIPT_METHOD_ID IRM_ID
, ARM.NAME RECEIPT_METHOD_NAME
, /*--TO_NUMBER(ARV.INF_ID) INF_ID
, */ INF.ID INF_ID
, NVL(INF.NAME
, 'NONE') NAME
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.POSTAL_CODE
, NULL
, ADDR.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) ADDRESS
, ARV.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, ARV.BALANCE BALANCE
, ARV.ORG_ID ORG_ID
FROM OKL_BPD_AR_INVOICES_V ARV
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_INVOICE_FORMATS_V INF
, AR_RECEIPT_METHODS ARM
, AR_ADDRESSES_V ADDR
WHERE ARV.PAY_SCH_CLASS IN ('INV'
, 'CM')
AND CA.CUST_ACCOUNT_ID = ARV.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND ARV.INF_NAME = INF.NAME(+)
AND ARV.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID(+)
AND ARV.CUSTOMER_ID = CA.CUST_ACCOUNT_ID
AND ARV.BILL_TO_SITE_USE_ID= ADDR.ADDRESS_ID (+)

Columns