VIEW: APPS.CSD_DC_FREQ_SUM_MV#

Source

View Text - Preformatted

SELECT A.ro_inventory_item_id RO_INVENTORY_ITEM_ID,
       A.TOTAL_RO_COUNT TOTAL_RO_COUNT,
       b.diagnostic_code_id,
       b.diagnostic_item_id,
       count(C.repair_line_id) DC_ONLY_RO_COUNT
  FROM CSD_RO_PER_ITEM_MV A,
       CSD_RO_DIAGNOSTIC_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.diagnostic_code_id,
          b.diagnostic_item_id

View Text - HTML Formatted

SELECT A.RO_INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, A.TOTAL_RO_COUNT TOTAL_RO_COUNT
, B.DIAGNOSTIC_CODE_ID
, B.DIAGNOSTIC_ITEM_ID
, COUNT(C.REPAIR_LINE_ID) DC_ONLY_RO_COUNT
FROM CSD_RO_PER_ITEM_MV A
, CSD_RO_DIAGNOSTIC_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.DIAGNOSTIC_CODE_ID
, B.DIAGNOSTIC_ITEM_ID