MNT_WR_METERS_FACT

Details

Schema: FUSION
Object owner: MNT
Object type: VIEW

Columns

Name
REQUIREMENT_METER_ID OBJECT_VERSION_NUMBER REQUIREMENT_ID REQUIREMENT_TYPE_CODE ITEM_ID ASSET_ID ORGANIZATION_ID METER_DEFINITION_ID METER_ID BASE_INTERVAL NEXT_FORECAST_DUE_BY_CODE DISABLED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Name

REQUIREMENT_METER_ID

OBJECT_VERSION_NUMBER

REQUIREMENT_ID

REQUIREMENT_TYPE_CODE

ITEM_ID

ASSET_ID

ORGANIZATION_ID

METER_DEFINITION_ID

METER_ID

BASE_INTERVAL

NEXT_FORECAST_DUE_BY_CODE

DISABLED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

Query

SQL_Statement
SELECT mrm.requirement_meter_id requirement_meter_id, mrm.object_version_number object_version_number, mrm.requirement_id requirement_id, req.requirement_type_code requirement_type_code, req.item_id item_id, req.asset_id asset_id, mrm.organization_id organization_id, mrm.meter_definition_id meter_definition_id, nvl(mrm.meter_id, meters.meter_id) meter_id, mrm.base_interval base_interval, mrm.next_forecast_due_by_code next_forecast_due_by_code, mrm.disabled_flag disabled_flag, mrm.created_by created_by, mrm.creation_date creation_date, mrm.last_updated_by last_updated_by, mrm.last_update_date last_update_date, mrm.last_update_login last_update_login, mrm.request_id request_id, mrm.job_definition_name job_definition_name, mrm.job_definition_package job_definition_package FROM mnt_wr_meters mrm, (SELECT mr.requirement_id, mr.requirement_type_code, mr.item_id, nvl(mr.asset_id, assets.asset_id) asset_id FROM mnt_work_requirements_b mr LEFT OUTER JOIN cse_assets_b assets ON mr.item_id = assets.item_id AND mr.requirement_type_code = 'ORA_ITEM' AND assets.maintainable_flag = 'Y' AND ( (NVL(mr.asset_inclusion_type_code,'ORA_AUTOMATIC') = 'ORA_AUTOMATIC' AND assets.asset_id NOT IN ( SELECT excluded_assets.asset_id FROM mnt_wr_excluded_assets excluded_assets WHERE mr.requirement_id=excluded_assets.requirement_id)) OR (mr.asset_inclusion_type_code = 'ORA_MANUAL' AND assets.asset_id IN ( SELECT included_assets.asset_id FROM mnt_wr_included_assets included_assets WHERE mr.requirement_id=included_assets.requirement_id)) )) req, cse_meters meters WHERE req.requirement_id = mrm.requirement_id AND meters.meter_usage_code = 'ORA_ASSET' AND meters.meter_object_id = req.asset_id AND meters.meter_definition_id = mrm.meter_definition_id

SQL_Statement

SELECT mrm.requirement_meter_id requirement_meter_id,

mrm.object_version_number object_version_number,

mrm.requirement_id requirement_id,

req.requirement_type_code requirement_type_code,

req.item_id item_id,

req.asset_id asset_id,

mrm.organization_id organization_id,

mrm.meter_definition_id meter_definition_id,

nvl(mrm.meter_id, meters.meter_id) meter_id,

mrm.base_interval base_interval,

mrm.next_forecast_due_by_code next_forecast_due_by_code,

mrm.disabled_flag disabled_flag,

mrm.created_by created_by,

mrm.creation_date creation_date,

mrm.last_updated_by last_updated_by,

mrm.last_update_date last_update_date,

mrm.last_update_login last_update_login,

mrm.request_id request_id,

mrm.job_definition_name job_definition_name,

mrm.job_definition_package job_definition_package

FROM mnt_wr_meters mrm,

(SELECT mr.requirement_id,

mr.requirement_type_code,

mr.item_id,

nvl(mr.asset_id, assets.asset_id) asset_id

FROM mnt_work_requirements_b mr

LEFT OUTER JOIN cse_assets_b assets

ON mr.item_id = assets.item_id

AND mr.requirement_type_code = 'ORA_ITEM'

AND assets.maintainable_flag = 'Y'

AND

(

(NVL(mr.asset_inclusion_type_code,'ORA_AUTOMATIC') = 'ORA_AUTOMATIC'

AND assets.asset_id NOT IN (

SELECT excluded_assets.asset_id

FROM mnt_wr_excluded_assets excluded_assets

WHERE mr.requirement_id=excluded_assets.requirement_id))

OR

(mr.asset_inclusion_type_code = 'ORA_MANUAL'

AND assets.asset_id IN (

SELECT included_assets.asset_id

FROM mnt_wr_included_assets included_assets

WHERE mr.requirement_id=included_assets.requirement_id))

)) req,

cse_meters meters

WHERE req.requirement_id = mrm.requirement_id

AND meters.meter_usage_code = 'ORA_ASSET'

AND meters.meter_object_id = req.asset_id

AND meters.meter_definition_id = mrm.meter_definition_id