DBA Data[Home] [Help] [Dependency Information]

TABLE: EAM.EAM_PM_SCHEDULING_RULES

Object Details
Object Name: EAM_PM_SCHEDULING_RULES
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_PM_SCHEDULING_RULES
Subobject Name:
Status: VALID


This table stores the rules of each preventive maintenance schedule. The rules include day time rules (rule_type=1), run time rules (rule_type=2), and list date rules (rule_type=3). Based on these rules, the preventive maintenance engine forecasts work orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_PM_SCHEDULING_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPM_SCHEDULE_ID
EAM_PM_SCHEDULING_RULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
EAM_PM_SCHEDULING_RULES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMETER_ID
ColumnRULE_TYPE
Columns
Name Datatype Length Mandatory Comments
PM_SCHEDULE_ID NUMBER
Yes Preventive Maintenance Schedule Identifier
RULE_TYPE NUMBER
Yes Rule Type
BASE_DATE DATE

Base Date(Obsolete in I). See mtl_eam_asset_activities.last_service_start, last_service_end_date.
DAY_INTERVAL NUMBER

Day Interval
METER_ID NUMBER

Meter Identifier
RUNTIME_INTERVAL NUMBER

Runtime Interval
LAST_SERVICE_READING NUMBER

Last Service Reading(Obsolete in I) . See eam_pm_last_service.last_service_reading
CREATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
PREVIOUS_BASE_DATE DATE

Previous Base Date(Obsolete in I)
PREVIOUS_SERVICE_READING NUMBER

Previous Service Reading(Obsolete in I)
RULE_ID NUMBER

PM scheduling rules identifier
EFFECTIVE_READING_FROM NUMBER

The effective meter reading of the runtime rule
EFFECTIVE_READING_TO NUMBER

The effective meter reading of the runtime rule
EFFECTIVE_DATE_FROM DATE

The effective start date of the datetime rule
EFFECTIVE_DATE_TO DATE

The effective end date of the datetime rule
LIST_DATE DATE

Dates of a list date type PM
LIST_DATE_DESC VARCHAR2 (50)
List date description
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag
Query Text

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;

Dependencies

[top of page]

EAM.EAM_PM_SCHEDULING_RULES does not reference any database object

EAM.EAM_PM_SCHEDULING_RULES is referenced by following:

SchemaEAM
ViewEAM_PM_SCHEDULING_RULES#