MATERIALIZED VIEW: APPS.OPI_COMP_SCR_MV

Source

Select /* 12.0: bug#4526784 */
        mult.rowid row_id,
        f.organization_id,
        f.inventory_item_id,
        f.transaction_date,
        f.job_id,
        f.job_type,
        f.source,
        0 completion_quantity,
        0 completion_value_b,
        0 completion_value_g,
        0 completion_value_sg,
        sum(f.scrap_quantity)   scrap_quantity,
        count(scrap_quantity)   scrap_quantity_cnt,
        sum(f.scrap_value_b)    scrap_value_b,
        count(scrap_value_b)      scrap_value_b_cnt,
        sum(f.scrap_value_b * f.conversion_rate)        scrap_value_g,
        count(f.scrap_value_b * f.conversion_rate)      scrap_value_g_cnt,
        sum(f.scrap_value_b * f.sec_conversion_rate)    scrap_value_sg,
        count(f.scrap_value_b * f.sec_conversion_rate)  scrap_value_sg_cnt,
        f.uom_code,
        0 AS MARKER,
        count (*) cnt
    FROM
        OPI.OPI_DBI_WIP_SCRAP_F f,
        OKI.OKI_DBI_MULTIPLEXER_B mult
    WHERE
        mult.id = 1
    GROUP BY
        mult.rowid,
        f.organization_id,
        f.inventory_item_id,
        f.job_id,
        f.job_type,
        f.transaction_date,
        f.uom_code,
        f.source
    UNION ALL
    SELECT
        rowid row_id,
        organization_id,
        inventory_item_id,
        transaction_date,
        job_id,
        job_type,
        source,
        completion_quantity,
        completion_value_b,
        (completion_value_b * conversion_rate) completion_value_g,
        (completion_value_b * sec_conversion_rate) completion_value_sg,
        0 scrap_quantity,
        0 scrap_quantity_cnt,
        0 scrap_value_b,
        0 scrap_value_b_cnt,
        0 scrap_value_g,
        0 scrap_value_g_cnt,
        0 scrap_value_sg,
        0 scrap_value_sg_cnt,
        uom_code,
        1 AS MARKER,
        0 cnt
    FROM
        OPI.OPI_DBI_WIP_COMP_F