[Home] [Help]
[Dependency Information]
Object Name: | BSC_SYS_DATASETS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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;
|
|
|