[Home] [Help] [Dependency Information]
Object Name: | EAM_CE_WORK_ORDER_LINES# |
---|---|
Object Type: | VIEW |
Owner: | EAM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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#;
|
|
|