Hi Guys.

I hope you can help me solve this problem, i have a query below and i want to convert (+) into join syntax like 'left outer join ? on ? = ?'

i hope someone can solve this.

SELECT debit_note.note_oid,
debit_note.note_no,
debit_note.pocy_oid,
txn.amt txn_amt
FROM debit_note,
settlement,
settlement_note,
bf_txn
WHERE debit_note.note_oid = settlement_note.note_oid_settled(+)
AND settlement.sett_oid(+) = settlement_note.sett_oid
AND txn.bftx_oid = debit_note.bftx_oid
AND ((TO_DATE(TO_CHAR(settlement.settle_date,'MM/DD/YYYY'),'MM/DD/YYYY')
BETWEEN TO_DATE('12/01/2009','MM/DD/YYYY')
AND TO_DATE('12/01/2009','MM/DD/YYYY')
OR TO_DATE(TO_CHAR(settlement.crt_date,'MM/DD/YYYY'),'MM/DD/YYYY')
BETWEEN TO_DATE('12/01/2009','MM/DD/YYYY')
AND TO_DATE('12/01/2009','MM/DD/YYYY')
OR TO_DATE(TO_CHAR(settlement.reverse_date,'MM/DD/YYYY'),'MM/DD/YYYY')
BETWEEN TO_DATE('12/01/2009','MM/DD/YYYY')
AND TO_DATE ('12/01/2009','MM/DD/YYYY'))
OR TO_DATE (TO_CHAR(debit_note.bill_date,'MM/DD/YYYY'),'MM/DD/YYYY')
BETWEEN TO_DATE('12/01/2009','MM/DD/YYYY')
AND TO_DATE('12/01/2009','MM/DD/YYYY'))