CSE_ASSET_WORK_ORDERS_V
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: VIEW
Columns
Name |
---|
ASSET_ID ASSET_NUMBER ASSET_DESCRIPTION ITEM_ID SERIAL_NUMBER LOT_NUMBER ASSET_QUANTITY ASSET_LOCATION_TYPE WORK_ORDER_ID WORK_ORDER_NUMBER ORGANIZATION_ID WORK_METHOD_ID WORK_ORDER_TYPE WORK_ORDER_SUB_TYPE WORK_DEFINITION_ID WORK_ORDER_STATUS_ID |
Query
SQL_Statement |
---|
SELECT wwa.asset_id asset_id, ca.asset_number asset_number, ca.description asset_description, ca.item_id item_id, ca.serial_number serial_number, ca.lot_number lot_number, ca.quantity asset_quantity, ca.current_location_context asset_location_type, wwa.work_order_id work_order_id, wwo.work_order_number work_order_number, wwo.organization_id organization_id, wwo.work_method_id work_method_id, wwo.work_order_type work_order_type, wwo.work_order_sub_type work_order_sub_type, wwo.work_definition_id work_definition_id, wwo.work_order_status_id work_order_status_id FROM wie_wo_assets wwa, wie_work_orders_b wwo, cse_assets_vl ca WHERE wwo.work_order_id = wwa.work_order_id AND ca.asset_id = wwa.asset_id |