View: AR_RDR_ITEMS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_RDR_ITEMS_V

View Text

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)

Columns