Home » Applications » Oracle Fusion Apps & E-Business Suite » Join condition in Fa_distribution_history (11i)
Join condition in Fa_distribution_history [message #472810] Tue, 24 August 2010 01:11 Go to next message
yknev
Messages: 38
Registered: August 2010
Member
Hi All,

I am facing with below query? Could you help me.

In FA_DISTRIBUTION_HISTORY table, assigned_to column is null and not null present.

How to write the query using FA_DISTRIBUTION_HISTORY and FA_EMPLOYEES. What is the join condition for two tables when assigned_to column is null

If asset is assigned to particular employee than i want the name of employee else Null.

Regards,

Yknev
Re: Join condition in Fa_distribution_history [message #472848 is a reply to message #472810] Tue, 24 August 2010 04:16 Go to previous message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello.

You can try this:

select Fe.Employee_Number, Fe.Name from fa_distribution_history fdh, Fa_Employees fe
where fe.Employee_ID (+) = fdh.assigned_to


Eric.
Previous Topic: Reorganize APPLSYSD over Diferrent Schedules
Next Topic: CREATE_PHONE API
Goto Forum:
  


Current Time: Thu Mar 28 17:45:20 CDT 2024