The Party Attribute Translation View - HZ_ATTRIBUTE_TRANS_V

SELECT fnd_lookup_values_vl.attribute1, fnd_lookup_values_vl.attribute2,
       fnd_lookup_values_vl.attribute3, fnd_lookup_values_vl.attribute4,
       fnd_lookup_values_vl.lookup_type, fnd_lookup_values_vl.lookup_code,
       fnd_lookup_values_vl.enabled_flag,
       fnd_lookup_values_vl.start_date_active,

Useful Workflow scripts

WF_WORKLIST_V

WF_WORKLIST_V is a view of WF_NOTIFICATIONS that is used to display messages in a work list.

View Definition:

CREATE VIEW WF_WORKLIST_V

AS

Readily available Oralce apps SQL scripts under $AD_TOP/sql

Oracle Applications SQL scripts

Oracle Applications has useful collection of ready SQL scripts under $AD_TOP/sql. The following list shows the description of each script. For more details like if a specific script is available on a specific Apps version you need to check metalink note 108207.1 you will find the script and its description below.

Query To get List of Employees which has Supervisors

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 1=1
AND 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 paaf.supervisor_id=ppf1.person_id
ORDER BY 1