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

TABLE: BSC.BSC_DB_TABLES

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


BSC_DB_TABLES stores information about data tables. Each row includes table name, table type such as input table or system table, table periodicity and current period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_DB_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
BSC_DB_TABLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIODICITY_ID
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Yes Table name
TABLE_TYPE NUMBER (1) Yes Table type
PERIODICITY_ID NUMBER (5) Yes Periodicity identifier
GENERATION_TYPE NUMBER (3)
1= Default
PROJECT_FLAG NUMBER (1)
Projection Flag 1= Yes, 0 = No
NUM_OF_YEARS NUMBER (3)
Number of years
PREVIOUS_YEARS NUMBER (3)
Number of previous years
SOURCE_DATA_TYPE NUMBER (3)
Data source type 0=Database, 1=Text File, 2=Excel
SOURCE_FILE_NAME VARCHAR2 (500)
File name
CURRENT_PERIOD NUMBER (5)
Current update period
CURRENT_SUBPERIOD NUMBER (3)
Current update sub period
SOURCE_FILE_DATE DATE

File date
EDW_FLAG NUMBER (1)
Flag that indicates if the table is EDW
TARGET_FLAG NUMBER (1)
Target Flag
PROPERTIES VARCHAR2 (4000)
Query Text

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


SELECT TABLE_NAME
,      TABLE_TYPE
,      PERIODICITY_ID
,      GENERATION_TYPE
,      PROJECT_FLAG
,      NUM_OF_YEARS
,      PREVIOUS_YEARS
,      SOURCE_DATA_TYPE
,      SOURCE_FILE_NAME
,      CURRENT_PERIOD
,      CURRENT_SUBPERIOD
,      SOURCE_FILE_DATE
,      EDW_FLAG
,      TARGET_FLAG
,      PROPERTIES
FROM BSC.BSC_DB_TABLES;

Dependencies

[top of page]

BSC.BSC_DB_TABLES does not reference any database object

BSC.BSC_DB_TABLES is referenced by following:

SchemaAPPS
SynonymBSC_DB_TABLES