Update to existing AutoAccounting Rule
Hi, path is:
Project Ledger Sys Admin > Projects CORE > Setup > AutoAccounting > Rules > Query on Rule Name
Value is:
SELECT CASE ppa.project_type
WHEN 'Planned Maintenance' THEN
(SELECT pt.attribute2
FROM pa_projects_all ppa
,pa_expenditure_items_all peia
,pa_tasks pt
WHERE peia.task_id = pt.task_id AND
pt.project_id = ppa.project_id AND
peia.expenditure_item_id =:1)
ELSE
ppa.attribute1
END attribute_value
FROM pa_projects_all ppa
WHERE ppa.project_id =:2
The above statement has existed in our Oracle install since we went live in 2017
It comes to me to try and update to include a 2nd Project Type