Order Management - EBS (MOSC)

MOSC Banner

How to Link FND_USER table to OM tables

edited Oct 20, 2013 4:15PM in Order Management - EBS (MOSC) 5 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center