Oracle Apps Techno Functional................

-- Find nth highest salary of an employee 1)  Using Corelated Subquery select * from Emp e1 where 1= (select count(distinct(e2.sal)) from Emp e2 where e2.sal>e1.sal); 2)  Using Rownum select * from (select e.*, row_number() over(order by sal desc) rownumb from Emp e where sal is not null) where rownumb=3; 3) Using Rank select * from (select e.*, rank() over(order by sal desc) ranking from Emp e where sal is not null) where ranking =2;

Simple Tutorials On Oracle ADF Beginners Peoples(Oracle ADF beginners) who are all passing this street,  here is one way to start with simple start tutorials.  Oracle JDeveloper and Oracle ADF 11g Tutorials Build Rich Client Forms with ADF Swing and ADF Business Components Oracle   JDeveloper   11g   Release   2(11.1.2) Tutorials Oracle   ADF   11g    DeskTop   Integration  

PURCHASING  All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle : Requisition à RFQ à Quotation à Quotation Analysis à Purchasing à Receiving à Invoice  à  Payment à Reconciliation PO-Integration :  PO  is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO  Responsibility             Step1: Define  PO  Responsibility                         Nav: System administrator à Security à Responsibility à Define             Step2: Assign  PO  options to the PO Responsibility                         Nav: System administrator à Profile à system             Step3: Assign  PO  Responsibility to User                         Nav: System administrator à security à user à define Note:  PO  is including some of i.e. Options, Supplier, Item, Expenses, and Purchasing . Options : Options nothing but a Controlling future at the operating unit level.                         Th