FND Design Data [Home] [Help]

View: PA_ACCUM_COLUMN_VALUES_V

Product: PA - Projects
Description: 10Sc Only
Implementation/DBA Data: ViewAPPS.PA_ACCUM_COLUMN_VALUES_V
View Text

SELECT A.PROJECT_TYPE_CLASS_CODE
, A.COLUMN_ID
, A.ACCUM_CATEGORY_CODE
, A.ACCUM_COLUMN_CODE
, C.MEANING
, B.COLUMN_VALUE
, A.ACCUM_FLAG
FROM PA_ACCUM_COLUMNS A
, PA_ACCUM_COLUMN_VALUES B
, PA_LOOKUPS C
WHERE A.COLUMN_ID = B.COLUMN_ID
AND A.ACCUM_COLUMN_CODE = C.LOOKUP_CODE
AND C.LOOKUP_TYPE = 'ACCUMULATION_COLUMN'

Columns

Name
PROJECT_TYPE_CLASS_CODE
COLUMN_ID
ACCUM_CATEGORY_CODE
ACCUM_COLUMN_CODE
ACCUM_COLUMN_M
COLUMN_VALUE
ACCUM_FLAG