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.

VIEW: APPS.MTH_ENTITY_PLANNED_USAGE_MV#

Source

View Text - Preformatted


SELECT MTH_ENTITY_PLANNED_USAGE.HRID HRID,MTH_ENTITY_PLANNED_USAGE.CRID CRID, MTH_ENTITY_PLANNED_USAGE.URID URID,MTH_ENTITY_PLANNED_USAGE.PERIOD_PROFILE PERIOD_PROFILE,MTH_ENTITY_PLANNED_USAGE.ENTITY_FK_KEY ENTITY_FK_KEY, MTH_ENTITY_PLANNED_USAGE.PLANNED_USAGE PLANNED_USAGE,MTH_ENTITY_PLANNED_USAGE.PERIOD_OF_USAGE PERIOD_OF_USAGE,MTH_ENTITY_PLANNED_USAGE.USAGE_UOM USAGE_UOM,MTH_ENTITY_PLANNED_USAGE.DAY DAY,MTH_ENTITY_PLANNED_USAGE.FISCAL_WEEK_NAME FISCAL_WEEK_NAME,MTH_ENTITY_PLANNED_USAGE.FISCAL_QUARTER_NAME FISCAL_QUARTER_NAME,MTH_ENTITY_PLANNED_USAGE.FISCAL_YEAR_NAME FISCAL_YEAR_NAME,MTH_ENTITY_PLANNED_USAGE.DAY_ID,MTH_ENTITY_PLANNED_USAGE.FISCAL_WEEK_ID FISCAL_WEEK_ID,MTH_ENTITY_PLANNED_USAGE.FISCAL_QUARTER_ID FISCAL_QUARTER_ID,MTH_ENTITY_PLANNED_USAGE.FISCAL_YEAR_ID FISCAL_YEAR_ID,MTH_ENTITY_PLANNED_USAGE.HOUR_FK_KEY HOUR_FK_KEY,MTH_ENTITY_PLANNED_USAGE.FROM_TIME FROM_TIME,MTH_ENTITY_PLANNED_USAGE.TO_TIME TO_TIME,MTH_ENTITY_PLANNED_USAGE.SUSTAIN_ASPECT_FK_KEY SUSTAIN_ASPECT_FK_KEY,MTH_ENTITY_PLANNED_USAGE.ALLOCATED_PLANNED_USAGE ALLOCATED_PLANNED_USAGE,MTH_ENTITY_PLANNED_USAGE.UMARKER UMARKER FROM  ( SELECT h.ROWID hrid,
    b.rowid crid,
    o.rowid urid,
    'DAY' period_profile,
    o.entity_fk_key,
    o.planned_usage,
    o.period_of_usage,
    o.usage_uom,
    b.day,
    b.FISCAL_WEEK_NAME,
    b.FISCAL_QUARTER_NAME,
    b.FISCAL_YEAR_NAME,
    b.day_id,
    b.FISCAL_WEEK_id,
    b.FISCAL_QUARTER_id,
    b.FISCAL_YEAR_id,
    h.hour_pk_key hour_fk_key,
    h.from_time,
    h.to_time,
    o.sustain_aspect_fk_key,
    o.planned_usage / (b.day_time_span * 24) ALLOCATED_PLANNED_USAGE,
    1 umarker
  FROM Mth_445_Period_Calendar b,
    mth_hour_d h,
    MTH_ENTITY_PLANNED_USAGE o
  WHERE b.DAY_ID       IS NOT NULL
  AND o.period_of_usage = b.day_name
  AND b.day             = TRUNC(h.from_time)
  UNION ALL
  SELECT h.ROWID hrid,
    b.rowid crid,
    o.rowid urid,
    'WEEK' period_profile,
    o.entity_fk_key,
    o.planned_usage,
    o.period_of_usage,
    o.usage_uom,
    b.day,
    b.FISCAL_WEEK_NAME,
    b.FISCAL_QUARTER_NAME,
    b.FISCAL_YEAR_NAME,
    b.day_id,
    b.FISCAL_WEEK_id,
    b.FISCAL_QUARTER_id,
    b.FISCAL_YEAR_id,
    h.hour_pk_key hour_fk_key,
    h.from_time,
    h.to_time,
    o.sustain_aspect_fk_key,
    o.planned_usage / (b.fiscal_week_time_span * 24) ALLOCATED_PLANNED_USAGE,
    2 umarker
  FROM Mth_445_Period_Calendar b,
    mth_hour_d h,
    MTH_ENTITY_PLANNED_USAGE o
  WHERE b.DAY_ID       IS NOT NULL
  AND b.day             = TRUNC(h.from_time)
  AND o.period_of_usage = b.fiscal_week_name
  UNION ALL
  SELECT h.ROWID hrid,
    b.rowid crid,
    o.rowid urid,
    'PERIOD' period_profile,
    o.entity_fk_key,
    o.planned_usage,
    o.period_of_usage,
    o.usage_uom,
    b.day,
    b.FISCAL_WEEK_NAME,
    b.FISCAL_QUARTER_NAME,
    b.FISCAL_YEAR_NAME,
    b.day_id,
    b.FISCAL_WEEK_id,
    b.FISCAL_QUARTER_id,
    b.FISCAL_YEAR_id,
    h.hour_pk_key hour_fk_key,
    h.from_time,
    h.to_time,
    o.sustain_aspect_fk_key,
    o.planned_usage / (b.fiscal_month_time_span * 24) ALLOCATED_PLANNED_USAGE,
    3 umarker
  FROM Mth_445_Period_Calendar b,
    mth_hour_d h,
    MTH_ENTITY_PLANNED_USAGE o
  WHERE b.DAY_ID       IS NOT NULL
  AND b.day             = TRUNC(h.from_time)
  AND o.period_of_usage = b.fiscal_month_name
  UNION ALL
  SELECT h.ROWID hrid,
    b.rowid crid,
    o.rowid urid,
    'QUARTER' period_profile,
    o.entity_fk_key,
    o.planned_usage,
    o.period_of_usage,
    o.usage_uom,
    b.day,
    b.FISCAL_WEEK_NAME,
    b.FISCAL_QUARTER_NAME,
    b.FISCAL_YEAR_NAME,
    b.day_id,
    b.FISCAL_WEEK_id,
    b.FISCAL_QUARTER_id,
    b.FISCAL_YEAR_id,
    h.hour_pk_key hour_fk_key,
    h.from_time,
    h.to_time,
    o.sustain_aspect_fk_key,
    o.planned_usage / (b.fiscal_quarter_time_span * 24) ALLOCATED_PLANNED_USAGE,
    4 umarker
  FROM Mth_445_Period_Calendar b,
    mth_hour_d h,
    MTH_ENTITY_PLANNED_USAGE o
  WHERE b.DAY_ID       IS NOT NULL
  AND b.day             = TRUNC(h.from_time)
  AND o.period_of_usage = b.fiscal_quarter_name
  UNION ALL
  SELECT h.ROWID hrid,
    b.rowid crid,
    o.rowid urid,
    'YEAR' period_profile,
    o.entity_fk_key,
    o.planned_usage,
    o.period_of_usage,
    o.usage_uom,
    b.day,
    b.FISCAL_WEEK_NAME,
    b.FISCAL_QUARTER_NAME,
    b.FISCAL_YEAR_NAME,
    b.day_id,
    b.FISCAL_WEEK_id,
    b.FISCAL_QUARTER_id,
    b.FISCAL_YEAR_id,
    h.hour_pk_key hour_fk_key,
    h.from_time,
    h.to_time,
    o.sustain_aspect_fk_key,
    o.planned_usage / (b.fiscal_year_time_span * 24) ALLOCATED_PLANNED_USAGE,
    5 umarker
  FROM Mth_445_Period_Calendar b,
    mth_hour_d h,
    MTH_ENTITY_PLANNED_USAGE o
  WHERE b.DAY_ID       IS NOT NULL
  AND b.day             = TRUNC(h.from_time)
  AND o.period_of_usage = b.fiscal_year_name ) MTH_ENTITY_PLANNED_USAGE

View Text - HTML Formatted

SELECT MTH_ENTITY_PLANNED_USAGE.HRID HRID
, MTH_ENTITY_PLANNED_USAGE.CRID CRID
, MTH_ENTITY_PLANNED_USAGE.URID URID
, MTH_ENTITY_PLANNED_USAGE.PERIOD_PROFILE PERIOD_PROFILE
, MTH_ENTITY_PLANNED_USAGE.ENTITY_FK_KEY ENTITY_FK_KEY
, MTH_ENTITY_PLANNED_USAGE.PLANNED_USAGE PLANNED_USAGE
, MTH_ENTITY_PLANNED_USAGE.PERIOD_OF_USAGE PERIOD_OF_USAGE
, MTH_ENTITY_PLANNED_USAGE.USAGE_UOM USAGE_UOM
, MTH_ENTITY_PLANNED_USAGE.DAY DAY
, MTH_ENTITY_PLANNED_USAGE.FISCAL_WEEK_NAME FISCAL_WEEK_NAME
, MTH_ENTITY_PLANNED_USAGE.FISCAL_QUARTER_NAME FISCAL_QUARTER_NAME
, MTH_ENTITY_PLANNED_USAGE.FISCAL_YEAR_NAME FISCAL_YEAR_NAME
, MTH_ENTITY_PLANNED_USAGE.DAY_ID
, MTH_ENTITY_PLANNED_USAGE.FISCAL_WEEK_ID FISCAL_WEEK_ID
, MTH_ENTITY_PLANNED_USAGE.FISCAL_QUARTER_ID FISCAL_QUARTER_ID
, MTH_ENTITY_PLANNED_USAGE.FISCAL_YEAR_ID FISCAL_YEAR_ID
, MTH_ENTITY_PLANNED_USAGE.HOUR_FK_KEY HOUR_FK_KEY
, MTH_ENTITY_PLANNED_USAGE.FROM_TIME FROM_TIME
, MTH_ENTITY_PLANNED_USAGE.TO_TIME TO_TIME
, MTH_ENTITY_PLANNED_USAGE.SUSTAIN_ASPECT_FK_KEY SUSTAIN_ASPECT_FK_KEY
, MTH_ENTITY_PLANNED_USAGE.ALLOCATED_PLANNED_USAGE ALLOCATED_PLANNED_USAGE
, MTH_ENTITY_PLANNED_USAGE.UMARKER UMARKER
FROM ( SELECT H.ROWID HRID
, B.ROWID CRID
, O.ROWID URID
, 'DAY' PERIOD_PROFILE
, O.ENTITY_FK_KEY
, O.PLANNED_USAGE
, O.PERIOD_OF_USAGE
, O.USAGE_UOM
, B.DAY
, B.FISCAL_WEEK_NAME
, B.FISCAL_QUARTER_NAME
, B.FISCAL_YEAR_NAME
, B.DAY_ID
, B.FISCAL_WEEK_ID
, B.FISCAL_QUARTER_ID
, B.FISCAL_YEAR_ID
, H.HOUR_PK_KEY HOUR_FK_KEY
, H.FROM_TIME
, H.TO_TIME
, O.SUSTAIN_ASPECT_FK_KEY
, O.PLANNED_USAGE / (B.DAY_TIME_SPAN * 24) ALLOCATED_PLANNED_USAGE
, 1 UMARKER
FROM MTH_445_PERIOD_CALENDAR B
, MTH_HOUR_D H
, MTH_ENTITY_PLANNED_USAGE O
WHERE B.DAY_ID IS NOT NULL
AND O.PERIOD_OF_USAGE = B.DAY_NAME
AND B.DAY = TRUNC(H.FROM_TIME) UNION ALL SELECT H.ROWID HRID
, B.ROWID CRID
, O.ROWID URID
, 'WEEK' PERIOD_PROFILE
, O.ENTITY_FK_KEY
, O.PLANNED_USAGE
, O.PERIOD_OF_USAGE
, O.USAGE_UOM
, B.DAY
, B.FISCAL_WEEK_NAME
, B.FISCAL_QUARTER_NAME
, B.FISCAL_YEAR_NAME
, B.DAY_ID
, B.FISCAL_WEEK_ID
, B.FISCAL_QUARTER_ID
, B.FISCAL_YEAR_ID
, H.HOUR_PK_KEY HOUR_FK_KEY
, H.FROM_TIME
, H.TO_TIME
, O.SUSTAIN_ASPECT_FK_KEY
, O.PLANNED_USAGE / (B.FISCAL_WEEK_TIME_SPAN * 24) ALLOCATED_PLANNED_USAGE
, 2 UMARKER
FROM MTH_445_PERIOD_CALENDAR B
, MTH_HOUR_D H
, MTH_ENTITY_PLANNED_USAGE O
WHERE B.DAY_ID IS NOT NULL
AND B.DAY = TRUNC(H.FROM_TIME)
AND O.PERIOD_OF_USAGE = B.FISCAL_WEEK_NAME UNION ALL SELECT H.ROWID HRID
, B.ROWID CRID
, O.ROWID URID
, 'PERIOD' PERIOD_PROFILE
, O.ENTITY_FK_KEY
, O.PLANNED_USAGE
, O.PERIOD_OF_USAGE
, O.USAGE_UOM
, B.DAY
, B.FISCAL_WEEK_NAME
, B.FISCAL_QUARTER_NAME
, B.FISCAL_YEAR_NAME
, B.DAY_ID
, B.FISCAL_WEEK_ID
, B.FISCAL_QUARTER_ID
, B.FISCAL_YEAR_ID
, H.HOUR_PK_KEY HOUR_FK_KEY
, H.FROM_TIME
, H.TO_TIME
, O.SUSTAIN_ASPECT_FK_KEY
, O.PLANNED_USAGE / (B.FISCAL_MONTH_TIME_SPAN * 24) ALLOCATED_PLANNED_USAGE
, 3 UMARKER
FROM MTH_445_PERIOD_CALENDAR B
, MTH_HOUR_D H
, MTH_ENTITY_PLANNED_USAGE O
WHERE B.DAY_ID IS NOT NULL
AND B.DAY = TRUNC(H.FROM_TIME)
AND O.PERIOD_OF_USAGE = B.FISCAL_MONTH_NAME UNION ALL SELECT H.ROWID HRID
, B.ROWID CRID
, O.ROWID URID
, 'QUARTER' PERIOD_PROFILE
, O.ENTITY_FK_KEY
, O.PLANNED_USAGE
, O.PERIOD_OF_USAGE
, O.USAGE_UOM
, B.DAY
, B.FISCAL_WEEK_NAME
, B.FISCAL_QUARTER_NAME
, B.FISCAL_YEAR_NAME
, B.DAY_ID
, B.FISCAL_WEEK_ID
, B.FISCAL_QUARTER_ID
, B.FISCAL_YEAR_ID
, H.HOUR_PK_KEY HOUR_FK_KEY
, H.FROM_TIME
, H.TO_TIME
, O.SUSTAIN_ASPECT_FK_KEY
, O.PLANNED_USAGE / (B.FISCAL_QUARTER_TIME_SPAN * 24) ALLOCATED_PLANNED_USAGE
, 4 UMARKER
FROM MTH_445_PERIOD_CALENDAR B
, MTH_HOUR_D H
, MTH_ENTITY_PLANNED_USAGE O
WHERE B.DAY_ID IS NOT NULL
AND B.DAY = TRUNC(H.FROM_TIME)
AND O.PERIOD_OF_USAGE = B.FISCAL_QUARTER_NAME UNION ALL SELECT H.ROWID HRID
, B.ROWID CRID
, O.ROWID URID
, 'YEAR' PERIOD_PROFILE
, O.ENTITY_FK_KEY
, O.PLANNED_USAGE
, O.PERIOD_OF_USAGE
, O.USAGE_UOM
, B.DAY
, B.FISCAL_WEEK_NAME
, B.FISCAL_QUARTER_NAME
, B.FISCAL_YEAR_NAME
, B.DAY_ID
, B.FISCAL_WEEK_ID
, B.FISCAL_QUARTER_ID
, B.FISCAL_YEAR_ID
, H.HOUR_PK_KEY HOUR_FK_KEY
, H.FROM_TIME
, H.TO_TIME
, O.SUSTAIN_ASPECT_FK_KEY
, O.PLANNED_USAGE / (B.FISCAL_YEAR_TIME_SPAN * 24) ALLOCATED_PLANNED_USAGE
, 5 UMARKER
FROM MTH_445_PERIOD_CALENDAR B
, MTH_HOUR_D H
, MTH_ENTITY_PLANNED_USAGE O
WHERE B.DAY_ID IS NOT NULL
AND B.DAY = TRUNC(H.FROM_TIME)
AND O.PERIOD_OF_USAGE = B.FISCAL_YEAR_NAME ) MTH_ENTITY_PLANNED_USAGE