DBA Data[Home] [Help]

VIEW: EAM.EAM_PM_ACTIVITIES#

Source

View Text - Preformatted

select ACTIVITY_ASSOCIATION_ID ACTIVITY_ASSOCIATION_ID, PM_SCHEDULE_ID PM_SCHEDULE_ID, INTERVAL_MULTIPLE INTERVAL_MULTIPLE, ALLOW_REPEAT_IN_CYCLE ALLOW_REPEAT_IN_CYCLE, DAY_TOLERANCE DAY_TOLERANCE, NEXT_SERVICE_START_DATE NEXT_SERVICE_START_DATE, NEXT_SERVICE_END_DATE NEXT_SERVICE_END_DATE, 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 from "EAM"."EAM_PM_ACTIVITIES"
View Text - HTML Formatted

SELECT ACTIVITY_ASSOCIATION_ID ACTIVITY_ASSOCIATION_ID
, PM_SCHEDULE_ID PM_SCHEDULE_ID
, INTERVAL_MULTIPLE INTERVAL_MULTIPLE
, ALLOW_REPEAT_IN_CYCLE ALLOW_REPEAT_IN_CYCLE
, DAY_TOLERANCE DAY_TOLERANCE
, NEXT_SERVICE_START_DATE NEXT_SERVICE_START_DATE
, NEXT_SERVICE_END_DATE NEXT_SERVICE_END_DATE
, 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
FROM "EAM"."EAM_PM_ACTIVITIES"