SELECT AACTIVITY_ID AS activityId APROJECT_CODE AS projectCode BPROJECT_ID AS projectId BPROJECT_NAME AS projectName AACTIVITY_CODE AS activityCode AACTIVITY_

The query selects various fields from the t_activity_info table and joins it with the t_activity_project_info and tb_bic_vallist tables. The WHERE clause filters the results to only include rows where the IS_ENABLE field is '1'. Additionally, if the orgIds parameter is not null or empty, the query includes a subquery to filter the results based on whether the orgIds value is present in the PROXY_CODE field of the t_activity_proxy_info table for the given activity.