Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement