eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BISBV_DIMENSION_LEVELS

Object Details

Object Name:	BISBV_DIMENSION_LEVELS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIS.BISBV_DIMENSION_LEVELS
Subobject Name:
Status:	VALID

View Type

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

BISBV_DIMENSION_LEVELS is is the business view which currently provides an exact copy of the table BIS_LEVELS.
Business Views are intended to provide a consistent interface for ad-hoc queries by providing simple table joins for over-normalized data and plain english column names for hard to undertand columns.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_LEVEL_ID	NUMBER		Yes	Dimension Level ID
DIMENSION_LEVEL_SHORT_NAME	VARCHAR2	(30)	Yes	Dimension Level Short Name
DIMENSION_LEVEL_NAME	VARCHAR2	(255)	Yes	Long name for the dimension level
DESCRIPTION	VARCHAR2	(1024)		Description for the dimension level
DIMENSION_ID	NUMBER		Yes	Dimension ID. The dimension that the level belongs to.
LEVEL_VALUES_VIEW_NAME	VARCHAR2	(30)		View associated to the Level. This view provides the data from the source system for the level.
WHERE_CLAUSE	VARCHAR2	(2000)		No Longer Used
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COMPARISON_LABEL_CODE	VARCHAR2	(30)		Comparison Label Code
ATTRIBUTE_CODE	VARCHAR2	(30)		Attribute Code
APPLICATION_ID	NUMBER			Application Id
VIEW_OBJECT_NAME	VARCHAR2	(255)
DEFAULT_VALUES_API	VARCHAR2	(255)
DEFAULT_SEARCH	VARCHAR2	(480)
LONG_LOV	VARCHAR2	(1)
MASTER_LEVEL	VARCHAR2	(30)
ENABLED	VARCHAR2	(1)		Enabled , T or F

Query Text

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


SELECT DIMENSION_LEVEL_ID
,      DIMENSION_LEVEL_SHORT_NAME
,      DIMENSION_LEVEL_NAME
,      DESCRIPTION
,      DIMENSION_ID
,      LEVEL_VALUES_VIEW_NAME
,      WHERE_CLAUSE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COMPARISON_LABEL_CODE
,      ATTRIBUTE_CODE
,      APPLICATION_ID
,      VIEW_OBJECT_NAME
,      DEFAULT_VALUES_API
,      DEFAULT_SEARCH
,      LONG_LOV
,      MASTER_LEVEL
,      ENABLED
FROM APPS.BISBV_DIMENSION_LEVELS;

Dependencies

[top of page]

APPS.BISBV_DIMENSION_LEVELS references the following:

APPS: BIS_LEVELS; BIS_LEVELS_TL

APPS.BISBV_DIMENSION_LEVELS is referenced by following:

APPS: BIC_TOTAL_CUST_CATEGORY_V; BIC_TOTAL_MARKET_SEGMENT_V; BIL_DIMV_TOT_COMP_PLANS; BIL_DIMV_TOT_JOB_TITLES; BIL_DIMV_TOT_SLSFORCE; BIL_DIMV_TOT_SLSPRODS; BIL_DIMV_TOT_TERRITORY; BIM_DIMV_TOTAL_CAMPAIGNS; BIM_DIMV_TOTAL_CHANNELS; BIM_DIMV_TOTAL_EVENTS; BIM_DIMV_TOTAL_MEDIA; BIM_DIMV_TOTAL_OFFERS; BIM_DIMV_TOT_EVENT_OFRS; BIM_DIMV_TOT_TGT_SGMTS; BIS_COMPUTED_ACTUAL_PVT - show dependent code; BIS_DIMENSION_LEVEL_PVT - show dependent code; BIS_DIM_LEVEL_VALUE_PVT - show dependent code; BIS_PMF_REG_SERVICE_PVT - show dependent code; BIS_REGISTRATION_SERVICE_PUB - show dependent code; BIS_TARGET_PVT - show dependent code; BIS_TOTAL_ACTIVITY_VERSIONS_V; BIS_TOTAL_BUDGETS_V; BIS_TOTAL_CUSTOMERS_V; BIS_TOTAL_GEOGRAPHY_V; BIS_TOTAL_GL_COMPANIES_V; BIS_TOTAL_GL_SECOND_MEASURES_V; BIS_TOTAL_INV_LOCATIONS_V; BIS_TOTAL_JOBS_V; BIS_TOTAL_ORGANIZATIONS_V; BIS_TOTAL_PRODUCTS_V; BIS_TOTAL_SALES_CHANNELS_V; BIS_TOTAL_TIMES_V; BIS_TOTAL_TRAIN_CATEGORIES_V; BIS_UTILITIES_PUB - show dependent code; BIX_TOTAL_CALL_AGENT_V; BSC_PMF_UI_API_PUB - show dependent code; CSTPOMLD - show dependent code; GL_BIS_ALERTS_PKG - show dependent code; HRI_CL_AGE_TOTAL_V; HRI_CL_CMPTNC_TOTAL_V; HRI_CL_GRADE_TOTAL_V; HRI_CL_LOW_TOTAL_V; HRI_CL_PDG_TOTAL_V; HRI_CL_POSITION_TOTAL_V; HRI_CL_RECACT_TOTAL_V; HRI_CL_RQNVAC_TOTAL_V; HRI_CL_RSN_TOTAL_V; HRI_CL_TRNACT_TOTAL_V; HRI_CL_WAC_TOTAL_V; HRI_OLTP_PMV_DYNSQLGEN - show dependent code; ISC_TOTAL_FREIG_CARR_V; ISC_TOTAL_ORIG_DEST_FAC_V; ISC_TOTAL_TRANSP_MODE_V; POA_TOTAL_SUPPLIERS_V; WIP_BIS_UTZ_ALERT - show dependent code; WIP_BIS_YDSP_ALERT - show dependent code