SELECT AttachDoc.ATTACH_DOC_ID,
       AttachDoc.CONTENT_TYPE_ID,
       AttachDoc.CREATION_DATE,
       AttachDoc.DESCRIPTION,
       AttachDoc.DOCUMENT_DATE,
       AttachDoc.DOCUMENT_TYPE_ID,
       AttachDoc.EXPIRY_DATE,
       AttachDoc.FILE_PATH,
       AttachDoc.LM_COMMENT,
       AttachDoc.LM_DATE,
       AttachDoc.LM_NAME,
       AttachDoc.NAME,
       AttachDoc.ORDER_NUM,
       AttachDoc.PERSON_ID,
       AttachDoc.VEHICLE_ID,
       AttachDoc.GUI_USER_ID,
       AttachDoc.GENERIC_EVENT_ID,
       AttachDoc.SHORT_NAME,
       AttachDoc.POI_ID,
       AttachDoc.OBJECT_ID,
       Person.PERSON_ID,
       AttachDoc.WBS_ID,
       AttachDoc.REF_NUMBER,
       DocumentType.DOCUMENT_TYPE_CATEGORY_ID,
       DocumentType.DOCUMENT_TYPE_ID AS DOCUMENT_TYPE_ID1
FROM OF_OWNER.ATTACH_DOC AttachDoc, V_UPDATABLE_PERSON Person, GUI_USERS GuiUsers, VEHICLE Vehicle, VEHICLE Object, VO_VEHICLE_CATEGORY VoVehicleCategory, OF_OWNER.DOCUMENT_TYPE DocumentType
WHERE AttachDoc.person_id = Person.person_id (+)
AND AttachDoc.DOCUMENT_TYPE_ID = DocumentType.DOCUMENT_TYPE_ID(+)
AND AttachDoc.GUI_USER_ID = GuiUsers.GUI_USER_ID
AND AttachDoc.vehicle_id = Vehicle.vehicle_id (+)
AND AttachDoc.OBJECT_ID = Object.vehicle_id (+)
AND Object.VO_VEHICLE_CATEGORY_ID = VoVehicleCategory.VO_VEHICLE_CATEGORY_ID (+)
AND ( AttachDoc.PERSON_ID     IN
  (SELECT PERSON_ID FROM GU_PERSON WHERE GUI_USER_ID = ?) -- vsichki dostypni persons ot user-a
OR AttachDoc.VEHICLE_ID IN
  (SELECT VEHICLE_ID FROM GU_VEHICLE WHERE GUI_USER_ID = ?) -- vsichki dostypni vehicles ot user-a
OR AttachDoc.object_id IN
  (SELECT VEHICLE_ID FROM GU_VEHICLE WHERE GUI_USER_ID = ?) -- vsichki dostypni objects ot user-a
OR AttachDoc.poi_id IN
  (SELECT poi_id FROM v_gui_user_oc_poi WHERE gui_user_id = ?) -- vsichki dostypni poi ot user-a
OR AttachDoc.wbs_id IN
  (SELECT wbs_id FROM wbs WHERE vehicle_owner_id IN (SELECT DISTINCT vehicle_owner_id FROM gu_vehicle_owner WHERE gui_user_id = ?))
OR AttachDoc.gui_user_id = ?) -- vsichki dostypni wbs ot user-a
AND (? IS NULL OR AttachDoc.PERSON_ID = ?) -- parametyr za lqv filtyr za person
AND (? IS NULL OR AttachDoc.VEHICLE_ID = ?) -- parametyr za lqv filtyr za vehicle
AND (? IS NULL OR AttachDoc.POI_ID = ?) -- parametyr za lqv filtyr za poi
AND (? IS NULL OR AttachDoc.OBJECT_ID = ?) -- parametyr za lqv filtyr za object
AND (? IS NULL OR AttachDoc.WBS_ID = ?) -- parametyr za lqv filtyr za wbs
ORDER BY CREATION_DATE DESC