GA Project Class Code Details (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Grants Accounting (GMS-Fusion-SQL's)
1

This GA Project Class Code Report query lists project class codes and their descriptions for each project by operating unit, helping users categorize and track project classifications accurately.

#sqlquery

SELECT 
  -- SQL4Fusion (An Orbit Analytics Project)
  -- Lists class codes by project and operating unit
   HAOU.NAME                               ORGANIZATION,
   PPA.SEGMENT1                            PROJECT_NUMBER,
   PPA1.NAME                               PROJECT_NAME,
   PCCT.CLASS_CODE,
   PCCTL.CLASS_CATEGORY,
   PCCT.DESCRIPTION                        CLASS_CODE_DESCRIPTION,
   PCCB.START_DATE_ACTIVE,                 --Active date range for the class code
   PCCB.END_DATE_ACTIVE                    --Active date range for the class code
FROM
  PJF_PROJECTS_ALL_B PPA,
  PJF_PROJECTS_ALL_TL PPA1,
  PJF_PROJECT_CLASSES PPC,
  PJF_CLASS_CODES_TL PCCT,
  PJF_CLASS_CATEGORIES_TL PCCTL,
  PJF_CLASS_CODES_B PCCB,
  HR_ALL_ORGANIZATION_UNITS HAOU
WHERE
  1 = 1
  AND PPA.PROJECT_ID = PPC.PROJECT_ID
  AND HAOU.ORGANIZATION_ID = PPA.ORG_ID
  AND PPC.CLASS_CODE_ID = PCCT.CLASS_CODE_ID
  AND PPC.CLASS_CATEGORY_ID = PCCB.CLASS_CATEGORY_ID
  AND PCCT.CLASS_CODE_ID = PCCB.CLASS_CODE_ID
  AND PPA.PROJECT_ID = PPA1.PROJECT_ID
  AND PCCTL.CLASS_CATEGORY_ID = PCCB.CLASS_CATEGORY_ID
  AND PCCTL.LANGUAGE = USERENV('LANG')
  AND PCCT.LANGUAGE = USERENV('LANG')
  AND PPA1.LANGUAGE = USERENV('LANG')