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_CST_HEADER_V

Object Details

Object Name:	WIP_EAM_CST_HEADER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_CST_HEADER_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	Comments
WIP_ENTITY_ID	NUMBER		Work order identifier
ORGANIZATION_ID	NUMBER		Organization identifier
STATUS_TYPE	NUMBER		Job status identifier
JOB_STATUS	VARCHAR2	(80)	Job status
PRIMARY_ITEM_ID	NUMBER		Inventory item identifier for the asset against which the work order has been created
SCHEDULED_COMPLETION_DATE	DATE		Scheduled completion date of work order
ASSET_GROUP_ID	NUMBER		Asset group identifier
ASSET_NUMBER	VARCHAR2	(30)	Asset number
ESTIMATION_STATUS	VARCHAR2	(80)	Cost estimation status of the work order
OWNING_DEPARTMENT	VARCHAR2	(10)	Owning department of the job
REBUILD_ITEM_ID	NUMBER		Inventory item identifier for a rebuild item
REBUILD_SERIAL_NUMBER	VARCHAR2	(30)	Serial number for a rebuild item
PARENT_WIP_ENTITY_NAME	VARCHAR2	(240)	Parent work order name for a rebuild work order
LAST_ESTIMATION_REQ_ID	NUMBER		Last estimation request identifier
LAST_ESTIMATION_DATE	DATE		Last esitmation date
ESTIMATION_STATUS_NO	NUMBER		Estimation status identifier
ASSET_SERIAL_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      STATUS_TYPE
,      JOB_STATUS
,      PRIMARY_ITEM_ID
,      SCHEDULED_COMPLETION_DATE
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      ESTIMATION_STATUS
,      OWNING_DEPARTMENT
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      PARENT_WIP_ENTITY_NAME
,      LAST_ESTIMATION_REQ_ID
,      LAST_ESTIMATION_DATE
,      ESTIMATION_STATUS_NO
,      ASSET_SERIAL_NUMBER
FROM APPS.WIP_EAM_CST_HEADER_V;

Dependencies

[top of page]

APPS.WIP_EAM_CST_HEADER_V references the following:

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

APPS.WIP_EAM_CST_HEADER_V is not referenced by any database object