Fetch 4 5.44 5.31 0 2585652 0 4
------- ---- -------- ---------- -------- ---------- ---------- -----

Rows Row Source Operation
------- ---------------------------------------------------
0 NESTED LOOPS
Strange behaviour. The fetch line shows 4 rows returned, where as ROW Source says 0 rows.

The row source shows that joining with CB_STANDARD returns 0 rows.
Why don't you start this table, CB_STANDARD as a driving table. Use leading hint.

Do you have an index on LOCATOR column?
Also, change SUBSTR(cbs.LOCATOR,1,6) to LOCATOR like '1.1026%'

It's worth to try.

Tamil