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

TABLE: APPLSYS.FND_OAM_CHARTS

Object Details
Object Name: FND_OAM_CHARTS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_OAM_CHARTS
Subobject Name:
Status: VALID


OAM charts


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_OAM_CHARTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCHART_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CHART_ID NUMBER
Yes Sequence num used to identify the chart.
CHART_GROUP_ID NUMBER
Yes Sequence num used to identify the chart group
DISPLAY_ORDER NUMBER
Yes Display order for OAM UI
ALLOW_CONFIG VARCHAR2 (1) Yes Allow configuration or not
REFRESH_INTERVAL NUMBER
Yes Refresh interval in seconds
REFRESH_TYPE VARCHAR2 (1) Yes Refresh mode, M-Manual, A- AUTO, N-not applicable
CHART_TYPE VARCHAR2 (16) Yes The chart type. It should be recognized by thinGraph
CREATED_BY NUMBER
Yes user_id who created this chart group
CREATION_DATE DATE
Yes Creation date
LAST_UPDATED_BY NUMBER
Yes user_id who last updated this entry
LAST_UPDATE_DATE DATE
Yes Last update date
LAST_UPDATE_LOGIN NUMBER
Yes Logged in user_id who last updated this entry
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CHART_ID
,      CHART_GROUP_ID
,      DISPLAY_ORDER
,      ALLOW_CONFIG
,      REFRESH_INTERVAL
,      REFRESH_TYPE
,      CHART_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM APPLSYS.FND_OAM_CHARTS;

Dependencies

[top of page]

APPLSYS.FND_OAM_CHARTS does not reference any database object

APPLSYS.FND_OAM_CHARTS is referenced by following:

SchemaAPPLSYS
ViewFND_OAM_CHARTS#