201: , l.line_num
202: , loc.shipment_num
203: , h.revision_num
204: , h.creation_date
205: , (SELECT fnd_user.user_name
206: FROM fnd_user
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
202: , loc.shipment_num
203: , h.revision_num
204: , h.creation_date
205: , (SELECT fnd_user.user_name
206: FROM fnd_user
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
210: FROM fnd_user
203: , h.revision_num
204: , h.creation_date
205: , (SELECT fnd_user.user_name
206: FROM fnd_user
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
210: FROM fnd_user
211: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
205: , (SELECT fnd_user.user_name
206: FROM fnd_user
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
210: FROM fnd_user
211: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
212: , pvsa.vendor_site_code
213: , pvsa.address_line1
206: FROM fnd_user
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
210: FROM fnd_user
211: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
212: , pvsa.vendor_site_code
213: , pvsa.address_line1
214: , pvsa.address_line2
207: WHERE fnd_user.user_id = h.created_by) created_by
208: , h.revised_date
209: , (SELECT fnd_user.user_name
210: FROM fnd_user
211: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
212: , pvsa.vendor_site_code
213: , pvsa.address_line1
214: , pvsa.address_line2
215: , pvsa.address_line3