Project Accounting – Example AA Rule for Classifications when you have more than 1 AA Classification

Example Auto Accounting Lookup Rule. Used in the event that you have more than 1 classification setup to be used in auto accounting. Dont forget you’ll need to modify this for your own uses.
SELECT ppc.CLASS_CODE
FROM pa_projects_all ppa,
PA_PROJECT_CLASSES ppc,
PA_CLASS_CODES PCC
WHERE ppa.project_id = ppc.project_id
AND ppa.project_id = :ProjectID
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND PPC.CLASS_CATEGORY = :CategoryName
AND PPC.CLASS_CODE = PCC.CLASS_CODE
AND TRUNC(SYSDATE) BETWEEN PCC.START_DATE_ACTIVE AND NVL(PCC.END_DATE_ACTIVE,SYSDATE+1) ;

Leave a Reply