[Home] [Help] [Dependency Information]
Object Name: | PA_ACCUM_COLUMNS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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
FROM PA.PA_ACCUM_COLUMNS;
PA.PA_ACCUM_COLUMNS does not reference any database object
PA.PA_ACCUM_COLUMNS is referenced by following:
|
|
|