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

VIEW: APPS.BSC_KPI_TREE_NODES_VL

Object Details
Object Name: BSC_KPI_TREE_NODES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBSC.BSC_KPI_TREE_NODES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


BSC_KPI_TREE_NODES_VL is a view that joins the translated, language specific values from BSC_KPI_TREE_NODES_TL with the non-displayed data from BSC_KPI_TREE_NODES_B. BSC uses this view to display translated information in languages installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes
NODE_ID NUMBER (5) Yes
NAME VARCHAR2 (75) Yes
HELP VARCHAR2 (240) Yes
SIMULATE_FLAG NUMBER (3) Yes
FORMAT_ID NUMBER (3) Yes
COLOR_FLAG NUMBER (3) Yes
COLOR_METHOD NUMBER (3) Yes
NAVIGATES_TO_TREND NUMBER (3) Yes
TOP_POSITION NUMBER (5) Yes
LEFT_POSITION NUMBER (5) Yes
WIDTH NUMBER (5) Yes
HEIGHT NUMBER (5) Yes
AUTOSCALE_FLAG NUMBER

Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)
Query Text

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


SELECT INDICATOR
,      NODE_ID
,      NAME
,      HELP
,      SIMULATE_FLAG
,      FORMAT_ID
,      COLOR_FLAG
,      COLOR_METHOD
,      NAVIGATES_TO_TREND
,      TOP_POSITION
,      LEFT_POSITION
,      WIDTH
,      HEIGHT
,      AUTOSCALE_FLAG
,      Y_AXIS_TITLE
FROM APPS.BSC_KPI_TREE_NODES_VL;

Dependencies

[top of page]

APPS.BSC_KPI_TREE_NODES_VL references the following:

SchemaAPPS
SynonymBSC_KPI_TREE_NODES_B
SynonymBSC_KPI_TREE_NODES_TL
APPS.BSC_KPI_TREE_NODES_VL is referenced by following:

SchemaAPPS
Package BodyBSC_SIMULATION_VIEW_PUB - show dependent code
Package BodyBSC_SIMULATION_VIEW_PVT - show dependent code
PL/SQL PackageBSC_SIMULATION_VIEW_PVT - show dependent code