VIEW: APPS.CSD_SC_FREQ_SUM_MV#

Source

View Text - Preformatted

SELECT count(*) "count(*)",
       A.ro_inventory_item_id RO_INVENTORY_ITEM_ID,
       A.TOTAL_RO_COUNT TOTAL_RO_COUNT,
       b.service_code_id,
       b.service_item_id,
       count(C.repair_line_id) SC_ONLY_RO_COUNT
  FROM CSD_RO_PER_ITEM_MV A,
       CSD_RO_SERVICE_CODES B,
       CSD_REPAIR_ORDERS_F c       
 WHERE B.repair_line_id = C.repair_line_id 
   AND C.status = 'C' 
   AND A.ro_inventory_item_id = C.inventory_item_id
 GROUP BY A.ro_inventory_item_id,
          A.TOTAL_RO_COUNT,
          b.service_code_id,
          b.service_item_id
   

View Text - HTML Formatted

SELECT COUNT(*) "COUNT(*)"
, A.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, A.TOTAL_RO_COUNT TOTAL_RO_COUNT
, B.SERVICE_CODE_ID
, B.SERVICE_ITEM_ID
, COUNT(C.REPAIR_LINE_ID) SC_ONLY_RO_COUNT
FROM CSD_RO_PER_ITEM_MV A
, CSD_RO_SERVICE_CODES B
, CSD_REPAIR_ORDERS_F C
WHERE B.REPAIR_LINE_ID = C.REPAIR_LINE_ID
AND C.STATUS = 'C'
AND A.RO_INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID GROUP BY A.RO_INVENTORY_ITEM_ID
, A.TOTAL_RO_COUNT
, B.SERVICE_CODE_ID
, B.SERVICE_ITEM_ID