eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MATERIALIZED VIEW: APPS.IBE_BI_TOP_CUST_MV

Source


SELECT MV.CUSTOMER_ID, MV.MINISITE_ID, MV.CURRENCY_CD_F, (CASE WHEN GROUPING (TIME.report_date_julian) = 0 THEN TIME.report_date_julian WHEN GROUPING (TIME.week_id)=0 THEN TIME.week_id WHEN GROUPING (TIME.ent_period_id)=0 THEN TIME.ent_period_id WHEN GROUPING (TIME.ent_qtr_id)=0 THEN TIME.ent_qtr_id ELSE TIME.ent_year_id END) Time_Id, (CASE WHEN GROUPING (TIME.report_date_julian) = 0 THEN 1 WHEN GROUPING (TIME.week_id)=0 THEN 16 WHEN GROUPING (TIME.ent_period_id)=0 THEN 32 WHEN GROUPING (TIME.ent_qtr_id)=0 THEN 64 ELSE 128 END) Period_Type_id, SUM(AMOUNT_G)  AMOUNT_G, SUM(AMOUNT_G1)  AMOUNT_G1, SUM(AMOUNT_F)  AMOUNT_F, SUM(decode(RESOURCE_FLAG,'Y',AMOUNT_G, 0)) ASSISTED_AMT_G, SUM(decode(RESOURCE_FLAG,'Y',AMOUNT_G1, 0)) ASSISTED_AMT_G1, SUM(decode(RESOURCE_FLAG,'Y',AMOUNT_F, 0)) ASSISTED_AMT_F, SUM(LIST_AMOUNT_G) LIST_AMOUNT_G, SUM(LIST_AMOUNT_G1) LIST_AMOUNT_G1, SUM(LIST_AMOUNT_F) LIST_AMOUNT_F, SUM(LIST_AMOUNT_G - AMOUNT_G) DISC_AMOUNT_G, SUM(LIST_AMOUNT_G1 - AMOUNT_G1) DISC_AMOUNT_G1, SUM(LIST_AMOUNT_F - AMOUNT_F) DISC_AMOUNT_F, COUNT(HEADER_ID)  ORDERS_CNT, COUNT(AMOUNT_G)  D_AMOUNT_G_CNT, COUNT(AMOUNT_G1)  D_AMOUNT_G1_CNT, COUNT(AMOUNT_F)  D_AMOUNT_F_CNT, COUNT(decode(RESOURCE_FLAG,'Y',AMOUNT_G, 0)) D_ASSISTED_AMT_G_CNT, COUNT(decode(RESOURCE_FLAG,'Y',AMOUNT_G1, 0)) D_ASSISTED_AMT_G1_CNT, COUNT(decode(RESOURCE_FLAG,'Y',AMOUNT_F, 0)) D_ASSISTED_AMT_F_CNT, COUNT(LIST_AMOUNT_G) LIST_AMOUNT_G_CNT, COUNT(LIST_AMOUNT_G1) LIST_AMOUNT_G1_CNT, COUNT(LIST_AMOUNT_F) LIST_AMOUNT_F_CNT, COUNT(LIST_AMOUNT_G - AMOUNT_G) DISC_AMOUNT_G_CNT, COUNT(LIST_AMOUNT_G1 - AMOUNT_G1) DISC_AMOUNT_G1_CNT, COUNT(LIST_AMOUNT_F - AMOUNT_F) DISC_AMOUNT_F_CNT, TIME.ent_year_id,TIME.ent_qtr_id,TIME.ent_period_id,TIME.week_id,TIME.report_date_julian, GROUPING_ID (MV.CUSTOMER_ID, MV.MINISITE_ID, MV.CURRENCY_CD_F, TIME.ent_year_id,TIME.ent_qtr_id,TIME.ent_period_id,TIME.week_id,TIME.report_date_julian) D_GID, COUNT(*) D_TOTAL_CNT FROM  APPS.IBE_BI_ORDERS_MV mv, FII.FII_TIME_DAY TIME WHERE MV.TIME_BOOKED_DATE_ID = TIME.REPORT_DATE AND MV.PUBLISHED_QUOTE_FLAG = 'N' GROUP BY  MV.CUSTOMER_ID, MV.MINISITE_ID, MV.CURRENCY_CD_F, TIME.ent_year_id,ROLLUP(TIME.ent_qtr_id,TIME.ent_period_id,TIME.week_id,TIME.report_date_julian)