VIEW: INV.MTL_EAM_ASSET_ACTIVITIES#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, PRIORITY_CODE PRIORITY_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, ACTIVITY_CAUSE_CODE ACTIVITY_CAUSE_CODE, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, ACTIVITY_ASSOCIATION_ID ACTIVITY_ASSOCIATION_ID, TAGGING_REQUIRED_FLAG TAGGING_REQUIRED_FLAG, SHUTDOWN_TYPE_CODE SHUTDOWN_TYPE_CODE, CLASS_CODE CLASS_CODE, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, CREATION_ORGANIZATION_ID CREATION_ORGANIZATION_ID, TMPL_FLAG TMPL_FLAG, SOURCE_TMPL_ID SOURCE_TMPL_ID, ACTIVITY_SOURCE_CODE ACTIVITY_SOURCE_CODE, LAST_SERVICE_START_DATE LAST_SERVICE_START_DATE, LAST_SERVICE_END_DATE LAST_SERVICE_END_DATE, PREV_SERVICE_START_DATE PREV_SERVICE_START_DATE, PREV_SERVICE_END_DATE PREV_SERVICE_END_DATE, LAST_SCHEDULED_START_DATE LAST_SCHEDULED_START_DATE, LAST_SCHEDULED_END_DATE LAST_SCHEDULED_END_DATE, PREV_SCHEDULED_START_DATE PREV_SCHEDULED_START_DATE, PREV_SCHEDULED_END_DATE PREV_SCHEDULED_END_DATE, WIP_ENTITY_ID WIP_ENTITY_ID, LAST_PM_SUGGESTED_START_DATE LAST_PM_SUGGESTED_START_DATE, LAST_PM_SUGGESTED_END_DATE LAST_PM_SUGGESTED_END_DATE, PREV_PM_SUGGESTED_START_DATE PREV_PM_SUGGESTED_START_DATE, PREV_PM_SUGGESTED_END_DATE PREV_PM_SUGGESTED_END_DATE from "INV"."MTL_EAM_ASSET_ACTIVITIES"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, PRIORITY_CODE PRIORITY_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, ACTIVITY_CAUSE_CODE ACTIVITY_CAUSE_CODE
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, ACTIVITY_ASSOCIATION_ID ACTIVITY_ASSOCIATION_ID
, TAGGING_REQUIRED_FLAG TAGGING_REQUIRED_FLAG
, SHUTDOWN_TYPE_CODE SHUTDOWN_TYPE_CODE
, CLASS_CODE CLASS_CODE
, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, CREATION_ORGANIZATION_ID CREATION_ORGANIZATION_ID
, TMPL_FLAG TMPL_FLAG
, SOURCE_TMPL_ID SOURCE_TMPL_ID
, ACTIVITY_SOURCE_CODE ACTIVITY_SOURCE_CODE
, LAST_SERVICE_START_DATE LAST_SERVICE_START_DATE
, LAST_SERVICE_END_DATE LAST_SERVICE_END_DATE
, PREV_SERVICE_START_DATE PREV_SERVICE_START_DATE
, PREV_SERVICE_END_DATE PREV_SERVICE_END_DATE
, LAST_SCHEDULED_START_DATE LAST_SCHEDULED_START_DATE
, LAST_SCHEDULED_END_DATE LAST_SCHEDULED_END_DATE
, PREV_SCHEDULED_START_DATE PREV_SCHEDULED_START_DATE
, PREV_SCHEDULED_END_DATE PREV_SCHEDULED_END_DATE
, WIP_ENTITY_ID WIP_ENTITY_ID
, LAST_PM_SUGGESTED_START_DATE LAST_PM_SUGGESTED_START_DATE
, LAST_PM_SUGGESTED_END_DATE LAST_PM_SUGGESTED_END_DATE
, PREV_PM_SUGGESTED_START_DATE PREV_PM_SUGGESTED_START_DATE
, PREV_PM_SUGGESTED_END_DATE PREV_PM_SUGGESTED_END_DATE
FROM "INV"."MTL_EAM_ASSET_ACTIVITIES"