VIEW: EAM.EAM_CE_WORK_ORDER_LINES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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