ERPstuff - Oracle EBS Community

SELECT MAX(CASE WHEN dept = 10 THEN ename END) dept_10,
MAX(CASE WHEN dept = 20 THEN ename END) dept_20,
MAX(CASE WHEN dept = 30 THEN ename END) dept_30
from (select dept,empno,ename,row_number() over(PARTITION BY dept ORDER BY ename) rn from emp) x
group by rn

R u trying to make the rdf report multi org?
in that case u need to follow different concept.
Let me know the answer for my question tehn i would provide you the logic

Can you post the count of the query from report builder and toad for my reference along with the query and the parameter values that you are passing?

After the concurrent program completes normal, do the following:

Click on View output button

Do Tools -> Copy. THis will copy the output to IE.
Then save as .txt. This will give you text file. You can open this in excel if the output is comma delimited

Try below query: select fff.function_name,ff.form_name,fm.menu_name,frv.responsibility_name FROM FND_FORM_FUNCTIONS fff, fnd_form ff, fnd_menus fm, fnd_compiled_menu_functions fcmf, fnd_responsibility_vl frv, fnd_user fu, fnd_user_resp_groups furg WHERE ff.form_id = fff.form_id AND fff.function_id =...

quantity received you can get from po distributions table

po line which is on hold you can get from ap_holds_all.line_location_id