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