Oracle - Ayuda con Inner join

SELECT DISTINCT

 SSAH.SECID,

 SSAH.ACCOUNTNO,

 to_char(BRPS.PREVBRANPRCDATE, 'yymmdd'),

 SSAH.TDYPOOLQTY,

 CUST.CNO,

 CUST.CFN1,

 SECM.PRODUCT,

 SECM.CCY,

 'CONTROL EMISORES SIN SSI EN CSRI'

FROM SSAH,SECM, BRPS, CUST,CSRI,SECS

WHERE SECM.SECID = SSAH.SECID

 AND SSAH.TDYPOOLQTY <> 0

 AND SSAH.BR IN ('01','05','17')

 AND SSAH.BR = BRPS.BR

 AND SECM.ISSUER = CUST.CNO

 AND SSAH.BR = CSRI.BR

 AND SECM.ISSUER = CSRI.CUST

 AND CSRI.PRODUCT = 'SECUR'

 AND CSRI.TYPE = 'SD'

 AND CSRI.CCY = SECM.CCY

 AND SECM.SECID = SECS.SECID

 AND SECM.PRODUCT != 'CERT'

 AND SECM.INTCALCRULE != 'IAM'