DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_ACCUM_COLUMNS

Object Details
Object Name: PA_ACCUM_COLUMNS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_ACCUM_COLUMNS
Subobject Name:
Status: VALID


PA_ACCUM_COLUMNS holds the configurable columns that are used in
the Project Status Inquiry window (PSI). The table contains the
column names such as 'RAW_COST' and 'BURDENED_COST'.
The column values are held for a given PROJECT_TYPE_CLASS and
ACCUMULATION_CATEGORY.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30) Yes Type of the project for which the column values apply
COLUMN_ID NUMBER (15) Yes Sequence generated id for the Accumulation Column
ACCUM_CATEGORY_CODE VARCHAR2 (30)
Indicates the accumulation category to which this column belongs. For example, 'BUDGETS', 'ACTUALS', or 'COMMITMENTS'.
ACCUM_COLUMN_CODE VARCHAR2 (30)
Column to be summarized
DESCRIPTION VARCHAR2 (255)
The column description
ACCUM_FLAG VARCHAR2 (1)
Indicates whether the column is to be included when summarizing Actuals,Budgets etc.
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_TYPE_CLASS_CODE
,      COLUMN_ID
,      ACCUM_CATEGORY_CODE
,      ACCUM_COLUMN_CODE
,      DESCRIPTION
,      ACCUM_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM PA.PA_ACCUM_COLUMNS;

Dependencies

[top of page]

PA.PA_ACCUM_COLUMNS does not reference any database object

PA.PA_ACCUM_COLUMNS is referenced by following:

SchemaPA
ViewPA_ACCUM_COLUMNS#