[Home] [Help]
[Dependency Information]
| Object Name: | BSC_SYS_DATASETS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BSC.BSC_SYS_DATASETS_VL
|
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
BSC_SYS_DATASETS_VL is a view that joins the translated, language specific values from BSC_SYS_DATASETS_TL with the non-displayed data from BSC_SYS_DATASETS_B . BSC uses this view to display translated information in languages installed at your site.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DATASET_ID | NUMBER | (5) | Yes | |
| NAME | VARCHAR2 | (255) | Yes | |
| HELP | VARCHAR2 | (1024) | Yes | |
| MEASURE_ID1 | NUMBER | (5) | Yes | |
| OPERATION | VARCHAR2 | (3) | ||
| MEASURE_ID2 | NUMBER | (5) | ||
| FORMAT_ID | NUMBER | (3) | Yes | |
| COLOR_METHOD | NUMBER | (3) | Yes | |
| PROJECTION_FLAG | NUMBER | (3) | ||
| EDW_FLAG | NUMBER | |||
| AUTOSCALE_FLAG | NUMBER | |||
| Y_AXIS_TITLE | VARCHAR2 | (90) | Y axis title (max 30 chars) | |
| SOURCE | VARCHAR2 | (10) | Source | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DATASET_ID
, NAME
, HELP
, MEASURE_ID1
, OPERATION
, MEASURE_ID2
, FORMAT_ID
, COLOR_METHOD
, PROJECTION_FLAG
, EDW_FLAG
, AUTOSCALE_FLAG
, Y_AXIS_TITLE
, SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.BSC_SYS_DATASETS_VL;
APPS
BSC_SYS_DATASETS_B
BSC_SYS_DATASETS_TL
APPS
BIS_APP_NAMES_RPTS_V
BIS_DISPLAY_MEASURES_V
BSC_ANALYSIS_OPTION_PUB
- show dependent code
BSC_BIS_KPI_CRUD_PUB
- show dependent code
BSC_BIS_KPI_MEAS_PUB
- show dependent code
BSC_BIS_MEASURE_PUB
- show dependent code
BSC_COLOR_UPGRADE
- show dependent code
BSC_DATASETS_PUB
- show dependent code
BSC_DATASETS_PVT
- show dependent code
BSC_DB_MEASURE_BY_DIM_SET_V
BSC_KPI_SERIES_PUB
- show dependent code
BSC_METADATA_DESC
- show dependent code
BSC_MO_UI_PKG
- show dependent code
BSC_OBJ_ANALYSIS_OPTIONS_PUB
- show dependent code
BSC_PMF_UI_WRAPPER
- show dependent code
BSC_SIMULATION_VIEW_PVT
- show dependent code
BSC_SIMULATION_VIEW_PVT
- show dependent code
BSC_UPGRADES
- show dependent code
BSC_UTILITY
- show dependent code
BSC_UTILITY
- show dependent code
|
|
|
|