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: EAM.EAM_CE_WORK_ORDER_LINES#

Object Details

Object Name:	EAM_CE_WORK_ORDER_LINES#
Object Type:	VIEW
Owner:	EAM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ESTIMATE_WORK_ORDER_LINE_ID	NUMBER		Yes
ESTIMATE_WORK_ORDER_ID	NUMBER
SRC_CU_ID	NUMBER
SRC_ACTIVITY_ID	NUMBER
SRC_ACTIVITY_QTY	NUMBER
SRC_OP_SEQ_NUM	NUMBER
SRC_ACCT_CLASS_CODE	VARCHAR2	(10)
ESTIMATE_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
WORK_ORDER_SEQ_NUM	NUMBER
WORK_ORDER_NUMBER	VARCHAR2	(30)
WORK_ORDER_DESCRIPTION	VARCHAR2	(240)
REF_WIP_ENTITY_ID	NUMBER
PRIMARY_ITEM_ID	NUMBER
STATUS_TYPE	NUMBER
ACCT_CLASS_CODE	VARCHAR2	(10)
SCHEDULED_START_DATE	DATE		Yes
SCHEDULED_COMPLETION_DATE	DATE
PROJECT_ID	NUMBER
TASK_ID	NUMBER
MAINTENANCE_OBJECT_ID	NUMBER
MAINTENANCE_OBJECT_TYPE	NUMBER
MAINTENANCE_OBJECT_SOURCE	NUMBER
OWNING_DEPARTMENT_ID	NUMBER
USER_DEFINED_STATUS_ID	NUMBER
OP_SEQ_NUM	NUMBER
OP_DESCRIPTION	VARCHAR2	(240)
STANDARD_OPERATION_ID	NUMBER
OP_DEPARTMENT_ID	NUMBER
OP_LONG_DESCRIPTION	VARCHAR2	(4000)
RES_SEQ_NUM	NUMBER
RES_ID	NUMBER
RES_UOM	VARCHAR2	(3)
RES_BASIS_TYPE	NUMBER
RES_USAGE_RATE_OR_AMOUNT	NUMBER
RES_REQUIRED_UNITS	NUMBER
RES_ASSIGNED_UNITS	NUMBER
ITEM_TYPE	NUMBER
REQUIRED_QUANTITY	NUMBER
UNIT_PRICE	NUMBER
UOM	VARCHAR2	(3)
BASIS_TYPE	NUMBER
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)
SUGGESTED_VENDOR_ID	NUMBER
SUGGESTED_VENDOR_SITE	VARCHAR2	(15)
SUGGESTED_VENDOR_SITE_ID	NUMBER
MAT_INVENTORY_ITEM_ID	NUMBER
MAT_COMPONENT_SEQ_NUM	NUMBER
MAT_SUPPLY_SUBINVENTORY	VARCHAR2	(10)
MAT_SUPPLY_LOCATOR_ID	NUMBER
DI_AMOUNT	NUMBER
DI_ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
DI_DESCRIPTION	VARCHAR2	(240)
DI_PURCHASE_CATEGORY_ID	NUMBER
DI_AUTO_REQUEST_MATERIAL	VARCHAR2	(1)
DI_NEED_BY_DATE	DATE
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
WORK_ORDER_TYPE	NUMBER
ACTIVITY_TYPE	NUMBER
ACTIVITY_CAUSE	NUMBER
ACTIVITY_SOURCE	NUMBER
AVAILABLE_QUANTITY	NUMBER
ITEM_COMMENTS	VARCHAR2	(240)
CU_QTY	NUMBER
DIFFICULTY_QTY	NUMBER
SRC_DIFFICULTY_ID	NUMBER
WO_LINE_PER_UNIT_COST	NUMBER
RES_SCHEDULED_FLAG	NUMBER

Query Text

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


SELECT ESTIMATE_WORK_ORDER_LINE_ID
,      ESTIMATE_WORK_ORDER_ID
,      SRC_CU_ID
,      SRC_ACTIVITY_ID
,      SRC_ACTIVITY_QTY
,      SRC_OP_SEQ_NUM
,      SRC_ACCT_CLASS_CODE
,      ESTIMATE_ID
,      ORGANIZATION_ID
,      WORK_ORDER_SEQ_NUM
,      WORK_ORDER_NUMBER
,      WORK_ORDER_DESCRIPTION
,      REF_WIP_ENTITY_ID
,      PRIMARY_ITEM_ID
,      STATUS_TYPE
,      ACCT_CLASS_CODE
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      PROJECT_ID
,      TASK_ID
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      OWNING_DEPARTMENT_ID
,      USER_DEFINED_STATUS_ID
,      OP_SEQ_NUM
,      OP_DESCRIPTION
,      STANDARD_OPERATION_ID
,      OP_DEPARTMENT_ID
,      OP_LONG_DESCRIPTION
,      RES_SEQ_NUM
,      RES_ID
,      RES_UOM
,      RES_BASIS_TYPE
,      RES_USAGE_RATE_OR_AMOUNT
,      RES_REQUIRED_UNITS
,      RES_ASSIGNED_UNITS
,      ITEM_TYPE
,      REQUIRED_QUANTITY
,      UNIT_PRICE
,      UOM
,      BASIS_TYPE
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_ID
,      SUGGESTED_VENDOR_SITE
,      SUGGESTED_VENDOR_SITE_ID
,      MAT_INVENTORY_ITEM_ID
,      MAT_COMPONENT_SEQ_NUM
,      MAT_SUPPLY_SUBINVENTORY
,      MAT_SUPPLY_LOCATOR_ID
,      DI_AMOUNT
,      DI_ORDER_TYPE_LOOKUP_CODE
,      DI_DESCRIPTION
,      DI_PURCHASE_CATEGORY_ID
,      DI_AUTO_REQUEST_MATERIAL
,      DI_NEED_BY_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      WORK_ORDER_TYPE
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      ACTIVITY_SOURCE
,      AVAILABLE_QUANTITY
,      ITEM_COMMENTS
,      CU_QTY
,      DIFFICULTY_QTY
,      SRC_DIFFICULTY_ID
,      WO_LINE_PER_UNIT_COST
,      RES_SCHEDULED_FLAG
FROM EAM.EAM_CE_WORK_ORDER_LINES#;

Dependencies

[top of page]

EAM.EAM_CE_WORK_ORDER_LINES# references the following:

EAM: EAM_CE_WORK_ORDER_LINES

EAM.EAM_CE_WORK_ORDER_LINES# is referenced by following:

APPS: EAM_CE_WORK_ORDER_LINES