[Home] [Help] [Dependency Information]
Object Name: | PA_STATUS_COLUMN_SETUP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_STATUS_COLUMN_SETUP |
Subobject Name: | |
Status: | VALID |
PA_STATUS_COLUMN_SETUP stores Project Status Inquiry display column
definitions, which are used to generate the project status views.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_STATUS_COLUMN_SETUP_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
FOLDER_CODE
COLUMN_ORDER |
PA_STATUS_COLUMN_SETUP_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
FOLDER_CODE
FORMAT_CODE COLUMN_ORDER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLUMN_NAME | VARCHAR2 | (255) | Name of the column. Uses one of the six LOOKUP_TYPES starting with PSI COL SETUP depending on the FOLDER_CODE and whether the column is text or numeric. | |
COLUMN_PROMPT | VARCHAR2 | (80) | Displayed column prompt | |
FOLDER_CODE | VARCHAR2 | (1) | Yes | Specifies which folder the column is valid for |
COLUMN_ORDER | NUMBER | (15) | Yes | Order that the column is displayed |
FORMAT_CODE | VARCHAR2 | (30) | Yes | Specifies whether column definition is text or numeric |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | 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 | |
CURRENCY_FORMAT_FLAG | VARCHAR2 | (1) | Indicates whether or not column definition should be formatted as a currency | |
TOTAL_FLAG | VARCHAR2 | (1) | Indicator if a total should be displayed: 'Y' to display the total. |
Cut, paste (and edit) the following text to query this object:
SELECT COLUMN_NAME
, COLUMN_PROMPT
, FOLDER_CODE
, COLUMN_ORDER
, FORMAT_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CURRENCY_FORMAT_FLAG
, TOTAL_FLAG
FROM PA.PA_STATUS_COLUMN_SETUP;
PA.PA_STATUS_COLUMN_SETUP does not reference any database object
PA.PA_STATUS_COLUMN_SETUP is referenced by following:
|
|
|