作业取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%'