[Home] [Help] [Dependency Information]
Object Name: | EAM_PM_SCHEDULING_RULES# |
---|---|
Object Type: | VIEW |
Owner: | EAM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PM_SCHEDULE_ID | NUMBER | Yes | ||
RULE_TYPE | NUMBER | Yes | ||
BASE_DATE | DATE | |||
DAY_INTERVAL | NUMBER | |||
METER_ID | NUMBER | |||
RUNTIME_INTERVAL | NUMBER | |||
LAST_SERVICE_READING | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
PREVIOUS_BASE_DATE | DATE | |||
PREVIOUS_SERVICE_READING | NUMBER | |||
RULE_ID | NUMBER | |||
EFFECTIVE_READING_FROM | NUMBER | |||
EFFECTIVE_READING_TO | NUMBER | |||
EFFECTIVE_DATE_FROM | DATE | |||
EFFECTIVE_DATE_TO | DATE | |||
LIST_DATE | DATE | |||
LIST_DATE_DESC | VARCHAR2 | (50) | ||
MIGRATED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PM_SCHEDULE_ID
, RULE_TYPE
, BASE_DATE
, DAY_INTERVAL
, METER_ID
, RUNTIME_INTERVAL
, LAST_SERVICE_READING
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PREVIOUS_BASE_DATE
, PREVIOUS_SERVICE_READING
, RULE_ID
, EFFECTIVE_READING_FROM
, EFFECTIVE_READING_TO
, EFFECTIVE_DATE_FROM
, EFFECTIVE_DATE_TO
, LIST_DATE
, LIST_DATE_DESC
, MIGRATED_FLAG
FROM EAM.EAM_PM_SCHEDULING_RULES#;
|
|
|