SELECT COOP_ID, USER_NAME, PASSWORD, TERMINAL_NAME, COOPBRANCH_ID, USER_ID, APVLEVEL_ID, COOP_CONTROL, USER_LEVEL, USER_TYPE, POINT_OFCASH, APVCASH_FLAG, FREEZ_FLAG, INITIAL_NAME, SHOWSALARY_FLAG, USER_C, DESCRIPTION, FULL_NAME, TABLEFIN_CODE FROM amsecusers SELECT COOP_ID, USER_NAME, APPLICATION, WINDOW_ID, CHECK_FLAG, SAVE_STATUS, COOP_CONTROL, APV_FLAG, approve_flag FROM amsecpermiss SELECT USER_NAME, GROUP_NAME, COOP_ID FROM amsecgroupings SELECT COOP_ID, USER_NAME, COOP_CONTROL, APPLICATION FROM amsecuseapps SELECT USER_NAME, COOP_ID, GROUP_ID, REPORT_ID, CHECK_FLAG FROM amsecreportpermiss 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 GROUP_ID, USED_FLAG, APPLICATION, GROUP_ORDER, GROUP_NAME, REF_GROUP_ID FROM webreportgroup