SELECT /*+ INDEX(p_app MPGUPROD2.IX_P_APP_FOR_TP2)*/
                  pa.reg_num, pa.app_id, TO_CHAR(TO_DATE(pa.app_date,:"SYS_B_00"), :"SYS_B_01") AS app_date,
                  pa.service_target_title, pu.surname, pu.name, pu.patronymic, pu.snls, pa.form_id, pa.cl_client_id, pa.status_code,
                  TO_CHAR(TO_DATE(SUBSTR(pa.status_date,:"SYS_B_02",:"SYS_B_03"),:"SYS_B_04"), :"SYS_B_05") AS status_date,
                  TO_CHAR(SUBSTR(pa.status_title,:"SYS_B_06",:"SYS_B_07")) AS status_title,
                  TO_CHAR(SUBSTR(pa.extra_info,:"SYS_B_08",:"SYS_B_09")) AS extra_info
                  FROM p_app pa LEFT JOIN p_user pu ON pu.pgu_user_id = pa.cl_client_id
                  WHERE :"SYS_B_10"=:"SYS_B_11"  AND form_id IN (:"SYS_B_12") AND pa.app_date >= TO_CHAR(TO_DATE(:"SYS_B_13", :"SYS_B_14"), :"SYS_B_15") AND pa.app_date <= TO_CHAR(TO_DATE(:"SYS_B_16", :"SYS_B_17"), :"SYS_B_18") AND status_code IN (:"SYS_B_19") ORDER BY :"SYS_B_20" DESC