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

TABLE: BSC.BSC_DB_CALCULATIONS

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


BSC_DB_CALCULATIONS stores information about configuration of calculations by table. Each row includes table name, calculation type and parameters.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_DB_CALCULATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
ColumnCALCULATION_TYPE
BSC_DB_CALCULATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALCULATION_TYPE
ColumnPARAMETER1
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Yes Table name
CALCULATION_TYPE NUMBER (1) Yes Calculation type
PARAMETER1 VARCHAR2 (250)
Parameter 1
PARAMETER2 VARCHAR2 (250)
Parameter 2
PARAMETER3 VARCHAR2 (250)
Parameter 3
PARAMETER4 VARCHAR2 (250)
Parameter 4
PARAMETER5 VARCHAR2 (250)
Parameter 5
PARAMETER6 VARCHAR2 (250)
Parameter 6
PARAMETER7 VARCHAR2 (250)
Parameter 7
PARAMETER8 VARCHAR2 (250)
Parameter 8
PARAMETER9 VARCHAR2 (250)
Parameter 9
PARAMETER10 VARCHAR2 (250)
Parameter 10
Query Text

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


SELECT TABLE_NAME
,      CALCULATION_TYPE
,      PARAMETER1
,      PARAMETER2
,      PARAMETER3
,      PARAMETER4
,      PARAMETER5
,      PARAMETER6
,      PARAMETER7
,      PARAMETER8
,      PARAMETER9
,      PARAMETER10
FROM BSC.BSC_DB_CALCULATIONS;

Dependencies

[top of page]

BSC.BSC_DB_CALCULATIONS does not reference any database object

BSC.BSC_DB_CALCULATIONS is referenced by following:

SchemaAPPS
SynonymBSC_DB_CALCULATIONS