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

VIEW: APPS.BSC_BIS_DIM_VL

Object Details
Object Name: BSC_BIS_DIM_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIS.BSC_BIS_DIM_VL
Subobject Name:
Status: VALID

View Type

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


View of Dimensions


[View Source]

Columns
Name Datatype Length Mandatory Comments
DIM_ID NUMBER (5) Yes Dimension level identifier
DIM_NAME VARCHAR2 (255) Yes Dimension level view name
SOURCE VARCHAR2 (4000)
Dimension level view name
SHORT_NAME VARCHAR2 (30)
Short name
APPLICATION_ID NUMBER

Dimension level identifier
DIM_OBJS VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (1024)
HIDE_IN_DESIGN VARCHAR2 (1)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT DIM_ID
,      DIM_NAME
,      SOURCE
,      SHORT_NAME
,      APPLICATION_ID
,      DIM_OBJS
,      DESCRIPTION
,      HIDE_IN_DESIGN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.BSC_BIS_DIM_VL;

Dependencies

[top of page]

APPS.BSC_BIS_DIM_VL references the following:

SchemaAPPS
ViewBIS_DIMENSIONS_VL
PL/SQL PackageBSC_BIS_DIMENSION_PUB - show dependent code
PL/SQL PackageBSC_BIS_DIM_OBJ_PUB - show dependent code
ViewBSC_SYS_DIM_GROUPS_VL
APPS.BSC_BIS_DIM_VL is referenced by following:

SchemaAPPS
Package BodyBSC_BIS_DIMENSION_PUB - show dependent code
Package BodyBSC_BIS_DIM_OBJ_PUB - show dependent code