Pastebin launched a little side project called HostCabi.net, check it out ;-)Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: bungrudi on May 15th, 2012  |  syntax: None  |  size: 0.90 KB  |  hits: 52  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT rrn(head) rownum,
  2.        head.TGLUPL tglupl,
  3.        trim(head.MFCODE) mfcode,
  4.        trim(cfiloan.CFSNME) namaRekanan,
  5.        trim(head.NOBAT) batchId,
  6.        trim(head.NMRSRT) nomorSurat,
  7.        trim(fas.PERDOC) pemeriksaanDok,
  8.        trim(head.FASID) fasId,
  9.        trim(prod.NMPROD) fasilitas,
  10.        trim(head.JNTRAN) trxType,
  11.        trim(head.STATE) state,
  12.        trim(head.STAREC) stateRecord,
  13.        head.STAQUE statusQue,
  14.        errMsg.MSGDES errorMessage
  15.        FROM "JFPMTPRDD".T1HEAD2L head,
  16.             "JFPMTPRDD".PROD1P prod,
  17.             "JFPMTPRDD".MSTRFA1P fas,
  18.             "JHFINLI31A"."CFMAST" cfiloan
  19.             LEFT JOIN "JFPMTPRDD".TMSG01P errMsg ON (head.MSGCOD = errMsg.MSGCOD)
  20.        WHERE    trim(head.MFCODE) = cfiloan.CFCIF#
  21.                 AND  trim(fas.IDPROD)=trim(prod.IDPROD)
  22.                 AND  trim(head.FASID)=trim(fas.FASID)
  23.                 AND  trim(head.MFCODE)=trim(fas.MFCODE)
  24.                 ORDER BY head.TGLUPL ASC