View: OKL_BPD_CUST_LIST_UV

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

View Text

SELECT DISTINCT CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SUBSTRB (PY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CSU.CUST_ACCT_SITE_ID BILL_TO_SITE_USE_ID
, KHR.CUST_ACCT_ID CUSTOMER_ACCT_ID
FROM OKX_CUST_SITE_USES_V CSU
, OKC_K_HEADERS_B KHR
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
WHERE KHR.CUST_ACCT_ID = CA.CUST_ACCOUNT_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND CSU.ID1 = KHR.BILL_TO_SITE_USE_ID

Columns