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                                     AS person_id1,
    ( person.last_name
      || ' '
      || person.first_name )                               AS view_attr,
    p_wbs.getwbsname(attachdoc.wbs_id, attachdoc.poi_id) AS view_attr,
    ( guiusers.last_name
      || ' '
      || guiusers.first_name )                             AS view_attr,
    ( vehicle.company_nr
      || ' '
      || vehicle.numberplate )                             AS view_attr,
    NVL2(object.vehicle_id, '['
                            || object.company_nr
                            || '].['
                            || object.numberplate
                            || ']', NULL)                                        AS view_attr,
    ( '['
      || p_wbs.getwbsname(attachdoc.wbs_id, attachdoc.poi_id)
      || '].['
      || attachdoc.name
      || '].['
      || person.last_name
      || ' '
      || '].['
      || person.first_name
      || ' '
      || person.last_name
      || '].['
      || vehicle.numberplate
      || '].['
      || vovehiclecategory.name
      || '].['
      || object.numberplate
      || ']' )                                             AS view_attr,
    attachdoc.wbs_id,
    attachdoc.ref_number,
    (
        SELECT
            numberplate
        FROM
            vehicle v
        WHERE
            v.vehicle_id = attachdoc.vehicle_id
    )                                                    AS view_attr,
    (
        SELECT
            company_nr
        FROM
            vehicle v
        WHERE
            v.vehicle_id = attachdoc.vehicle_id
    )                                                    AS view_attr,
    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 = 118705
    )
              OR attachdoc.vehicle_id IN (
        SELECT
            vehicle_id
        FROM
            gu_vehicle
        WHERE
            gui_user_id = 118705
    )
              OR attachdoc.object_id IN (
        SELECT
            vehicle_id
        FROM
            gu_vehicle
        WHERE
            gui_user_id = 118705
    )
              OR attachdoc.poi_id IN (
        SELECT
            poi_id
        FROM
            v_gui_user_oc_poi
        WHERE
            gui_user_id = 118705
    )
              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 = 118705
            )
    )
              OR attachdoc.gui_user_id = 118705 )
        AND ( NULL IS NULL
              OR attachdoc.person_id = NULL )
        AND ( NULL IS NULL
              OR attachdoc.vehicle_id = NULL )
        AND ( NULL IS NULL
              OR attachdoc.poi_id = NULL )
        AND ( NULL IS NULL
              OR attachdoc.object_id = NULL )
        AND ( NULL IS NULL
              OR attachdoc.wbs_id = NULL ) )
AND attachdoc.document_type_id = 1007  --extra where clause from ContextBean
AND attachdoc.person_id = 295245 --extra where clause from ContextBean
--      AND attachdoc.attach_doc_id = ? --missing parameter at index 17
      )