VIEW: APPS.OKL_AM_REMARKET_CUSTOMERS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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