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]

VIEW: EAM.EAM_PM_SCHEDULING_RULES#

Source

View Text - Preformatted


select PM_SCHEDULE_ID PM_SCHEDULE_ID, RULE_TYPE RULE_TYPE, BASE_DATE BASE_DATE, DAY_INTERVAL DAY_INTERVAL, METER_ID METER_ID, RUNTIME_INTERVAL RUNTIME_INTERVAL, LAST_SERVICE_READING LAST_SERVICE_READING, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PREVIOUS_BASE_DATE PREVIOUS_BASE_DATE, PREVIOUS_SERVICE_READING PREVIOUS_SERVICE_READING, RULE_ID RULE_ID, EFFECTIVE_READING_FROM EFFECTIVE_READING_FROM, EFFECTIVE_READING_TO EFFECTIVE_READING_TO, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO, LIST_DATE LIST_DATE, LIST_DATE_DESC LIST_DATE_DESC, MIGRATED_FLAG MIGRATED_FLAG from "EAM"."EAM_PM_SCHEDULING_RULES"

View Text - HTML Formatted

SELECT PM_SCHEDULE_ID PM_SCHEDULE_ID
, RULE_TYPE RULE_TYPE
, BASE_DATE BASE_DATE
, DAY_INTERVAL DAY_INTERVAL
, METER_ID METER_ID
, RUNTIME_INTERVAL RUNTIME_INTERVAL
, LAST_SERVICE_READING LAST_SERVICE_READING
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PREVIOUS_BASE_DATE PREVIOUS_BASE_DATE
, PREVIOUS_SERVICE_READING PREVIOUS_SERVICE_READING
, RULE_ID RULE_ID
, EFFECTIVE_READING_FROM EFFECTIVE_READING_FROM
, EFFECTIVE_READING_TO EFFECTIVE_READING_TO
, EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, LIST_DATE LIST_DATE
, LIST_DATE_DESC LIST_DATE_DESC
, MIGRATED_FLAG MIGRATED_FLAG
FROM "EAM"."EAM_PM_SCHEDULING_RULES"