KQQ
-
tolywang
2011-06-20 18:11:32
-
Linux操作系统
-
原创
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