SELECT amsecusers.USER_NAME, amsecusers.COOP_ID, amsecusers.PASSWORD, amsecusers.TERMINAL_NAME, amsecusers.COOPBRANCH_ID, amsecusers.USER_ID, amsecusers.APVLEVEL_ID, amsecusers.COOP_CONTROL, amsecusers.USER_LEVEL, amsecusers.USER_TYPE, amsecusers.APVCASH_FLAG, amsecusers.POINT_OFCASH, amsecusers.FREEZ_FLAG, amsecusers.INITIAL_NAME, amsecusers.SHOWSALARY_FLAG, amsecusers.USER_C, amsecusers.DESCRIPTION, amsecusers.FULL_NAME, amsecusers.TABLEFIN_CODE, amsecgroupings.GROUP_NAME FROM amsecusers, amsecgroupings WHERE amsecusers.USER_NAME = amsecgroupings.USER_NAME SELECT AMSECWINS.WINDOW_ID, AMSECWINS.WIN_DESCRIPTION, AMSECWINS.WIN_TITLE , case when AMSECWINS.WINDOW_ID= (select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and save_status=1 and user_name ='fame') then 1 else 0 end as save_status, case when AMSECWINS.WINDOW_ID= (select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and check_flag=1 and user_name ='fame') then 1 else 0 end as check_flag, case when AMSECWINS.WINDOW_ID= (select window_id from amsecpermiss where window_id=AMSECWINS.WINDOW_ID and apv_flag=1 and user_name ='fame' ) then 1 else 0 end as apv_flag FROM AMSECWINS, AMSECWINSGROUP WHERE ( AMSECWINS.GROUP_CODE = AMSECWINSGROUP.GROUP_CODE ) and ( AMSECWINS.APPLICATION = AMSECWINSGROUP.APPLICATION ) and ( AMSECWINS.APPLICATION = 'app_finance' ) and ( AMSECWINS.USED_FLAG = 1 ) order by AMSECWINSGROUP.GROUP_ORDER asc,AMSECWINS.WIN_ORDER asc select amsecwins.window_id, amsecpermiss.application, amsecwins.win_description,amsecwins.win_title, amsecpermiss.check_flag, amsecpermiss.save_status,amsecpermiss.apv_flag from amsecpermiss,amsecwins where amsecpermiss.window_id = amsecwins.window_id and amsecpermiss.application = amsecwins.application group by amsecpermiss.window_id SELECT COOP_ID, APPLICATION, CLOSEDAY_STATUS, CLOSEDAY_DATE, CLOSEDAY_ID, CLOSEMONTH_STATUS, CLOSEMONTH_ID, CLOSEYEAR_STATUS, CLOSEMONTH_DATE, CLOSEYEAR_DATE, CLOSEYEAR_ID, SERVICE_NAME, SERVER_IP, AUTO_FLAG, LAST_LOG_SEQ_NO, CUR_PROCESS_ID, DATECUT_OF, NXTDATECUT_OF, CURRENT_ACCYEAR, CLOSEME_MINUTE, APPLGROUP_CODE, DESCRIPTION, APPLTIME_CODE, BRANCH_ID, APPLTIME_DAYINCMT, MENU_ORDER, USED_FLAG, COOP_CONTROL, CHECK_CLOSE_STATUS, LAST_WORKDATE, WORKDATE, PORT_NUMBER FROM amappstatus select amsecuseapps.coop_id, amsecuseapps.user_name, amsecuseapps.application, amappstatus.description from amappstatus,amsecuseapps where amappstatus.application = amsecuseapps.application and amappstatus.coop_id = amsecuseapps.coop_id SELECT COOP_ID, USER_NAME, APPLICATION, WINDOW_ID, SAVE_STATUS, CHECK_FLAG, COOP_CONTROL, APV_FLAG, approve_flag FROM amsecpermiss SELECT REPORT_ID, GROUP_ID, OPEN_TYPE, REPORT_CRIOBJECT, REPORT_NAME, USED_FLAG, REPORT_DWOBJECT, REPORT_COMMENT, REPORT_CREOBJECT, CORE_FLAG FROM webreportdetail SELECT GROUP_ID, USED_FLAG, APPLICATION, GROUP_ORDER, GROUP_NAME, REF_GROUP_ID FROM webreportgroup SELECT USER_NAME, USER_TYPE, COOP_ID, PASSWORD, TERMINAL_NAME, COOPBRANCH_ID, APVLEVEL_ID, USER_ID, COOP_CONTROL, USER_LEVEL, POINT_OFCASH, FREEZ_FLAG, APVCASH_FLAG, INITIAL_NAME, SHOWSALARY_FLAG, USER_C, DESCRIPTION, TABLEFIN_CODE, FULL_NAME FROM amsecusers SELECT USER_NAME, GROUP_NAME,COOP_ID FROM amsecgroupings