[Home] [Help] [Dependency Information]
Object Name: | BSC_DB_TABLES_COLS |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_DB_TABLES_COLS |
Subobject Name: | |
Status: | VALID |
BSC_DB_TABLES_COLS stores information about data table columns. Each row includes table name, colunm type, column name and projection identifier.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_DB_TABLES_COLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TABLE_NAME
COLUMN_TYPE COLUMN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (30) | Yes | Table name |
COLUMN_TYPE | VARCHAR2 | (1) | Yes | Column type |
COLUMN_NAME | VARCHAR2 | (30) | Yes | Column name |
PROJECTION_ID | NUMBER | (3) | Projection identifier | |
SOURCE_COLUMN | VARCHAR2 | (30) | Source Column | |
SOURCE_FORMULA | VARCHAR2 | (4000) | Formula source column | |
SOURCE | VARCHAR2 | (100) |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_NAME
, COLUMN_TYPE
, COLUMN_NAME
, PROJECTION_ID
, SOURCE_COLUMN
, SOURCE_FORMULA
, SOURCE
FROM BSC.BSC_DB_TABLES_COLS;
BSC.BSC_DB_TABLES_COLS does not reference any database object
BSC.BSC_DB_TABLES_COLS is referenced by following:
|
|
|