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]

TABLE: EAM.EAM_CE_WORK_ORDER_LINES

Object Details

Object Name:	EAM_CE_WORK_ORDER_LINES
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_CE_WORK_ORDER_LINES
Subobject Name:
Status:	VALID

* This table contains consolidated work order lines for the estimate. The work order line can be a resource or material line depending upon the values
populated in res_id or mat_inventory_item_id.
*
* - The estimate work order lines, if estimated will also contain per line
cost.
* - If estimate has been converted to work orders, the ESTIMATE_WORK_ORDER_ID column will contain reference to the wip_entity_id of the work order

* - The work order, if created from construction unit/acvitity, will have reference to the source construction unit (src_cu_id) and/or source activity (src_activity_id)
* - The work_order_Seq_num determines the grouping of work orders within an estimate

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_CE_WORK_ORDER_LINES_U01	NORMAL	UNIQUE	APPS_TS_TX_IDX	ESTIMATE_WORK_ORDER_LINE_ID
EAM_CE_WORK_ORDER_LINES_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID ESTIMATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ESTIMATE_WORK_ORDER_LINE_ID	NUMBER		Yes	Generated primary key for the work order line
ESTIMATE_WORK_ORDER_ID	NUMBER			Created estimate work order ID
SRC_CU_ID	NUMBER			Source construction unit ID
SRC_ACTIVITY_ID	NUMBER			Source activity ID
SRC_ACTIVITY_QTY	NUMBER			Source activity quantity
SRC_OP_SEQ_NUM	NUMBER			Source operation sequence number
SRC_ACCT_CLASS_CODE	VARCHAR2	(10)		Source Accouting Class Code
ESTIMATE_ID	NUMBER		Yes	Associated construction estimate ID
ORGANIZATION_ID	NUMBER		Yes	Associated organization ID
WORK_ORDER_SEQ_NUM	NUMBER			Indicate the work order sequence for a estimate
WORK_ORDER_NUMBER	VARCHAR2	(30)		Estimate work order name
WORK_ORDER_DESCRIPTION	VARCHAR2	(240)		Estimate work order description
REF_WIP_ENTITY_ID	NUMBER			WIP entity ID of the work order created
PRIMARY_ITEM_ID	NUMBER			Primary Item ID
STATUS_TYPE	NUMBER			Status of the estimate work order
ACCT_CLASS_CODE	VARCHAR2	(10)		WIP accounting class code
SCHEDULED_START_DATE	DATE		Yes	Scheduled start date of the work order
SCHEDULED_COMPLETION_DATE	DATE			Scheduled end date of the work order
PROJECT_ID	NUMBER			Project ID associated to the work order
TASK_ID	NUMBER			Project task ID associated with the work order
MAINTENANCE_OBJECT_ID	NUMBER			Maintenance object ID
MAINTENANCE_OBJECT_TYPE	NUMBER			Maintenance object type
MAINTENANCE_OBJECT_SOURCE	NUMBER			Maintenance object source
OWNING_DEPARTMENT_ID	NUMBER			Work order owning department ID
USER_DEFINED_STATUS_ID	NUMBER			User defined work order status
OP_SEQ_NUM	NUMBER			Operation sequence number
OP_DESCRIPTION	VARCHAR2	(240)		Operation description
STANDARD_OPERATION_ID	NUMBER			Standard operation ID
OP_DEPARTMENT_ID	NUMBER			Operation department ID
OP_LONG_DESCRIPTION	VARCHAR2	(4000)		Long operation description
RES_SEQ_NUM	NUMBER			Resource sequence number
RES_ID	NUMBER			Resource sequence ID
RES_UOM	VARCHAR2	(3)		Unit of measure for the resource
RES_BASIS_TYPE	NUMBER			Basis type for the resource
RES_USAGE_RATE_OR_AMOUNT	NUMBER			Usage rate for the resource
RES_REQUIRED_UNITS	NUMBER			Required units of the resource
RES_ASSIGNED_UNITS	NUMBER			Assigned units of the resource
ITEM_TYPE	NUMBER			Item type, such as stocked inventory, non-stock direct and description direct
REQUIRED_QUANTITY	NUMBER			Required quantity, for any item type
UNIT_PRICE	NUMBER			Unit price, for any item type
UOM	VARCHAR2	(3)		Unit of measure, for any item type
BASIS_TYPE	NUMBER			Basis type, for any item type
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vendor Name, for any item type
SUGGESTED_VENDOR_ID	NUMBER			Suggested vendor ID, for any item type
SUGGESTED_VENDOR_SITE	VARCHAR2	(15)		Suggested vendor site name, for any item type
SUGGESTED_VENDOR_SITE_ID	NUMBER			Suggested vendor site ID, for any item type
MAT_INVENTORY_ITEM_ID	NUMBER			Material inventory item id
MAT_COMPONENT_SEQ_NUM	NUMBER			BOM component sequence number for the material
MAT_SUPPLY_SUBINVENTORY	VARCHAR2	(10)		Supply subinventory for the material
MAT_SUPPLY_LOCATOR_ID	NUMBER			Supply locator ID for the material
DI_AMOUNT	NUMBER			The amount for the direct item
DI_ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)		The order type code for the direct item
DI_DESCRIPTION	VARCHAR2	(240)		The description for the direct item
DI_PURCHASE_CATEGORY_ID	NUMBER			The purchasing category ID associated with the direct item
DI_AUTO_REQUEST_MATERIAL	VARCHAR2	(1)		The auto request material flag for the direct item
DI_NEED_BY_DATE	DATE			The date by which the direct item is expected to be delivered
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
WORK_ORDER_TYPE	NUMBER			Work Order Type
ACTIVITY_TYPE	NUMBER			Work Order Activity Type
ACTIVITY_CAUSE	NUMBER			Work Order Activity Cause
ACTIVITY_SOURCE	NUMBER			Work Order Activity Source
AVAILABLE_QUANTITY	NUMBER			Available Quantity of the Items
ITEM_COMMENTS	VARCHAR2	(240)		Item Comments
CU_QTY	NUMBER			Construction unit quantity
DIFFICULTY_QTY	NUMBER			Difficulty quantity from the estimate page
SRC_DIFFICULTY_ID	NUMBER			Difficulty code from the estimate
WO_LINE_PER_UNIT_COST	NUMBER			Per Unit cost of resource or item
RES_SCHEDULED_FLAG	NUMBER			Scheduled flag which determines if scheduling of resource needs to be calculated or not

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 does not reference any database object

EAM.EAM_CE_WORK_ORDER_LINES is referenced by following:

EAM: EAM_CE_WORK_ORDER_LINES#