bungrudi

Untitled

May 15th, 2012
121
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×