In this article we'll give a query to list all Key Flexfields (KFFs) available in Oracle E-Business Suite (EBS). A flexfield is a ...
Article
Oraask Latest Articles
Article
Query to get all Personalization applied to Forms in oracle ebs r12
Query to get all Personalization applied to Forms in oracle ebs r12
1 mins read
Simple Query to find form Personalization with Created By and Last Updated by whom:
Article
Query to get invoices unmatched to purchase order
Query to get invoices unmatched to purchase order
1 mins read
Query to find invoices unmatched to purchase order select * from ap_invoices_all ...
Article
Query to get all employees which has supervisors only
Query to get all employees which has supervisors only
1 mins read
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 ...
Article
Query to get all employees and their supervisors (id,name)
Query to get all employees and their supervisors (id,name)
1 mins read
Query to get all employees and their supervisors (id,name) : select distinct papf1.full_name emp_name ...
Article
Query to Get User name and related assigned responsibilities with applications can access
Query to Get User name and related assigned responsibilities with applications can access
1 mins read
Query to Get User name and related assigned responsibilities with applications can access : select distinct ...
Article
Query to get the list of all product tops and their corresponding directories
Query to get the list of all product tops and their corresponding directories
1 mins read
this very simple and useful query will give you the list of all product tops and their corresponding directories : select ...
Article
Query to get all employees with their positions, organizations and usernames
Query to get all employees with their positions, organizations and usernames
1 mins read
Select statement to get all employees with their positions , organizations and usernames even if they doesn't have username :