Reports2017-11-18T12:27:27+00:00

PO Approval Assignments

Description
Categories: Enginatics, Human Resources, Procurement
HR jobs, positions and PO document approval group assignments

select
haou.name ou,
haou2.name hr_organization,
pp.name position,
pjv.name job,
pcf.control_function_name document_type,
pcga.control_group_name approval_group,
pcga.description approval_group_description,
ppca.start_date,
ppca.end_date
from
po_position_controls_all ppca,
hr_all_organization_units haou,
hr_all_organization_units haou2,
per_jobs_vl pjv,
(select pp.* from per_positions pp where sysdate between pp.date_effective and nvl (pp.date_end, sysdate)) pp,
po_control_groups_all pcga,
po_control_functions pcf
where
1=1 and
ppca.org_id=haou.organization_id and
ppca.organization_id=haou2.organization_id(+) and
ppca.job_id=pjv.job_id(+) and
ppca.position_id=pp.position_id(+) and
ppca.control_group_id=pcga.control_group_id(+) and
ppca.control_function_id=pcf.control_function_id(+)
order by
haou.name,
pjv.name,
pp.name,
pcga.control_group_name,
pcf.control_function_name

Parameter Name SQL text Validation
Operating Unit
haou.name=:operating_unit
LOV
Document Type
pcf.control_function_name=:document_type
LOV

By continuing to use the site, you agree to the use of cookies. Accept