View: OKL_AM_REMARKET_CUSTOMERS_UV

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

View Text

SELECT DISTINCT L.SOLD_TO_ORG_ID CUSTOMER_ID
, C.PARTY_NAME CUSTOMER_NAME
, C.PARTY_NUMBER CUSTOMER_NUMBER
FROM OE_ORDER_LINES_ALL L
, HZ_CUST_ACCOUNTS A
, HZ_PARTIES C
, OKL_ASSET_RETURNS_B AR
WHERE A.PARTY_ID = C.PARTY_ID
AND A.CUST_ACCOUNT_ID = L.SOLD_TO_ORG_ID
AND L.INVENTORY_ITEM_ID = AR.IMR_ID

Columns