Project Accounting – Validation of the Project Starting Organisation per OU

Used to quickly validate the setup and configuration of a implementation.

Select o.name "Operating Unit", o1.name "Project Start Org" 
from PA_IMPLEMENTATIONS_ALL pi, hr_all_organization_units o, hr_all_organization_units o1
where pi.org_id = o.organization_id
and proj_start_org_id = o1.organization_id
and o.name <> o1.name;

Leave a Reply