MATERIALIZED VIEW: APPS.OPI_PROD_SCR_MV

Source

Select /* 12.0: bug#4526784 */
    organization_id,
    source,
    inventory_item_id,
    transaction_date,
    sum (nvl (completion_quantity, 0) +  nvl (scrap_quantity, 0))
            production_qty,
    count (nvl (completion_quantity, 0) + nvl (scrap_quantity, 0))
            production_qty_cnt,
    sum (nvl (completion_value_b, 0) + nvl (scrap_value_b, 0))
            production_val_b,
    count (nvl (completion_value_b, 0) + nvl (scrap_value_b, 0))
            production_val_b_cnt,
    sum (nvl (completion_value_g, 0) + nvl (scrap_value_g, 0))
            production_val_g,
    count (nvl (completion_value_g, 0) + nvl (scrap_value_g, 0))
            production_val_g_cnt,
    sum (nvl (scrap_quantity, 0))   scrap_qty,
    count (nvl (scrap_quantity, 0)) scrap_qty_cnt,
    sum (nvl (scrap_value_b, 0))    scrap_val_b,
    count (nvl (scrap_value_b, 0))  scrap_val_b_cnt,
    sum (nvl (scrap_value_g, 0))    scrap_val_g,
    count (nvl (scrap_value_g, 0))  scrap_val_g_cnt,
    uom_code,
    sum (nvl (completion_value_sg, 0) + nvl (scrap_value_sg, 0)) production_val_sg,
    count (nvl (completion_value_sg, 0) + nvl (scrap_value_sg, 0)) production_val_sg_cnt,
    sum (nvl (scrap_value_sg, 0)) scrap_val_sg,
    count (nvl (scrap_value_sg, 0)) scrap_val_sg_cnt,
    job_id,
    job_type,
    count (*) cnt
FROM
    opi_comp_scr_mv
GROUP BY
    organization_id,
    source,
    inventory_item_id,
    transaction_date,
    uom_code,
    job_id,
    job_type