MATERIALIZED VIEW: APPS.OPI_PTP_CBN_MV

Source

Select /* 12.0: bug#4526784 */ mult.rowid f_rowid,
           mult.rowid cost_rowid,
           mult.rowid conv_rowid,
           f.organization_id,
           f.inventory_item_id,
           f.transaction_date,
           sum(f.completion_quantity) actual_quantity,
	   count(f.completion_quantity) actual_quantity_cnt,
           0 planned_quantity,
           f.planned_item,
           f.uom_code,
           cost.unit_cost,
           conv.conversion_rate,
           1 marker,
           conv.sec_conversion_rate sec_conversion_rate,
	   count(*) cnt
      from  OPI.OPI_DBI_WIP_COMP_F f,
            OPI.OPI_DBI_PTP_COST cost,
            OPI.OPI_DBI_PTP_CONV conv,
	    OKI.OKI_DBI_MULTIPLEXER_B mult
      where f.organization_id = cost.organization_id
        and f.inventory_item_id = cost.inventory_item_id
        and f.transaction_date >= cost.from_date
        and f.transaction_date < nvl(cost.to_date, f.transaction_date + 1)
        and f.organization_id = conv.organization_id
        and f.transaction_date >= conv.from_date
        and f.transaction_date < nvl(conv.to_date, f.transaction_date + 1)
	and mult.id = 1
      group by
            mult.rowid,
            f.organization_id,
            f.inventory_item_id,
            f.transaction_date,
            f.planned_item,
            f.uom_code,
            cost.unit_cost,
            conv.conversion_rate,
	    conv.sec_conversion_rate
    UNION ALL
    select f.rowid f_rowid,
           cost.rowid cost_rowid,
           conv.rowid conv_rowid,
           f.organization_id,
           f.inventory_item_id,
           f.transaction_date,
           0 actual_quantity,
	   0 actual_quantity_cnt,
           f.planned_quantity,
           'Y' planned_item,
           f.uom_code,
           cost.unit_cost,
           conv.conversion_rate,
           2 marker,
           conv.sec_conversion_rate sec_conversion_rate,
	   0 cnt
      from OPI.OPI_DBI_PTP_PLAN_F f,
           OPI.OPI_DBI_PTP_COST cost,
           OPI.OPI_DBI_PTP_CONV conv
      where f.organization_id = cost.organization_id
        and f.inventory_item_id = cost.inventory_item_id
        and f.transaction_date >= cost.from_date
        and f.transaction_date < nvl(cost.to_date, f.transaction_date + 1)
        and f.organization_id = conv.organization_id
        and f.transaction_date >= conv.from_date
        and f.transaction_date < nvl(conv.to_date, f.transaction_date + 1)