VIEW: EAM.EAM_ORG_MAINT_DEFAULTS#

Source

View Text - Preformatted

select OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, ORGANIZATION_ID ORGANIZATION_ID, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE, AREA_ID AREA_ID, ACTIVITY_CAUSE_CODE ACTIVITY_CAUSE_CODE, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, ACTIVITY_SOURCE_CODE ACTIVITY_SOURCE_CODE, SHUTDOWN_TYPE_CODE SHUTDOWN_TYPE_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, TAGGING_REQUIRED_FLAG TAGGING_REQUIRED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WORK_ORDER_TYPE WORK_ORDER_TYPE, PLANNER_MAINTENANCE PLANNER_MAINTENANCE, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG, PLAN_MAINTENANCE PLAN_MAINTENANCE, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED from "EAM"."EAM_ORG_MAINT_DEFAULTS"

View Text - HTML Formatted

SELECT OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, AREA_ID AREA_ID
, ACTIVITY_CAUSE_CODE ACTIVITY_CAUSE_CODE
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, ACTIVITY_SOURCE_CODE ACTIVITY_SOURCE_CODE
, SHUTDOWN_TYPE_CODE SHUTDOWN_TYPE_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, TAGGING_REQUIRED_FLAG TAGGING_REQUIRED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WORK_ORDER_TYPE WORK_ORDER_TYPE
, PLANNER_MAINTENANCE PLANNER_MAINTENANCE
, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG
, PLAN_MAINTENANCE PLAN_MAINTENANCE
, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED
FROM "EAM"."EAM_ORG_MAINT_DEFAULTS"