VIEW: APPS.AR_RDR_ITEMS_V

Source

View Text - Preformatted

SELECT INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS, DESCRIPTION, ORGANIZATION_ID from MTL_SYSTEM_ITEMS_VL WHERE (INVENTORY_ITEM_ID,ROWID) IN (select SI.INVENTORY_ITEM_ID,min(SI.rowid) from MTL_SYSTEM_ITEMS_VL SI, HR_ALL_ORGANIZATION_UNITS OU WHERE SI.ORGANIZATION_ID = OU.ORGANIZATION_ID group by INVENTORY_ITEM_ID)

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID
, CONCATENATED_SEGMENTS
, DESCRIPTION
, ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_VL
WHERE (INVENTORY_ITEM_ID
, ROWID) IN (SELECT SI.INVENTORY_ITEM_ID
, MIN(SI.ROWID)
FROM MTL_SYSTEM_ITEMS_VL SI
, HR_ALL_ORGANIZATION_UNITS OU
WHERE SI.ORGANIZATION_ID = OU.ORGANIZATION_ID GROUP BY INVENTORY_ITEM_ID)