[Home] [Help] [Dependency Information]
Object Name: | PON_COLORS |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_COLORS |
Subobject Name: | |
Status: | VALID |
PON_COLORS contains the list of allowable colors which will be used in the Live Console graphs. The shapes and the associated image file names are also stored. The colors are used to uniquely identify each supplier's bids on the graphs.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_COLORS_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED | COLOR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLOR_ID | NUMBER | Yes | Unique identifier for each color. | |
COLOR_NAME | VARCHAR2 | (20) | Yes | Name of the color. e.g. RED, BLUE. |
COLOR_HEX_CODE | VARCHAR2 | (20) | Yes | Hexadecimal representation of the color e.g. 'FF0000' represents Red. |
SHAPE | VARCHAR2 | (25) | Yes | Shape associated with the color e.g. 'MS_SQUARE'. The icons for each color have one of five different shapes for easier identification on scatter graphs. |
IMAGE_FILE_NAME | VARCHAR2 | (30) | Yes | Name of the image file containing the icon for the color and its associated shape. |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT COLOR_ID
, COLOR_NAME
, COLOR_HEX_CODE
, SHAPE
, IMAGE_FILE_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM PON.PON_COLORS;
PON.PON_COLORS does not reference any database object
PON.PON_COLORS is referenced by following:
|
|
|