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]

VIEW: APPS.WIP_EAM_WORK_ORDER_DTLS_V

Object Details

Object Name:	WIP_EAM_WORK_ORDER_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_WORK_ORDER_DTLS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
WIP_ENTITY_ID	NUMBER		Maintenance Work Order Identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	Name of the Maintenance Work Order
ORGANIZATION_ID	NUMBER		Organization identifier
ASSET_NUMBER	VARCHAR2	(30)	Asset Number in the Asset Group
ASSET_DESCRIPTION	VARCHAR2	(240)	Description field for the Asset Number
ASSET_GROUP_ID	NUMBER		Asset Group Identifier where the Asset Number belongs
ASSET_GROUP	VARCHAR2	(40)	Asset Group where the Asset Number belongs
ASSET_ACTIVITY_ID	NUMBER		Asset activity identifier
ASSET_ACTIVITY	VARCHAR2	(40)	Asset Activity
ASSET_CATEGORY_ID	NUMBER		Asset Category Identifier
ASSET_CATEGORY	VARCHAR2	(163)	Asset category
ASSET_LOCATION_ID	NUMBER		Identifier for the asset area
ASSET_LOCATION	VARCHAR2	(30)	Asset Area
ASSET_OWNING_DEPARTMENT_ID	NUMBER		Owning dept identifier of the asset
ASSET_OWNING_DEPARTMENT	VARCHAR2	(10)	Owning dept of the asset
STATUS_TYPE	NUMBER		Maintenance Work Order Status Type
STATUS	VARCHAR2	(80)	Maintenance Work Order Status
WORK_ORDER_TYPE	VARCHAR2	(30)	Maintenance Work Order Type
DESCRIPTION	VARCHAR2	(240)	Maintenance Work Order Description
PRIORITY	NUMBER		Priority Maintenance Work Order
START_DATE	DATE		Start Date of the Maintenance Work Order
COMPLETION_DATE	DATE		Completion Date of the Maintenance Work Order
ACTIVITY_TYPE	VARCHAR2	(30)	Type of Maintenance Activity that is performed
ACTIVITY_CAUSE	VARCHAR2	(30)	Cause of Maintenance Activity
ACTIVITY_SOURCE	VARCHAR2	(30)	Source of the Maintenance Activity
OWNING_DEPARTMENT_ID	NUMBER		Owning dept identifier of the Maintenance Work Order
OWNING_DEPARTMENT	VARCHAR2	(10)	Owning dept of the Maintenance Work Order
CLASS_CODE	VARCHAR2	(10)	Accounting class associated with the Work Order
REQUESTED_START_DATE	DATE		Requested Start Date of the Maintenance Work Order as specified by the scheduler
NOTIFICATION_REQUIRED	VARCHAR2	(1)	Maintenance Work Order Notification
SHUTDOWN_TYPE	VARCHAR2	(30)	Asset shutdown type
TAGOUT_REQUIRED	VARCHAR2	(1)	Tagout Required Flag
PLAN_MAINTENANCE	VARCHAR2	(1)	Planned maintenance flag
PARENT_WIP_ENTITY_ID	NUMBER		Parent Maintenance Work Order WIP entity id
PARENT_WIP_ENTITY_NAME	VARCHAR2	(240)	Parent Maintenance Work Order WIP entity name
REBUILD_ITEM_ID	NUMBER		Rebuildable item id for which the Maintenace Work Order exists
REBUILD_SERIAL_NUMBER	VARCHAR2	(30)	Rebuildable item serial number for which the Maintenace Work Order exists
CHARGE_ASSET_GROUP	VARCHAR2	(40)	Asset Group that is charged for the Maintenance Work Order
CHARGE_ASSET_NUMBER	VARCHAR2	(4000)	Asset Number that is charged for the Maintenance Work Order
REBUILD_ACTIVITY	VARCHAR2	(40)	Rebuild activity associated with the rebuild item work order
MANUAL_REBUILD_FLAG	VARCHAR2	(1)	Manual Flag for the Rebuild Work Order
LAST_UPDATE_DATE	DATE		Standard Who Column
REBUILD_ITEM	VARCHAR2	(40)	Rebuildable item for which the Maintenace Work Order exists
PROJECT_ID	NUMBER		Project Id for which the Maintenace Work Order exists
TASK_ID	NUMBER		Task Id for which the Maintenace Work Order exists
MATERIAL_ISSUE_BY_MO	VARCHAR2	(1)
EAM_LINEAR_LOCATION_ID	NUMBER		Linear Asset Location Identifier
MAINTENANCE_OBJECT_TYPE	NUMBER
MAINTENANCE_OBJECT_ID	NUMBER
ASSET_SERIAL_NUMBER	VARCHAR2	(30)	serial number
WARRANTY_EXPN_DATE	DATE		Warranty Expiration Date of asset
NETWORK_ASSET_FLAG	VARCHAR2	(1)	Flag indicating if asset is asset route or not

Query Text

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


SELECT WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ORGANIZATION_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      ASSET_GROUP_ID
,      ASSET_GROUP
,      ASSET_ACTIVITY_ID
,      ASSET_ACTIVITY
,      ASSET_CATEGORY_ID
,      ASSET_CATEGORY
,      ASSET_LOCATION_ID
,      ASSET_LOCATION
,      ASSET_OWNING_DEPARTMENT_ID
,      ASSET_OWNING_DEPARTMENT
,      STATUS_TYPE
,      STATUS
,      WORK_ORDER_TYPE
,      DESCRIPTION
,      PRIORITY
,      START_DATE
,      COMPLETION_DATE
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      ACTIVITY_SOURCE
,      OWNING_DEPARTMENT_ID
,      OWNING_DEPARTMENT
,      CLASS_CODE
,      REQUESTED_START_DATE
,      NOTIFICATION_REQUIRED
,      SHUTDOWN_TYPE
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      PARENT_WIP_ENTITY_ID
,      PARENT_WIP_ENTITY_NAME
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      CHARGE_ASSET_GROUP
,      CHARGE_ASSET_NUMBER
,      REBUILD_ACTIVITY
,      MANUAL_REBUILD_FLAG
,      LAST_UPDATE_DATE
,      REBUILD_ITEM
,      PROJECT_ID
,      TASK_ID
,      MATERIAL_ISSUE_BY_MO
,      EAM_LINEAR_LOCATION_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      ASSET_SERIAL_NUMBER
,      WARRANTY_EXPN_DATE
,      NETWORK_ASSET_FLAG
FROM APPS.WIP_EAM_WORK_ORDER_DTLS_V;

Dependencies

[top of page]

APPS.WIP_EAM_WORK_ORDER_DTLS_V references the following:

APPS: BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; EAM_COMMON_UTILITIES_PVT - show dependent code; EAM_ORG_MAINT_DEFAULTS; MFG_LOOKUPS; MTL_CATEGORIES_KFV; MTL_EAM_LOCATIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.WIP_EAM_WORK_ORDER_DTLS_V is not referenced by any database object