[Home] [Help] [Dependency Information]
Object Name: | EAM_PM_LAST_SERVICE |
---|---|
Object Type: | TABLE |
Owner: | EAM |
FND Design Data: | EAM.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EAM_PM_LAST_SERVICE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ACTIVITY_ASSOCIATION_ID
METER_ID |
EAM_PM_LAST_SERVICE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WIP_ENTITY_ID |
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 |
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;
EAM.EAM_PM_LAST_SERVICE does not reference any database object
EAM.EAM_PM_LAST_SERVICE is referenced by following:
|
|
|