BOM_STANDARD_OPERATIONS_V

最新推荐文章于 2022-11-30 19:27:32 发布

转载最新推荐文章于 2022-11-30 19:27:32 发布 · 132 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/leslie116/archive/2010/09/18/1830312.html

本文介绍了一个SQL视图BOM_STANDARD_OPERATIONS_V的创建语句，该视图通过连接多个表来整合标准操作信息，包括生产线代码、部门详情及位置等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ALTER view [dbo].[BOM_STANDARD_OPERATIONS_V]
as
SELECT WL.LINE_CODE, BSO.SEQUENCE_NUM, BSO.LINE_ID, BSO.OPERATION_TYPE,
          BSO.STANDARD_OPERATION_ID, BSO.OPERATION_CODE,
          BSO.ORGANIZATION_ID, BSO.DEPARTMENT_ID,
          BD.DEPARTMENT_CODE DEPARTMENT_CODE,
          BD.DESCRIPTION DEPARTMENT_DESCRIPTION, BD.LOCATION_ID,
          BSO.LAST_UPDATE_DATE, BSO.LAST_UPDATED_BY, BSO.CREATION_DATE,
          BSO.CREATED_BY, BSO.LAST_UPDATE_LOGIN,
          BSO.MINIMUM_TRANSFER_QUANTITY, BSO.COUNT_POINT_TYPE,
          BSO.OPERATION_DESCRIPTION, BSO.OPTION_DEPENDENT_FLAG,
          BSO.ATTRIBUTE_CATEGORY, BSO.ATTRIBUTE1, BSO.ATTRIBUTE2,
          BSO.ATTRIBUTE3, BSO.ATTRIBUTE4, BSO.ATTRIBUTE5, BSO.ATTRIBUTE6,
          BSO.ATTRIBUTE7, BSO.ATTRIBUTE8, BSO.ATTRIBUTE9, BSO.ATTRIBUTE10,
          BSO.ATTRIBUTE11, BSO.ATTRIBUTE12, BSO.ATTRIBUTE13, BSO.ATTRIBUTE14,
          BSO.ATTRIBUTE15, BSO.REQUEST_ID, BSO.PROGRAM_APPLICATION_ID,
          BSO.PROGRAM_ID, BSO.PROGRAM_UPDATE_DATE, BSO.BACKFLUSH_FLAG,
          CASE WHEN BSO.COUNT_POINT_TYPE = 1 THEN 1 ELSE 2 END COUNT_POINT_FLAG,
          CASE WHEN BSO.COUNT_POINT_TYPE= 3 THEN 2 ELSE 1 END AUTOCHARGE_FLAG,
          BSO.WMS_TASK_TYPE, BSO.OPERATION_YIELD_ENABLED, BSO.YIELD,
          BSO.SHUTDOWN_TYPE, ML.MEANING SHUTDOWN_TYPE_VALUE,
          BSO.DEFAULT_SUBINVENTORY, BSO.DEFAULT_LOCATOR_ID,
          BSO.CRITICAL_TO_QUALITY, BSO.VALUE_ADDED
FROM bom_standard_operations bso
inner join bom_departments bd on bd.department_id = bso.department_id
left join wip..wip_lines wl on wl.line_id = bso.line_id
left join mfg_lookups ml on ml.lookup_code = bso.shutdown_type
      AND ml.lookup_type = 'BOM_EAM_SHUTDOWN_TYPE';

转载于:https://www.cnblogs.com/leslie116/archive/2010/09/18/1830312.html