VIEW: APPS.MTH_ENTITY_PLANNED_USAGE_HR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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