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_ENTITIES_V

Object Details

Object Name:	WIP_EAM_ENTITIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_ENTITIES_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		Wip Entity Identifier
ORGANIZATION_ID	NUMBER		Organization Identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	Maintenance Work Order Name
DESCRIPTION	VARCHAR2	(240)	Maintenance Work Order Description
ENTITY_TYPE	NUMBER		Identifier for Work Order Type
ENTITY_TYPE_MEANING	VARCHAR2	(80)	Maintenance Work Order Type meaning
PRIMARY_ITEM_ID	NUMBER		Inventory Item Id for Asset Activity associated with the work order
ASSET_GROUP_ID	NUMBER		Inventory Item Identifier for Asset Group
ASSET_NUMBER	VARCHAR2	(30)	Asset Number
DEPARTMENT_CODE	VARCHAR2	(10)	Code for Owning Department of the Work Order
CLASS_CODE	VARCHAR2	(10)	Code for Accounting Class
BOM_REVISION	VARCHAR2	(3)	BOM Revision
STATUS_TYPE	NUMBER		Maintenance Work Order Status
STATUS_MEANING	VARCHAR2	(80)	Meaning of Work Order Status
PRIMARY_UOM_CODE	VARCHAR2	(3)	Primary Unit of Measure Code
DATE_CLOSED	DATE		Closing Date of the Work Order
LAST_UPDATE_DATE	DATE		Standard Who Columns
LAST_UPDATED_BY	NUMBER		Standard Who Columns
CREATION_DATE	DATE		Standard Who Columns
CREATED_BY	NUMBER		Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER		Standard Who Columns
REQUEST_ID	NUMBER		Standard Who Columns
PROGRAM_APPLICATION_ID	NUMBER		Standard Who Columns
PROGRAM_ID	NUMBER		Standard Who Columns
PROGRAM_UPDATE_DATE	DATE		Standard Who Columns
REBUILD_ITEM_ID	NUMBER		Inventory Item Identifier for Rebuild Item
REBUILD_SERIAL_NUMBER	VARCHAR2	(30)	Serial Number of the Serialized Rebuild Item
ESTIMATION_STATUS	NUMBER
ESTIMATION_STATUS_MEANING	VARCHAR2	(80)
ASSET_SERIAL_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_NAME
,      DESCRIPTION
,      ENTITY_TYPE
,      ENTITY_TYPE_MEANING
,      PRIMARY_ITEM_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      DEPARTMENT_CODE
,      CLASS_CODE
,      BOM_REVISION
,      STATUS_TYPE
,      STATUS_MEANING
,      PRIMARY_UOM_CODE
,      DATE_CLOSED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      ESTIMATION_STATUS
,      ESTIMATION_STATUS_MEANING
,      ASSET_SERIAL_NUMBER
FROM APPS.WIP_EAM_ENTITIES_V;

Dependencies

[top of page]

APPS.WIP_EAM_ENTITIES_V references the following:

APPS: BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; EAM_WORK_ORDER_DETAILS_V; FND_MESSAGE - show dependent code; MFG_LOOKUPS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_B_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.WIP_EAM_ENTITIES_V is not referenced by any database object