SELECT A.EQUIPNUM,A.REMARK1,A.PRDTYPE,A.PRDSRNUM,A.SALESGCODE,A.REMARK3,A.SALESRCODE, A.RUNTIME,A.ISDPRD,A.GSSDATE,A.GSFDATE,A.SETPPRD,A.SEFPPRD,A.SEHPPRD,A.ODCNUMBER,A.PGNAME, B.DEALER_NAME AS SALESGNAME, C.SALESRNAME, D.SRVSEQ,f.chtid, E.USERNAMEFROM TB_CM_MPRD A, TB_CM_SALESG B, TB_CT_SALESR C, TB_CM_SRVMAN D, tb_cm_muser E, tb_ct_clhist FWHERE 1=1 AND A.SALESGCODE = B.CRM_DEALER_ID(+) AND A.SALESRCODE = C.SALESRCODE(+) AND A.PRDTYPE = F.PRDTYPE(+) AND A.PRDSRNUM = F.PRDSRNUM(+) AND D.CHTID = F.CHTID AND D.SRVSEQ = E.USERSEQ AND D.SRVMAINFLG = 'Y'
A.RUNTIME,A.ISDPRD,A.GSSDATE,A.GSFDATE,A.SETPPRD,A.SEFPPRD,A.SEHPPRD,A.ODCNUMBER,A.PGNAME,
B.DEALER_NAME AS SALESGNAME,
C.SALESRNAME,
D.SRVSEQ,f.chtid,
E.USERNAMEFROM
TB_CM_MPRD A, TB_CM_SALESG B, TB_CT_SALESR C,
TB_CM_SRVMAN D, tb_cm_muser E, tb_ct_clhist FWHERE 1=1
AND A.SALESGCODE = B.CRM_DEALER_ID(+)
AND A.SALESRCODE = C.SALESRCODE(+)
AND A.PRDTYPE = F.PRDTYPE(+)
AND A.PRDSRNUM = F.PRDSRNUM(+)
AND D.CHTID = F.CHTID
AND D.SRVSEQ = E.USERSEQ
AND D.SRVMAINFLG = 'Y'