Hi Oracle Apps Gurus,
How do we get the manager of the person who created an order. I am taking 'created_by' column as the Order creator from the 'oe_order_headers_all' table. I need the query to find the manager of the order creator.Also I need to get the corresponding job title of the creator as well as the manager.Can someone please help me in this regard.
Thanks in advance.
Regards,
Abhi