MATERIALIZED VIEW: APPS.OPI_PTP_ITEM_F_MV

Source

Select /* 12.0: bug#4526784 */ organization_id,
           inventory_item_id,
           transaction_date,
           uom_code,
           planned_item,
           sum (actual_quantity) actual_quantity,
           sum (decode (planned_item,
                        'Y', actual_quantity * unit_cost,
                        0))
                actual_standard_value_b,
           sum (decode (planned_item,
                        'Y', actual_quantity * unit_cost *
                               conversion_rate,
                        0)) actual_standard_value_g,
           sum (planned_quantity) planned_quantity,
           sum (planned_quantity * unit_cost) planned_standard_value_b,
           sum (planned_quantity * unit_cost * conversion_rate)
                planned_standard_value_g,
           count (actual_quantity) act_qty_cnt,
           count (decode (planned_item,
                          'Y', actual_quantity * unit_cost,
                          0)) act_std_val_b_cnt,
           count (decode (planned_item,
                          'Y', actual_quantity * unit_cost * conversion_rate,
                          0)) act_std_val_g_cnt,
           count (planned_quantity) pln_qty_cnt,
           count (planned_quantity * unit_cost) pln_std_val_b_cnt,
           count(planned_quantity * unit_cost * conversion_rate)
                pln_std_val_g_cnt,
           sum (decode (planned_item,
                        'Y', actual_quantity * unit_cost *
                               sec_conversion_rate,
                        0)) actual_standard_value_sg,
           count (decode (planned_item,
                        'Y', actual_quantity * unit_cost *
                               sec_conversion_rate,
                        0)) act_std_val_sg_cnt,
           sum (planned_quantity * unit_cost * sec_conversion_rate)
                planned_standard_value_sg,
           count (planned_quantity * unit_cost * sec_conversion_rate)
                pln_std_val_sg_cnt,
           count(*) cnt
      FROM  opi_ptp_cbn_mv
      GROUP BY
        organization_id,
        inventory_item_id,
        transaction_date,
        uom_code,
        planned_item