VIEW: APPS.OKI_TOP_LINES_V

Source

View Text - Preformatted

SELECT name FROM OKX_SYSTEM_ITEMS_V ITM WHERE (id1, id2) in (select distinct item_id, inventory_organization_id from oki_sold_itm_lines)

View Text - HTML Formatted

SELECT NAME
FROM OKX_SYSTEM_ITEMS_V ITM
WHERE (ID1
, ID2) IN (SELECT DISTINCT ITEM_ID
, INVENTORY_ORGANIZATION_ID
FROM OKI_SOLD_ITM_LINES)