1. KQM_BELLCARDDATA
2. KQM_KAOQINDATA
3. WFM_AUDITSTATUS , AUDITMAN F2135117, F2104598 ,AUDITDATE, BILLNO
4. WFM_REMIND : REMINDCONTENT LIKE '%TP%' AND REMINDDATE>=SYSDATE - 32
5. OTM_ADVANCEAPPLY : TDATE = TO_DATE('2011-06-18','YYYY-MM-DD') AND TTYPE='G2'
OTM_ADVANCEAPPLY : BILLNO='OTAD0029002111060001' , TO CHECK ID
OTM_ADVANCEAPPLY : ID LIKE 'A5E0BE1D4DE76FF5E040860A7F821372' , TO GET ID
ADD ROW TO THIS TABLE .
6. OTM_DAYREPORT : WORKDAYS = 6 , WORKHOURS=56
7. OTM_MONTHDETAIL
8. OTM_MONTHTOTAL
9. OTM_REALAPPLY : WORKNO = 'F2168091' AND OTDATE>=SYSDATE - 20
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-700321/
,如需转载,请注明出处,否则将追究法律责任。