Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Sorry, you do not have permission to ask a question, You must login to ask a question.

Sorry, you do not have permission to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Ask A Question

Article

On: October 25, 2015 Posted in Oracle EBS Queries Comments: 0

Query to get all employees which has supervisors only

1 mins read

Hassan AbdElrahman

Query To get all Employees which has Supervisors only

select ppf.full_name emp_name, ppf1.full_name supervisor_name
from   per_all_people_f ppf, per_all_assignments_f paaf, per_all_people_f ppf1
where  ppf.person_id = paaf.person_id
and    ppf.employee_number is not null
and    sysdate between paaf.effective_start_date and paaf.effective_end_date
and    sysdate between ppf.effective_start_date and ppf.effective_end_date
and    paaf.supervisor_id = ppf1.person_id

Oracle EBS Queries

Hassan AbdElrahman

Oracle ACE Pro ♠ | Oracle Senior ERP Technical ConsultantMaster

Oracle ACE Awarded.
Around 7+ years of experience in Oracle Applications Technical experience in Oracle E-Business Suite R12.
I have written 75+ articles and answered 100+ questions in a related field.
Proficient in Workflows, Data Conversions, Interfaces, Client Extensions, Reports (XML, Bi Publishers, and RDF), and Forms (10g), Alerts, OAF extension.
hands-on experience with oracle mobile supply chain framework JAVA framework.
Hands-on experience with Oracle integration cloud OIC
Excellent knowledge of DATABASE Index’s. Views, Triggers, Procedures, Functions, Database security, Privileges and Optimization.
Played various roles such as designing and development of application Documents and Direct interaction with client to gather requirements.