188: , l.line_num
189: , loc.shipment_num
190: , h.revision_num
191: , h.creation_date
192: , (SELECT fnd_user.user_name
193: FROM fnd_user
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
189: , loc.shipment_num
190: , h.revision_num
191: , h.creation_date
192: , (SELECT fnd_user.user_name
193: FROM fnd_user
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
197: FROM fnd_user
190: , h.revision_num
191: , h.creation_date
192: , (SELECT fnd_user.user_name
193: FROM fnd_user
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
197: FROM fnd_user
198: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
192: , (SELECT fnd_user.user_name
193: FROM fnd_user
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
197: FROM fnd_user
198: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
199: , pvsa.vendor_site_code
200: , pvsa.address_line1
193: FROM fnd_user
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
197: FROM fnd_user
198: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
199: , pvsa.vendor_site_code
200: , pvsa.address_line1
201: , pvsa.address_line2
194: WHERE fnd_user.user_id = h.created_by) created_by
195: , h.revised_date
196: , (SELECT fnd_user.user_name
197: FROM fnd_user
198: WHERE fnd_user.user_id = h.last_updated_by) last_updated_by
199: , pvsa.vendor_site_code
200: , pvsa.address_line1
201: , pvsa.address_line2
202: , pvsa.address_line3