eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EAM_PM_SCHEDULINGS_V

Product:	EAM - Enterprise Asset Management
Description:	View is used to access individual Preventive Maintenance schedules.
Implementation/DBA Data:	APPS.EAM_PM_SCHEDULINGS_V

View Text

SELECT PM.PM_SCHEDULE_ID
, PM.ACTIVITY_ASSOCIATION_ID
, EAA.ORGANIZATION_ID
, EAA.INVENTORY_ITEM_ID
, MSN.SERIAL_NUMBER
, MSN.DESCRIPTIVE_TEXT
, EAA.ASSET_ACTIVITY_ID
, PM.NON_SCHEDULED_FLAG
, PM.FROM_EFFECTIVE_DATE
, PM.TO_EFFECTIVE_DATE
, PM.RESCHEDULING_POINT
, PM.LEAD_TIME
, PM.DAY_TOLERANCE
, PM.CREATED_BY
, PM.CREATION_DATE
, PM.LAST_UPDATE_LOGIN
, PM.LAST_UPDATE_DATE
, PM.LAST_UPDATED_BY
, PM.ATTRIBUTE_CATEGORY
, PM.ATTRIBUTE1
, PM.ATTRIBUTE2
, PM.ATTRIBUTE3
, PM.ATTRIBUTE4
, PM.ATTRIBUTE5
, PM.ATTRIBUTE6
, PM.ATTRIBUTE7
, PM.ATTRIBUTE8
, PM.ATTRIBUTE9
, PM.ATTRIBUTE10
, PM.ATTRIBUTE11
, PM.ATTRIBUTE12
, PM.ATTRIBUTE13
, PM.ATTRIBUTE14
, PM.ATTRIBUTE15
, PM.SOURCE_CODE
, PM.SOURCE_LINE
, PM.DEFAULT_IMPLEMENT
, PM.WHICHEVER_FIRST
, PM.INCLUDE_MANUAL
, PM.SET_NAME_ID
, EPSN.SET_NAME
, MSN.INVENTORY_ITEM_ID
, PM.SCHEDULING_METHOD_CODE
, PM.TYPE_CODE
, PM.SOURCE_TMPL_ID
, PM.AUTO_INSTANTIATION_FLAG
, PM.NAME
, EAA.TMPL_FLAG
, EAA.MAINTENANCE_OBJECT_ID
, EAA.MAINTENANCE_OBJECT_TYPE
, MSI.EAM_ITEM_TYPE
FROM EAM_PM_SCHEDULINGS PM
, MTL_EAM_ASSET_ACTIVITIES EAA
, MTL_SERIAL_NUMBERS MSN
, MTL_SYSTEM_ITEMS MSI
, EAM.EAM_PM_SET_NAMES EPSN
WHERE NVL(EAA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(EAA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(EAA.TMPL_FLAG
, 'N') = 'N'
AND PM.ACTIVITY_ASSOCIATION_ID = EAA.ACTIVITY_ASSOCIATION_ID
AND PM.SET_NAME_ID = EPSN.SET_NAME_ID
AND MSN.MAINTAINABLE_FLAG = 'Y'
AND MSN.CURRENT_STATUS = 3
AND EAA.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID
AND EAA.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
AND EAA.SERIAL_NUMBER = MSN.SERIAL_NUMBER
AND EAA.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID UNION SELECT PM.PM_SCHEDULE_ID
, PM.ACTIVITY_ASSOCIATION_ID
, EAA.ORGANIZATION_ID
, EAA.INVENTORY_ITEM_ID
, NULL
, NULL
, EAA.ASSET_ACTIVITY_ID
, PM.NON_SCHEDULED_FLAG
, PM.FROM_EFFECTIVE_DATE
, PM.TO_EFFECTIVE_DATE
, PM.RESCHEDULING_POINT
, PM.LEAD_TIME
, PM.DAY_TOLERANCE
, PM.CREATED_BY
, PM.CREATION_DATE
, PM.LAST_UPDATE_LOGIN
, PM.LAST_UPDATE_DATE
, PM.LAST_UPDATED_BY
, PM.ATTRIBUTE_CATEGORY
, PM.ATTRIBUTE1
, PM.ATTRIBUTE2
, PM.ATTRIBUTE3
, PM.ATTRIBUTE4
, PM.ATTRIBUTE5
, PM.ATTRIBUTE6
, PM.ATTRIBUTE7
, PM.ATTRIBUTE8
, PM.ATTRIBUTE9
, PM.ATTRIBUTE10
, PM.ATTRIBUTE11
, PM.ATTRIBUTE12
, PM.ATTRIBUTE13
, PM.ATTRIBUTE14
, PM.ATTRIBUTE15
, PM.SOURCE_CODE
, PM.SOURCE_LINE
, PM.DEFAULT_IMPLEMENT
, PM.WHICHEVER_FIRST
, PM.INCLUDE_MANUAL
, PM.SET_NAME_ID
, EPSN.SET_NAME
, EAA.INVENTORY_ITEM_ID
, PM.SCHEDULING_METHOD_CODE
, PM.TYPE_CODE
, PM.SOURCE_TMPL_ID
, PM.AUTO_INSTANTIATION_FLAG
, PM.NAME
, EAA.TMPL_FLAG
, EAA.MAINTENANCE_OBJECT_ID
, EAA.MAINTENANCE_OBJECT_TYPE
, MSIK.EAM_ITEM_TYPE
FROM EAM_PM_SCHEDULINGS PM
, MTL_EAM_ASSET_ACTIVITIES EAA
, EAM.EAM_PM_SET_NAMES EPSN
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE NVL(EAA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(EAA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND EAA.TMPL_FLAG = 'Y'
AND PM.ACTIVITY_ASSOCIATION_ID = EAA.ACTIVITY_ASSOCIATION_ID
AND PM.SET_NAME_ID = EPSN.SET_NAME_ID
AND EAA.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID UNION SELECT PM.PM_SCHEDULE_ID
, PM.ACTIVITY_ASSOCIATION_ID
, EAA.ORGANIZATION_ID
, EAA.INVENTORY_ITEM_ID
, NULL
, NULL
, EAA.ASSET_ACTIVITY_ID
, PM.NON_SCHEDULED_FLAG
, PM.FROM_EFFECTIVE_DATE
, PM.TO_EFFECTIVE_DATE
, PM.RESCHEDULING_POINT
, PM.LEAD_TIME
, PM.DAY_TOLERANCE
, PM.CREATED_BY
, PM.CREATION_DATE
, PM.LAST_UPDATE_LOGIN
, PM.LAST_UPDATE_DATE
, PM.LAST_UPDATED_BY
, PM.ATTRIBUTE_CATEGORY
, PM.ATTRIBUTE1
, PM.ATTRIBUTE2
, PM.ATTRIBUTE3
, PM.ATTRIBUTE4
, PM.ATTRIBUTE5
, PM.ATTRIBUTE6
, PM.ATTRIBUTE7
, PM.ATTRIBUTE8
, PM.ATTRIBUTE9
, PM.ATTRIBUTE10
, PM.ATTRIBUTE11
, PM.ATTRIBUTE12
, PM.ATTRIBUTE13
, PM.ATTRIBUTE14
, PM.ATTRIBUTE15
, PM.SOURCE_CODE
, PM.SOURCE_LINE
, PM.DEFAULT_IMPLEMENT
, PM.WHICHEVER_FIRST
, PM.INCLUDE_MANUAL
, PM.SET_NAME_ID
, EPSN.SET_NAME
, EAA.INVENTORY_ITEM_ID
, PM.SCHEDULING_METHOD_CODE
, PM.TYPE_CODE
, PM.SOURCE_TMPL_ID
, PM.AUTO_INSTANTIATION_FLAG
, PM.NAME
, EAA.TMPL_FLAG
, EAA.MAINTENANCE_OBJECT_ID
, EAA.MAINTENANCE_OBJECT_TYPE
, MSIK.EAM_ITEM_TYPE
FROM EAM_PM_SCHEDULINGS PM
, MTL_EAM_ASSET_ACTIVITIES EAA
, EAM.EAM_PM_SET_NAMES EPSN
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE NVL(EAA.START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(EAA.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(EAA.TMPL_FLAG
, 'N') = 'N'
AND PM.ACTIVITY_ASSOCIATION_ID = EAA.ACTIVITY_ASSOCIATION_ID
AND PM.SET_NAME_ID = EPSN.SET_NAME_ID
AND EAA.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MSIK.EAM_ITEM_TYPE = 3
AND MSIK.SERIAL_NUMBER_CONTROL_CODE = 1

Columns

Name
PM_SCHEDULE_ID
ACTIVITY_ASSOCIATION_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
ASSET_NUMBER
DESCRIPTIVE_TEXT
ASSET_ACTIVITY_ID
NON_SCHEDULED_FLAG
FROM_EFFECTIVE_DATE
TO_EFFECTIVE_DATE
RESCHEDULING_POINT
LEAD_TIME
DAY_TOLERANCE
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
PM_SOURCE_CODE
PM_SOURCE_LINE
DEFAULT_IMPLEMENT
WHICHEVER_FIRST
INCLUDE_MANUAL
SET_NAME_ID
SET_NAME
ASSET_GROUP_ID
SCHEDULING_METHOD_CODE
TYPE_CODE
SOURCE_TMPL_ID
AUTO_INSTANTIATION_FLAG
NAME
TMPL_FLAG
MAINTENANCE_OBJECT_ID
MAINTENANCE_OBJECT_TYPE
EAM_ITEM_TYPE