VIEW: APPS.CSD_WIP_MTL_USED_MV#

Source

View Text - Preformatted

SELECT count(*) "count(*)",
       RO.inventory_item_id RO_INVENTORY_ITEM_ID,
       count(RO.repair_line_id) PART_ONLY_RO_COUNT,
       sum(RO.primary_quantity) PART_ONLY_RO_QUANTITY,
       count(RO.primary_quantity) PART_ONLY_RO_QUANTITY_CNT,
       MTLS.inventory_item_id PART_INVENTORY_ITEM_ID,
       sum(MTLS.primary_quantity) TOTAL_PART_QUANTITY,
       count(MTLS.primary_quantity) TOTAL_PART_QUANTITY_CNT,
       MTLS.primary_uom_code PART_PRIMARY_UOM_CODE
  FROM CSD_REPAIR_ORDERS_F RO, 
       CSD_MTL_CONSUMED_F MTLS
 WHERE RO.status = 'C'
   AND MTLS.repair_line_id = Ro.repair_line_id
 GROUP BY RO.inventory_item_id,
          MTLS.inventory_item_id,
          MTLS.primary_uom_code
   

View Text - HTML Formatted

SELECT COUNT(*) "COUNT(*)"
, RO.INVENTORY_ITEM_ID RO_INVENTORY_ITEM_ID
, COUNT(RO.REPAIR_LINE_ID) PART_ONLY_RO_COUNT
, SUM(RO.PRIMARY_QUANTITY) PART_ONLY_RO_QUANTITY
, COUNT(RO.PRIMARY_QUANTITY) PART_ONLY_RO_QUANTITY_CNT
, MTLS.INVENTORY_ITEM_ID PART_INVENTORY_ITEM_ID
, SUM(MTLS.PRIMARY_QUANTITY) TOTAL_PART_QUANTITY
, COUNT(MTLS.PRIMARY_QUANTITY) TOTAL_PART_QUANTITY_CNT
, MTLS.PRIMARY_UOM_CODE PART_PRIMARY_UOM_CODE
FROM CSD_REPAIR_ORDERS_F RO
, CSD_MTL_CONSUMED_F MTLS
WHERE RO.STATUS = 'C'
AND MTLS.REPAIR_LINE_ID = RO.REPAIR_LINE_ID GROUP BY RO.INVENTORY_ITEM_ID
, MTLS.INVENTORY_ITEM_ID
, MTLS.PRIMARY_UOM_CODE