[Home] [Help]
View: PAFV_CLASS_CODES
Product: | PA - Projects |
Description: | Business view to show information on the class codes used to classify projects. |
Implementation/DBA Data: |
APPS.PAFV_CLASS_CODES
|
View Text
SELECT PCCA.CLASS_CATEGORY
, PCC.CLASS_CODE
, PCC.DESCRIPTION
, PCC.START_DATE_ACTIVE
, PCC.END_DATE_ACTIVE
, '_DF:PA:PA_CLASS_CODES_DESC_FLEX:PCC'
, PCC.LAST_UPDATE_DATE
, PCC.LAST_UPDATED_BY
, PCC.CREATION_DATE
, PCC.CREATED_BY
FROM PA_CLASS_CODES PCC
, PA_CLASS_CATEGORIES PCCA
WHERE PCC.CLASS_CATEGORY = PCCA.CLASS_CATEGORY WITH READ ONLY
Columns
Name |
CLASS_CATEGORY |
CLASS_CODE |
DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
"_DF" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |