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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: EAM.EAM_ORG_MAINT_DEFAULTS

Object Details

Object Name:	EAM_ORG_MAINT_DEFAULTS
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_ORG_MAINT_DEFAULTS
Subobject Name:
Status:	VALID

This table is used to store organization specific maintenance attributes for several type of maintenance objects. These attributes are defaulted into a newly created Work Order for the object. The maintenance objects for which these attributes could be stored are Maintenance Organization, Asset Category, Asset Group, Asset Group Activity Association, Asset Number and Asset Number Activity Association.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ORG_MAINT_DEFAULTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	OBJECT_ID OBJECT_TYPE ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	NUMBER		Yes	Object Type
OBJECT_ID	NUMBER		Yes	Object Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
OWNING_DEPARTMENT_ID	NUMBER			Owning Department
ACCOUNTING_CLASS_CODE	VARCHAR2	(10)		Maintenance Accounting Class Code
AREA_ID	NUMBER			Area
ACTIVITY_CAUSE_CODE	VARCHAR2	(30)		Activity Cause Code
ACTIVITY_TYPE_CODE	VARCHAR2	(30)		Activity Type Code
ACTIVITY_SOURCE_CODE	VARCHAR2	(30)		Activity Source Code
SHUTDOWN_TYPE_CODE	VARCHAR2	(30)		Shutdown Type
CREATED_BY	NUMBER			Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER			Last Updated By
TAGGING_REQUIRED_FLAG	VARCHAR2	(1)		Tagging Required
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
WORK_ORDER_TYPE	NUMBER			Work Order Type Code
PLANNER_MAINTENANCE	NUMBER			Planner Code
FIRM_PLANNED_FLAG	NUMBER	(1)		Firm Planned Flag
PLAN_MAINTENANCE	VARCHAR2	(1)		Planned Flag
NOTIFICATION_REQUIRED	VARCHAR2	(1)		Notification Required Flag

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

EAM.EAM_ORG_MAINT_DEFAULTS does not reference any database object

EAM.EAM_ORG_MAINT_DEFAULTS is referenced by following:

EAM: EAM_ORG_MAINT_DEFAULTS#