(select
       tw.account_id  as ACCT_ID,
       tw.oidd  
       ,new_value
from tw
left join  booked_tbl bod
on tw.oidd     = bod.oidd
and tw.pid = bod.pid
left join  sm_dmd_tbl smdo
on tw.oidd     = smdo.oidd
and tw.pid = smdo.pid
where 1=1
group by tw.account_id , tw.oidd );

select substr(replace(sys_connect_by_path(name,'/'),'/',','),2) brkup
from ( select aw_transaction_id,  GROUPCODE||'|'||amt name, 
    row_number() over(partition by transid order by GROUPCODE) rn
from  at_PARTS
)
where connect_by_isleaf = 1
connect by prior transid = transid 
and prior rn = rn-1
start with rn = 1 ;