1       09:11:04  SQL Execute: ORACLE - select  'Ò×ÁªÖÚss' ZBRXM0,a.* from VW_BQ_JRZSYZ a  where BQH000=484 and zyid00 in (792085,791990,792595,791302,791252,791251,791305,791322,791366,791304,792158,792468,792227,792621,791236,791248,792335,791308,791231,792416,792506,792221,792414,792561,792537,792534,792535,791295,791151,792349,792640,792533,791482,791301,792652,792633,792489,792352,792339,791977,791427,792563,792605,792323,792529,792558,792365,790810,791331,791255,791246,792618,792609,790717)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0') in ('1','0')) and YFLBID IN (1,2) order by Ch0000,yzid00,yzmxid