[Home] [Help]
View: PAFV_CLASSES
Product: | PA - Projects |
Description: | Business view to show information about project classifications. |
Implementation/DBA Data: |
APPS.PAFV_CLASSES
|
View Text
SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PCC.CLASS_CATEGORY
, PCC.CLASS_CODE
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_CLASSES PPC
, PA_CLASS_CODES PCC
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
Name |
PROJECT_ID |
PROJECT_NAME |
PROJECT_NUMBER |
CLASS_CATEGORY |
CLASS_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |