VIEW: APPS.CSD_RO_PER_ITEM_MV#

Source

View Text - Preformatted

SELECT count(*) TOTAL_RO_COUNT, 
       RO.inventory_item_id RO_INVENTORY_ITEM_ID
  FROM csd_repair_orders_f RO
 WHERE RO.status = 'C'
 GROUP BY RO.inventory_item_id

View Text - HTML Formatted

SELECT COUNT(*) TOTAL_RO_COUNT
, RO.INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
FROM CSD_REPAIR_ORDERS_F RO
WHERE RO.STATUS = 'C' GROUP BY RO.INVENTORY_ITEM_ID