MATERIALIZED VIEW: APPS.ENI_DBI_COGS_BASE_MV

Source

SELECT /* 12.0: bug#4526784 */
        NVL(fday.report_date_julian,
                NVL(fday.week_id,
                        NVL(fday.ent_period_id,
                                NVL(fday.ent_qtr_id, fday.ent_year_id)))) TIME_ID,
        fday.report_date_julian,
        fday.ent_qtr_id,
        fday.ent_period_id,
        fday.week_id,
        fday.ent_year_id,
        b.inventory_item_id,
        b.organization_id,
        sum(b.cogs_val_g) cogs_val_g,
        count(b.cogs_val_g) c_cogs_val_g,
        sum(b.cogs_val_sg) cogs_val_sg,
        count(b.cogs_val_sg) c_cogs_val_sg,
        grouping_id(
                b.inventory_item_id,
                b.organization_id,
                fday.ent_year_id,
                fday.ent_qtr_id,
                fday.ent_period_id,
                fday.week_id,
                fday.report_date_julian) gid,
         count(*)
FROM
        OPI.OPI_DBI_COGS_F b,
        FII.FII_TIME_DAY fday
WHERE
        b.cogs_date is not null
   and trunc(b.cogs_date) = trunc(fday.report_date)
GROUP BY
        b.inventory_item_id,
        b.organization_id,
        grouping sets (
                fday.ent_year_id,
                fday.ent_qtr_id,
                fday.ent_period_id,
                fday.week_id,
                fday.report_date_julian)