csjoz11

导航

作业取SETTING值

SELECT AO.SETTING FROM WIP.ACTIVITY A INNER JOIN WIP.ACTIVITY_OPTION AO ON A.HANDLE = AO.ACTIVITY_BO WHERE A.ACTIVITY = 'YC_DEF_OPER_BZPOD'

 

 SELECT * FROM ACTIVITY_OPTION ao WHERE EXEC_UNIT_OPTION ='OPERATION' AND ACTIVITY_BO LIKE '%YC_SFC_ORDER%'

posted on 2022-04-11 14:09  csjoz11  阅读(8)  评论(0编辑  收藏  举报