How to Link FND_USER table to OM tables
Dear Friends,
I have a business requirement, I need to add user_name from fnd_user in my existing query as follows.Kindly help me as its a bit urgent.
SELECT
wnd.delivery_id,
wnd.name delivery_name,
wnd.source_header_id order_header_id,
wdd.cust_po_number,
wdd.container_name,
wdd.ship_to_location_id,
nvl(wdd.deliver_to_location_id,wdd.ship_to_location_id) deliver_to_location_id,
wdd.ship_to_site_use_id c_ship_to_site_use_id,
HZPCON.party_name customer_name,
HZPCON.person_title|| ' ' || substrb(HZPCON.person_first_name,1,40) || ' ' || substrb(HZPCON.person_last_name,1,50) contact_name,