VIEW: EAM.EAM_PM_SCHEDULINGS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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