[Home] [Help] [Dependency Information]
Object Name: | BSC_DB_TABLES |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_DB_TABLES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TABLE_NAME |
BSC_DB_TABLES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERIODICITY_ID |
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) |
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;
BSC.BSC_DB_TABLES does not reference any database object
BSC.BSC_DB_TABLES is referenced by following:
|
|
|