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

TABLE: EAM.EAM_PM_SCHEDULINGS

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


This tables stores the details of all user defined Preventive Maintenance schedules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_PM_SCHEDULINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPM_SCHEDULE_ID
EAM_PM_SCHEDULINGS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
EAM_PM_SCHEDULINGS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAINTENANCE_OBJECT_ID
ColumnSET_NAME_ID
Columns
Name Datatype Length Mandatory Comments
PM_SCHEDULE_ID NUMBER
Yes Preventive Maintenance Schedule Identifier
ACTIVITY_ASSOCIATION_ID NUMBER

No longer used
NON_SCHEDULED_FLAG VARCHAR2 (1)
Run to Failure
FROM_EFFECTIVE_DATE DATE

Effective start date
TO_EFFECTIVE_DATE DATE

Effective end date
RESCHEDULING_POINT NUMBER
Yes Rescheduling Point
LEAD_TIME NUMBER

Lead Time
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
NAME VARCHAR2 (50)
Name of a PM schedule
TMPL_FLAG VARCHAR2 (1)
Flag indicating a PM template or PM instance
SOURCE_TMPL_ID NUMBER

PM template that the PM instance is created from
AUTO_INSTANTIATION_FLAG VARCHAR2 (1)
Flag indicating whether a PM template will be automatically instantiated
SOURCE_CODE VARCHAR2 (30)
Application that the PM is created in
SOURCE_LINE VARCHAR2 (30)
Source that PM is created from.
NEXT_SERVICE_START_DATE DATE

Next service start date of the activity predicted by PM
NEXT_SERVICE_END_DATE DATE

Next service end date of the activity predicted by PM
SET_NAME_ID NUMBER

Set name identifier
TYPE_CODE NUMBER

PM types: 'Rule Based', 'List Dates'
SCHEDULING_METHOD_CODE NUMBER

Scheduling Method: 'Forward' or 'Backward'
WHICHEVER_FIRST VARCHAR2 (1)
Whichever first or later
INCLUDE_MANUAL VARCHAR2 (1)
Whether rescheduling manual work orders or not
DAY_TOLERANCE NUMBER

How many days can the planned activity be delayed? This information is used in suppression.
DEFAULT_IMPLEMENT VARCHAR2 (1)
Default PM
GENERATE_WO_STATUS NUMBER

Generate Work order status identifier which indicates in which status work order has to be created based on PM schedule.
INTERVAL_PER_CYCLE NUMBER

This will store the number in which the cycle will be divided
CURRENT_CYCLE NUMBER

This will store the Current Cycle based on which the PM Schedule will be defined
CURRENT_SEQ NUMBER

This will store the current sequence within a cycle and will be used for resequencing of work orders
CURRENT_WO_SEQ NUMBER

This will store the previous work order sequence.
BASE_DATE DATE

This will store the Base Date from which the PM engine has to generate the Work Orders.
BASE_READING NUMBER

This will store the Base Reading from which the PM engine has to generate the Work Orders.
EAM_LAST_CYCLIC_ACT NUMBER

This will store the last cyclical activity performed for that PM Schedule.
MAINTENANCE_OBJECT_ID NUMBER

Object Id
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
GENERATE_NEXT_WORK_ORDER VARCHAR2 (1)
Flag indicating next work order generation
LAST_REVIEWED_BY NUMBER

PM Last Reviewed By
LAST_REVIEWED_DATE DATE

PM Last Reviewed Date
PLANNER_MAINTENANCE NUMBER

holds planner lookup code that gets defaulted to generated PM WO
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PM_SCHEDULE_ID
,      ACTIVITY_ASSOCIATION_ID
,      NON_SCHEDULED_FLAG
,      FROM_EFFECTIVE_DATE
,      TO_EFFECTIVE_DATE
,      RESCHEDULING_POINT
,      LEAD_TIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      NAME
,      TMPL_FLAG
,      SOURCE_TMPL_ID
,      AUTO_INSTANTIATION_FLAG
,      SOURCE_CODE
,      SOURCE_LINE
,      NEXT_SERVICE_START_DATE
,      NEXT_SERVICE_END_DATE
,      SET_NAME_ID
,      TYPE_CODE
,      SCHEDULING_METHOD_CODE
,      WHICHEVER_FIRST
,      INCLUDE_MANUAL
,      DAY_TOLERANCE
,      DEFAULT_IMPLEMENT
,      GENERATE_WO_STATUS
,      INTERVAL_PER_CYCLE
,      CURRENT_CYCLE
,      CURRENT_SEQ
,      CURRENT_WO_SEQ
,      BASE_DATE
,      BASE_READING
,      EAM_LAST_CYCLIC_ACT
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      GENERATE_NEXT_WORK_ORDER
,      LAST_REVIEWED_BY
,      LAST_REVIEWED_DATE
,      PLANNER_MAINTENANCE
FROM EAM.EAM_PM_SCHEDULINGS;

Dependencies

[top of page]

EAM.EAM_PM_SCHEDULINGS does not reference any database object

EAM.EAM_PM_SCHEDULINGS is referenced by following:

SchemaEAM
ViewEAM_PM_SCHEDULINGS#