--update tbrc_usr1

--set USRKND='13'--DNDKDUY

--DNDINHHA

--where brcd='1500' and usrid ='HQANSE';

delete tbrc_usrttl where brcd='1500' and usrid ='BINH1500';

insert into tbrc_usrttl

select '1500', 'BINH1500', rownum, menunm, menunm, 'KT'

from tbrc_menu

where menuid like '%0000'

--and substr(menuid,1,2) not in ('AT','CD') -- for others

and substr(menuid,1,2) not in ('AT','CD', 'FX', 'DL', 'LN', 'TF', 'MS','BS', 'EI', 'AT', 'RT', 'TR') -- for GA

order by menuid;

delete tbrc_usrmenu

where brcd='1500' and usrid ='BINH1500';

insert into tbrc_usrmenu

select '1500', 'BINH1500', b.ttlid, a.MENUID, '1', a.srt, 'Y'

from tbrc_menu a,

(select '1500' brcd, 'BINH1500' usrid, rownum ttlid, menuid

from tbrc_menu

where menuid like '%0000'

--and substr(menuid,1,2) not in ('AT','CD') -- for others

and substr(menuid,1,2) not in ('AT','CD', 'FX', 'DL', 'LN', 'TF', 'MS','BS', 'EI', 'AT', 'RT', 'TR') -- for GA

order by menuid) b

where a.menutp='2'

and substr(a.MENUID,1,2)=substr(b.menuid,1,2)

order by ttlid, menuid;

delete tbrc_usrsbmnu where brcd='1500' and usrid ='BINH1500';

insert into tbrc_usrsbmnu

select '1500', 'BINH1500', b.ttlid, substr(a.menuid,1,4) ||'00', a.MENUID, a.srt, 'Y'

from tbrc_menu a,

(select '1500' brcd, 'BINH1500' usrid, rownum ttlid, menuid

from tbrc_menu

where menuid like '%0000'

--and substr(menuid,1,2) not in ('AT','CD') -- for others

and substr(menuid,1,2) not in ('AT','CD', 'FX', 'DL', 'LN', 'TF', 'MS','BS', 'EI', 'AT', 'RT', 'TR') -- for GA

order by menuid) b

where a.menutp='3'

and substr(a.MENUID,1,2)=substr(b.menuid,1,2)

order by ttlid, substr(a.menuid,1,4) ||'00', b.menuid;

delete TBRC_MSTRBUS u

WHERE u.brcd='1500'

AND USRID='BINH1500';

INSERT INTO TBRC_MSTRBUS

SELECT

U.BRCD, U.USRID, M.BUSCD||untbuscd

FROM tbcs_untbuscd M, TBRC_USR1 U

WHERE u.brcd='1500'

AND USRID='BINH1500';

UPDATE tbrc_usrttl B

SET TTLLCLNM= (SELECT SUBSTR(MENUID,1,2) FROM TBRC_USRMENU C WHERE BRCD='1500' AND USRID='BINH1500' AND B.TTLID=C.TTLID AND ROWNUM=1)

,TTLENGNM=(SELECT SUBSTR(MENUID,1,2) FROM TBRC_USRMENU C WHERE BRCD='1500' AND USRID='BINH1500' AND B.TTLID=C.TTLID AND ROWNUM=1)

WHERE BRCD='1500' AND USRID='BINH1500';

COMMIT;

--update tbrc_menu

--set menuknd1=9

-- ,branch='01'

-- ,roc='01'

-- ,hq='01'

--where menuid like 'CS%';

--delete tbrc_usrttl where brcd='1200' and usrid='H2SADMIN';