Answer Posted / rashmiraj

SELECT COL1,COL2,ROWNUM
FROM (SELECT COL1,COL2 FROM TABLE ORDER BY COL1 DESC)
WHERE ROWNUM<=&A;

as for example........

select ename,job,sal,rownum
from (select ename,job,sal from emp order by sal desc)
where rownum <=3;

Does oracle support running of gather stats on sys schema in oracle apps?

902

---

Differentiate apps schema from other schemas?

929

---

What are the steps in attaching reports with oracle applications?

835

---

How to enable tracing for document managers

826

---

Define set – of books?

965

---

What is a token?

919

---

Define descriptive flexfield ?

920

---

What is the lock option in reports layout?

915

---

What is mrc?

907

---

What are Quick pick and quick codes

974

---

Define multi org ?

867

---

Define mrc ( multiple reporting currency)?

884

---

Define record group?

986

---

Where to define the parameters in the report?

857

---

We are using flow manufacturing in oracle to manufacte ATO products. The items reserve to the sales order at the time of Work Order-less Completion. After they are reserved, they cannot be transferred from location to location within the FG warehouse as they are reserved and not available for subiventory transfer. Any ideas on how we can move products around the warehouse without destroying the reservation?

2509

---