Need to lock a record based on only one primark_key from multiple tables

 HI, I am currently working for a custom packing_screen in that based on upc scanned i need to lock particular record

i am using the below query

 select wdd.delivery_detail_id,wnd.delivery_id,ooh.header_id,'444444221',nvl(ooh.attribute1,'No Insert Code')

                        from oe_order_headers_all  ooh,

                                oe_order_lines_all        ool,

                                wsh_delivery_details   wdd,

                               wsh_delivery_assignments wda,

                               wsh_new_deliveries wnd,

                               msn_vsku_attributes vsku,

                               msn_ssku_attributes  ssku,

                               mtl_system_items_b msib

                   where ooh.header_id=ool.header_id

                      and ool.line_id=wdd.source_line_id

                      and wdd.source_header_id=ooh.header_id