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.
[Home] [Help]
MATERIALIZED VIEW: APPS.MTH_ENTITY_PLANNED_USAGE_MV

Source


SELECT "A1"."HRID" "HRID","A1"."CRID" "CRID","A1"."URID" "URID","A1"."PERIOD_PROFILE" "PERIOD_PROFILE","A1"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A1"."PLANNED_USAGE" "PLANNED_USAGE","A1"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A1"."USAGE_UOM" "USAGE_UOM","A1"."DAY" "DAY","A1"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A1"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A1"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A1"."DAY_ID" "DAY_ID","A1"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A1"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A1"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A1"."HOUR_FK_KEY" "HOUR_FK_KEY","A1"."FROM_TIME" "FROM_TIME","A1"."TO_TIME" "TO_TIME","A1"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A1"."ALLOCATED_PLANNED_USAGE" "ALLOCATED_PLANNED_USAGE","A1"."UMARKER" "UMARKER" FROM  ( (SELECT "A16".ROWID "HRID","A17".ROWID "CRID","A15".ROWID "URID",'DAY' "PERIOD_PROFILE","A15"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A15"."PLANNED_USAGE" "PLANNED_USAGE","A15"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A15"."USAGE_UOM" "USAGE_UOM","A17"."DAY" "DAY","A17"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A17"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A17"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A17"."DAY_ID" "DAY_ID","A17"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A17"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A17"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A16"."HOUR_PK_KEY" "HOUR_FK_KEY","A16"."FROM_TIME" "FROM_TIME","A16"."TO_TIME" "TO_TIME","A15"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A15"."PLANNED_USAGE"/("A17"."DAY_TIME_SPAN"*24) "ALLOCATED_PLANNED_USAGE",1 "UMARKER" FROM "MTH"."MTH_445_PERIOD_CALENDAR" "A17","MTH"."MTH_HOUR_D" "A16","MTH"."MTH_ENTITY_PLANNED_USAGE" "A15" WHERE "A17"."DAY_ID" IS NOT NULL AND "A15"."PERIOD_OF_USAGE"="A17"."DAY_NAME" AND "A17"."DAY"=TRUNC("A16"."FROM_TIME")) UNION ALL  (SELECT "A13".ROWID "HRID","A14".ROWID "CRID","A12".ROWID "URID",'WEEK' "PERIOD_PROFILE","A12"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A12"."PLANNED_USAGE" "PLANNED_USAGE","A12"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A12"."USAGE_UOM" "USAGE_UOM","A14"."DAY" "DAY","A14"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A14"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A14"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A14"."DAY_ID" "DAY_ID","A14"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A14"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A14"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A13"."HOUR_PK_KEY" "HOUR_FK_KEY","A13"."FROM_TIME" "FROM_TIME","A13"."TO_TIME" "TO_TIME","A12"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A12"."PLANNED_USAGE"/("A14"."FISCAL_WEEK_TIME_SPAN"*24) "ALLOCATED_PLANNED_USAGE",2 "UMARKER" FROM "MTH"."MTH_445_PERIOD_CALENDAR" "A14","MTH"."MTH_HOUR_D" "A13","MTH"."MTH_ENTITY_PLANNED_USAGE" "A12" WHERE "A14"."DAY_ID" IS NOT NULL AND "A14"."DAY"=TRUNC("A13"."FROM_TIME") AND "A12"."PERIOD_OF_USAGE"="A14"."FISCAL_WEEK_NAME") UNION ALL  (SELECT "A10".ROWID "HRID","A11".ROWID "CRID","A9".ROWID "URID",'PERIOD' "PERIOD_PROFILE","A9"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A9"."PLANNED_USAGE" "PLANNED_USAGE","A9"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A9"."USAGE_UOM" "USAGE_UOM","A11"."DAY" "DAY","A11"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A11"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A11"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A11"."DAY_ID" "DAY_ID","A11"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A11"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A11"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A10"."HOUR_PK_KEY" "HOUR_FK_KEY","A10"."FROM_TIME" "FROM_TIME","A10"."TO_TIME" "TO_TIME","A9"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A9"."PLANNED_USAGE"/("A11"."FISCAL_MONTH_TIME_SPAN"*24) "ALLOCATED_PLANNED_USAGE",3 "UMARKER" FROM "MTH"."MTH_445_PERIOD_CALENDAR" "A11","MTH"."MTH_HOUR_D" "A10","MTH"."MTH_ENTITY_PLANNED_USAGE" "A9" WHERE "A11"."DAY_ID" IS NOT NULL AND "A11"."DAY"=TRUNC("A10"."FROM_TIME") AND "A9"."PERIOD_OF_USAGE"="A11"."FISCAL_MONTH_NAME") UNION ALL  (SELECT "A7".ROWID "HRID","A8".ROWID "CRID","A6".ROWID "URID",'QUARTER' "PERIOD_PROFILE","A6"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A6"."PLANNED_USAGE" "PLANNED_USAGE","A6"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A6"."USAGE_UOM" "USAGE_UOM","A8"."DAY" "DAY","A8"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A8"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A8"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A8"."DAY_ID" "DAY_ID","A8"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A8"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A8"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A7"."HOUR_PK_KEY" "HOUR_FK_KEY","A7"."FROM_TIME" "FROM_TIME","A7"."TO_TIME" "TO_TIME","A6"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A6"."PLANNED_USAGE"/("A8"."FISCAL_QUARTER_TIME_SPAN"*24) "ALLOCATED_PLANNED_USAGE",4 "UMARKER" FROM "MTH"."MTH_445_PERIOD_CALENDAR" "A8","MTH"."MTH_HOUR_D" "A7","MTH"."MTH_ENTITY_PLANNED_USAGE" "A6" WHERE "A8"."DAY_ID" IS NOT NULL AND "A8"."DAY"=TRUNC("A7"."FROM_TIME") AND "A6"."PERIOD_OF_USAGE"="A8"."FISCAL_QUARTER_NAME") UNION ALL  (SELECT "A4".ROWID "HRID","A5".ROWID "CRID","A3".ROWID "URID",'YEAR' "PERIOD_PROFILE","A3"."ENTITY_FK_KEY" "ENTITY_FK_KEY","A3"."PLANNED_USAGE" "PLANNED_USAGE","A3"."PERIOD_OF_USAGE" "PERIOD_OF_USAGE","A3"."USAGE_UOM" "USAGE_UOM","A5"."DAY" "DAY","A5"."FISCAL_WEEK_NAME" "FISCAL_WEEK_NAME","A5"."FISCAL_QUARTER_NAME" "FISCAL_QUARTER_NAME","A5"."FISCAL_YEAR_NAME" "FISCAL_YEAR_NAME","A5"."DAY_ID" "DAY_ID","A5"."FISCAL_WEEK_ID" "FISCAL_WEEK_ID","A5"."FISCAL_QUARTER_ID" "FISCAL_QUARTER_ID","A5"."FISCAL_YEAR_ID" "FISCAL_YEAR_ID","A4"."HOUR_PK_KEY" "HOUR_FK_KEY","A4"."FROM_TIME" "FROM_TIME","A4"."TO_TIME" "TO_TIME","A3"."SUSTAIN_ASPECT_FK_KEY" "SUSTAIN_ASPECT_FK_KEY","A3"."PLANNED_USAGE"/("A5"."FISCAL_YEAR_TIME_SPAN"*24) "ALLOCATED_PLANNED_USAGE",5 "UMARKER" FROM "MTH"."MTH_445_PERIOD_CALENDAR" "A5","MTH"."MTH_HOUR_D" "A4","MTH"."MTH_ENTITY_PLANNED_USAGE" "A3" WHERE "A5"."DAY_ID" IS NOT NULL AND "A5"."DAY"=TRUNC("A4"."FROM_TIME") AND "A3"."PERIOD_OF_USAGE"="A5"."FISCAL_YEAR_NAME")) "A1"