Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT rrn(head) rownum,
- head.TGLUPL tglupl,
- trim(head.MFCODE) mfcode,
- trim(cfiloan.CFSNME) namaRekanan,
- trim(head.NOBAT) batchId,
- trim(head.NMRSRT) nomorSurat,
- trim(fas.PERDOC) pemeriksaanDok,
- trim(head.FASID) fasId,
- trim(prod.NMPROD) fasilitas,
- trim(head.JNTRAN) trxType,
- trim(head.STATE) state,
- trim(head.STAREC) stateRecord,
- head.STAQUE statusQue,
- errMsg.MSGDES errorMessage
- FROM "JFPMTPRDD".T1HEAD2L head,
- "JFPMTPRDD".PROD1P prod,
- "JFPMTPRDD".MSTRFA1P fas,
- "JHFINLI31A"."CFMAST" cfiloan
- LEFT JOIN "JFPMTPRDD".TMSG01P errMsg ON (head.MSGCOD = errMsg.MSGCOD)
- WHERE trim(head.MFCODE) = cfiloan.CFCIF#
- AND trim(fas.IDPROD)=trim(prod.IDPROD)
- AND trim(head.FASID)=trim(fas.FASID)
- AND trim(head.MFCODE)=trim(fas.MFCODE)
- ORDER BY head.TGLUPL ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement