[Home] [Help]
MATERIALIZED VIEW: APPS.FII_AR_REV_SUM_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, DECODE(fday.report_date_julian, NULL, DECODE(fday.week_id, NULL, DECODE(fday.ent_period_id, NULL, DECODE(fday.ent_qtr_id,NULL, 128, 64), 32),16), 1) PERIOD_TYPE_ID, fday.report_date_julian, fday.ent_qtr_id, fday.ent_period_id, fday.week_id, fday.ent_year_id, NVL(m.lob_id,'-1') LINE_OF_BUSINESS_ID, NVL(m.manager_id, -1) MANAGER_ID, b.prod_category_id PRODUCT_CATEGORY_ID, b.ledger_id LEDGER_ID, b.sales_channel SALES_CHANNEL_CODE, b.functional_currency ACCT_CURRENCY_CODE, count(*) COUNT_GRP, sum(b.amount_b) REV_ACTUAL_B, count(b.amount_b) COUNT_REV_ACTUAL_B, sum(b.prim_amount_g) REV_PRIM_ACTUAL_G, count(b.prim_amount_g) COUNT_REV_PRIM_ACTUAL_G, sum(b.sec_amount_g) REV_SEC_ACTUAL_G, count(b.sec_amount_g) COUNT_REV_SEC_ACTUAL_G , grouping_id(
NVL(m.lob_id,'-1'),
NVL(m.manager_id, -1) ,
b.prod_category_id,
b.ledger_id,
b.sales_channel,
b.functional_currency ,
fday.ent_year_id,
fday.ent_qtr_id,
fday.ent_period_id,
fday.week_id,
fday.report_date_julian) gid FROM FII.FII_AR_REVENUE_B b, FII.FII_COM_CC_MAPPINGS m, FII.FII_TIME_DAY fday WHERE b.gl_date_id = fday.report_date_julian AND b.company_id = m.company_id AND b.cost_center_id = m.cost_center_id AND nvl(b.FIN_CAT_TYPE_CODE, 'R') = 'R' GROUP BY NVL(m.lob_id,'-1'), NVL(m.manager_id, -1) , b.prod_category_id, b.ledger_id, b.sales_channel, b.functional_currency , ROLLUP (fday.ent_year_id, fday.ent_qtr_id, fday.ent_period_id, fday.week_id, fday.report_date_julian)