View: PABV_CLASSES

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_CLASSES

View Text

SELECT PPA.PROJECT_ID
, PCC.CLASS_CATEGORY
, PCC.CLASS_CODE
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECT_CLASSES PPC
, PA_CLASS_CODES PCC
, PA_PROJECTS_ALL PPA
WHERE PPC.PROJECT_ID = PPA.PROJECT_ID
AND PPC.CLASS_CODE = PCC.CLASS_CODE
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns