View: OKL_CUSTOMER_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for customer lov on creditline contract page
Implementation/DBA Data:	APPS.OKL_CUSTOMER_UV

View Text

SELECT CUSTOMER.ID1 CUSTOMER_ID1
, CUSTOMER.ID2 CUSTOMER_ID2
, CUSTOMER.DESCRIPTION CUSTOMER_NUMBER
, CUSTOMER.NAME CUSTOMER_NAME
, RS.JTOT_OBJECT_CODE CUSTOMER_JTOT_OBJECT_CODE
FROM OKX_PARTIES_V CUSTOMER
, OKC_ROLE_SOURCES RS
WHERE RS.RLE_CODE = 'LESSEE'
AND RS.BUY_OR_SELL = 'S'
AND TRUNC(RS.START_DATE) <= TRUNC(SYSDATE)
AND TRUNC(NVL(RS.END_DATE
, SYSDATE)) >= TRUNC(SYSDATE)

Columns