Query for Approval Assignments

SELECT hou.NAME operating_unit, pj.NAME job, pcf.control_function_name,
       pcga.control_group_name,
       TO_CHAR (ppca.start_date, ‘DD-MON-YY’) start_date,
       TO_CHAR (ppca.end_date, ‘DD-MON-YY’) end_date
  FROM apps.po_position_controls_all ppca,
       apps.po_control_functions pcf,
       apps.hr_operating_units hou,
       apps.per_jobs_tl pj,
       apps.po_control_groups_all pcga
 WHERE ppca.control_function_id = pcf.control_function_id
   AND ppca.org_id = hou.organization_id
   AND ppca.job_id = pj.job_id
   AND pj.LANGUAGE = ‘US’
   AND pj.source_lang = ‘US’
   AND pcga.control_group_id = ppca.control_group_id
   AND ppca.org_id = :ou_name
  • September 27, 2016 | 20 views
  • Comments