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.BIM_DIMV_USER_STATUSES

Object Details

Object Name:	BIM_DIMV_USER_STATUSES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIM.BIM_DIMV_USER_STATUSES
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

BIM_DIMV_USER_STATUSES is a view showing all user-defined statuses.
.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USER_STATUS_ID	NUMBER		Yes	user status id
SYSTEM_STATUS_TYPE	VARCHAR2	(30)	Yes	system status type
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	system status code
ENABLED_FLAG	VARCHAR2	(1)	Yes	enabled flag
START_DATE_ACTIVE	DATE			active start date
END_DATE_ACTIVE	DATE			active end date
STATUS_NAME	VARCHAR2	(120)		status name
DESCRIPTION	VARCHAR2	(4000)		description

Query Text

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


SELECT USER_STATUS_ID
,      SYSTEM_STATUS_TYPE
,      SYSTEM_STATUS_CODE
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS_NAME
,      DESCRIPTION
FROM APPS.BIM_DIMV_USER_STATUSES;

Dependencies

[top of page]

APPS.BIM_DIMV_USER_STATUSES references the following:

APPS: AMS_USER_STATUSES_VL

APPS.BIM_DIMV_USER_STATUSES is not referenced by any database object