[Home] [Help] [Dependency Information]
Object Name: | EAM_PM_ACTIVITYGROUP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_PM_ACTIVITYGROUP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database Row Id | |
PM_SCHEDULE_ID | NUMBER | Yes | Identifier for this PM schedule | |
ACTIVITY_ASSOCIATION_ID | NUMBER | Yes | Identifier of the asset activity association for this PM schedule | |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Activity | |
MAINTENANCE_OBJECT_ID | NUMBER | Asset Instance Id | ||
MAINTENANCE_OBJECT_TYPE | NUMBER | Asset Type | ||
INTERVAL_MULTIPLE | NUMBER | Yes | Interval Multiple of Activity within the cycle | |
ALLOW_REPEAT_IN_CYCLE | VARCHAR2 | (1) | Yes | Flag indicates whether the activity can be repeated within the cycle |
DAY_TOLERANCE | NUMBER | Day Tolerance | ||
ASSET_ACTIVITY_ID | NUMBER | Yes | Activity Id | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PM_SCHEDULE_ID
, ACTIVITY_ASSOCIATION_ID
, CONCATENATED_SEGMENTS
, MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE
, INTERVAL_MULTIPLE
, ALLOW_REPEAT_IN_CYCLE
, DAY_TOLERANCE
, ASSET_ACTIVITY_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.EAM_PM_ACTIVITYGROUP_V;
APPS.EAM_PM_ACTIVITYGROUP_V is not referenced by any database object
|
|
|