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


TABLE: BSC.BSC_USER_KPILIST_PLUGS

Object Details
Object Name: BSC_USER_KPILIST_PLUGS
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_USER_KPILIST_PLUGS
Subobject Name:
Status: VALID


BSC_USER_KPILIST_PLUGS stores information about portlet configuration.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_USER_KPILIST_PLUGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLUG_ID
Columns
Name Datatype Length Mandatory Comments
PLUG_ID NUMBER (20) Yes Plug identifier
DETAILS_FLAG NUMBER (1) Yes Details Flag
GROUP_FLAG NUMBER (1) Yes Group Flag
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REFERENCE_PATH VARCHAR2 (100)
Refence path used for OAFW portlet
KPI_MEASURE_DETAILS_FLAG NUMBER (1)
Flag to show KPI Measures' details in the List of Objectives Portlet
Query Text

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


SELECT PLUG_ID
,      DETAILS_FLAG
,      GROUP_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REFERENCE_PATH
,      KPI_MEASURE_DETAILS_FLAG
FROM BSC.BSC_USER_KPILIST_PLUGS;

Dependencies

[top of page]

BSC.BSC_USER_KPILIST_PLUGS does not reference any database object

BSC.BSC_USER_KPILIST_PLUGS is referenced by following:

SchemaAPPS
SynonymBSC_USER_KPILIST_PLUGS