钣金计划大表：增加需求追溯号逻辑

zhanghl

2025-05-22 608ab8beb553ca8996c95bdd50ec61c253d36ec1

钣金计划大表：增加需求追溯号逻辑

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlate/ApsPlateProcessShopStatMapper.xml

@@ -141,9 +141,16 @@
                     left join aps_process_route as pr on ap.document_number=pr.work_order_no
            where cast(pr.process_number as numeric) > cast(ap.process_number as numeric)
            group by ap.document_number
        ),
        b as (
            select app.doc_no, string_agg(  app.require_track_id  ,',') as require_track_id
            from aps_plate_standard_require_bom_order_detail as  app
            where del_flag='0'
            group by app.doc_no
        )
        select
            app.id,
            b.require_track_id,
            app.main_part_number,
            app.customer,
            app.business_type,
@@ -168,6 +175,7 @@
            a.remained_process
        from aps_plate_plan as app
                 left join a on app.document_number=a.document_number
                 left join  b on app.document_number=b.doc_no
        where app.del_flag='0';
    </select>
</mapper>