MATERIALIZED VIEW: APPS.OPI_PTP_RPT_BND_MV

Source

Select /* 12.0: bug#4526784 */ organization_id,
           decode (stop_reason_code,
                   1, trunc (last_transaction_date),
                   trunc(last_collection_date)) data_clean_date
      FROM  OPI.OPI_DBI_RUN_LOG_CURR
      WHERE etl_id = 1
        AND source = 1
    UNION ALL
    SELECT mp.organization_id,
           trunc (log.last_collection_date) data_clean_date
      FROM  INV.MTL_PARAMETERS mp,
            OPI.OPI_DBI_RUN_LOG_CURR log
      WHERE log.etl_id = 1
        AND log.source <> 1
        AND mp.process_enabled_flag = 'Y'