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.EAM_REBUILD_COMPLETION_JOBS_V

Object Details

Object Name:	EAM_REBUILD_COMPLETION_JOBS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_REBUILD_COMPLETION_JOBS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WORK_ORDER	VARCHAR2	(240)	Yes	Maintenance Work Order
DESCRIPTION	VARCHAR2	(240)		Maintenance Work Order Description
WIP_ENTITY_ID	NUMBER		Yes	Maintenance Work Order Identifier
REBUILD_ITEM_ID	NUMBER			Rebuildable Item Identifier
REBUILD_SERIAL_NUMBER	VARCHAR2	(30)		Rebuild Item Serial Number
SCHEDULED_START_DATE	DATE		Yes	Scheduled Start Date of the rebuild work order
SCHEDULED_COMPLETION_DATE	DATE		Yes	Scheduled End Date of the rebuild work order
REBUILD_ACTIVITY_ID	NUMBER			Asset Activity associated with the rebuild item
DURATION1	NUMBER			Duration of the work order
PARENT_WORK_ORDER	VARCHAR2	(240)		Parent Work Order that is associated with the rebuild work order
ASSET_NUMBER	VARCHAR2	(30)		Asset Number of the Parent Work Order
ASSET_GROUP_ID	NUMBER			Asset Group of the Parent Work Order
COMPLETION_SUBINVENTORY	VARCHAR2	(10)		Completion Subinventory for the repair and restock rebuild items
COMPLETION_LOCATOR_ID	NUMBER			Locator field for the Completion Subinventory for the repair and restock rebuild items
LOT_NUMBER	VARCHAR2	(80)		Lot field for the Completion Subinventory for the non repair and restock rebuild items
MANUAL_REBUILD_FLAG	VARCHAR2	(1)		Rebuild flag that specifies if the work order is for repair and reinstall or repair and restock
STATUS_TYPE	NUMBER		Yes	Status of the rebuild work order
PROJECT_ID	NUMBER			Project Identifier to the project that the work order belongs
TASK_ID	NUMBER			Task Identifier to the project that the work order belongs
PARENT_WIP_ENTITY_ID	NUMBER			Parent Maintenance Work Order Identifier of the rebuild work order
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
ACTIVITY_TYPE	VARCHAR2	(30)		Activity Type

Query Text

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


SELECT WORK_ORDER
,      DESCRIPTION
,      WIP_ENTITY_ID
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      REBUILD_ACTIVITY_ID
,      DURATION1
,      PARENT_WORK_ORDER
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      LOT_NUMBER
,      MANUAL_REBUILD_FLAG
,      STATUS_TYPE
,      PROJECT_ID
,      TASK_ID
,      PARENT_WIP_ENTITY_ID
,      ORGANIZATION_ID
,      ACTIVITY_TYPE
FROM APPS.EAM_REBUILD_COMPLETION_JOBS_V;

Dependencies

[top of page]

APPS.EAM_REBUILD_COMPLETION_JOBS_V references the following:

APPS: WIP_DISCRETE_JOBS; WIP_ENTITIES

APPS.EAM_REBUILD_COMPLETION_JOBS_V is not referenced by any database object