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

TABLE: EAM.EAM_PM_LAST_SERVICE

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


This table stores the last service information for the combination of a meter and asset activity association. It stores the meter reading values during last service and the previous service, and the work order ID (wip_entity_id) of the services.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_PM_LAST_SERVICE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_ASSOCIATION_ID
ColumnMETER_ID
EAM_PM_LAST_SERVICE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
METER_ID NUMBER
Yes Meter Identifier
ACTIVITY_ASSOCIATION_ID NUMBER
Yes Asset Activitiy Association Identifier
LAST_SERVICE_READING NUMBER

Last service meter reading
PREV_SERVICE_READING NUMBER

Last service reading value is copied over here when a work order is completed
WIP_ENTITY_ID NUMBER

Work order identifier
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag
Query Text

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


SELECT METER_ID
,      ACTIVITY_ASSOCIATION_ID
,      LAST_SERVICE_READING
,      PREV_SERVICE_READING
,      WIP_ENTITY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MIGRATED_FLAG
FROM EAM.EAM_PM_LAST_SERVICE;

Dependencies

[top of page]

EAM.EAM_PM_LAST_SERVICE does not reference any database object

EAM.EAM_PM_LAST_SERVICE is referenced by following:

SchemaEAM
ViewEAM_PM_LAST_SERVICE#