SELECT entity.ROWID erid, planned_usage.ROWID urid, s.ROWID srid,
entity.site_id plant_fk_key, planned_usage.period_profile,
planned_usage.entity_fk_key, planned_usage.planned_usage,
planned_usage.period_of_usage, planned_usage.usage_uom,
planned_usage.hour_fk_key,
planned_usage.from_time, planned_usage.to_time,
planned_usage.ALLOCATED_PLANNED_USAGE,
s.effective_date,
s.expiration_date,
s.site_sustain_pk_key site_sustain_fk_key,
s.sustain_aspect_fk_key,
s.average_planned_cost,
planned_usage.DAY,
planned_usage.FISCAL_WEEK_NAME,
planned_usage.FISCAL_QUARTER_NAME,
planned_usage.FISCAL_YEAR_NAME,
planned_usage.DAY_id,
planned_usage.FISCAL_WEEK_id,
planned_usage.FISCAL_QUARTER_id,
planned_usage.FISCAL_YEAR_id
FROM MTH_ALL_ENTITIES_MV entity,
MTH_ENTITY_PLANNED_USAGE_MV planned_usage,
MTH_SITE_SUSTAINABILITIES s
WHERE entity.entity_pk_key = planned_usage.entity_fk_key
and entity.site_id = s.plant_fk_key
AND planned_usage.sustain_aspect_fk_key = s.sustain_aspect_fk_key
AND planned_usage.from_time BETWEEN s.effective_date AND Nvl(s.expiration_date, To_Date('3000', 'yyyy'))
SELECT ENTITY.ROWID ERID
, PLANNED_USAGE.ROWID URID
, S.ROWID SRID
,
ENTITY.SITE_ID PLANT_FK_KEY
, PLANNED_USAGE.PERIOD_PROFILE
,
PLANNED_USAGE.ENTITY_FK_KEY
, PLANNED_USAGE.PLANNED_USAGE
,
PLANNED_USAGE.PERIOD_OF_USAGE
, PLANNED_USAGE.USAGE_UOM
,
PLANNED_USAGE.HOUR_FK_KEY
,
PLANNED_USAGE.FROM_TIME
, PLANNED_USAGE.TO_TIME
,
PLANNED_USAGE.ALLOCATED_PLANNED_USAGE
,
S.EFFECTIVE_DATE
,
S.EXPIRATION_DATE
,
S.SITE_SUSTAIN_PK_KEY SITE_SUSTAIN_FK_KEY
,
S.SUSTAIN_ASPECT_FK_KEY
,
S.AVERAGE_PLANNED_COST
,
PLANNED_USAGE.DAY
,
PLANNED_USAGE.FISCAL_WEEK_NAME
,
PLANNED_USAGE.FISCAL_QUARTER_NAME
,
PLANNED_USAGE.FISCAL_YEAR_NAME
,
PLANNED_USAGE.DAY_ID
,
PLANNED_USAGE.FISCAL_WEEK_ID
,
PLANNED_USAGE.FISCAL_QUARTER_ID
,
PLANNED_USAGE.FISCAL_YEAR_ID
FROM MTH_ALL_ENTITIES_MV ENTITY
,
MTH_ENTITY_PLANNED_USAGE_MV PLANNED_USAGE
,
MTH_SITE_SUSTAINABILITIES S
WHERE ENTITY.ENTITY_PK_KEY = PLANNED_USAGE.ENTITY_FK_KEY
AND ENTITY.SITE_ID = S.PLANT_FK_KEY
AND PLANNED_USAGE.SUSTAIN_ASPECT_FK_KEY = S.SUSTAIN_ASPECT_FK_KEY
AND PLANNED_USAGE.FROM_TIME BETWEEN S.EFFECTIVE_DATE
AND NVL(S.EXPIRATION_DATE
, TO_DATE('3000'
, 'YYYY'))
|
|
|