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

TABLE: PON.PON_COLORS

Object Details
Object Name: PON_COLORS
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_COLORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCOLOR_ID
ColumnZD_EDITION_NAME
Columns
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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
,      ZD_EDITION_NAME
FROM PON.PON_COLORS;

Dependencies

[top of page]

PON.PON_COLORS does not reference any database object

PON.PON_COLORS is referenced by following:

SchemaPON
ViewPON_COLORS#