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

Object Details

Object Name:	AMS_USER_STATUSES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_USER_STATUSES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USER_STATUS_ID	NUMBER		Yes	Unique identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
SYSTEM_STATUS_TYPE	VARCHAR2	(30)	Yes	Unique identifier representing system status
ACTIVITY_NAME	VARCHAR2	(80)	Yes	Name of the activity
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	Unique code representing system status
SYSTEM_STATUS_NAME	VARCHAR2	(80)	Yes	Name of the system status
NAME	VARCHAR2	(120)		Name of the user status
DESCRIPTION	VARCHAR2	(4000)		Description of the user status
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if this user status is enabled
SEEDED_FLAG	VARCHAR2	(1)		Flag to indicate if data for this user status is seeded.
DEFAULT_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if this user status has a default value.
START_DATE_ACTIVE	DATE			Date when user status becomes active
END_DATE_ACTIVE	DATE			Date when user status becomes inactive

Query Text

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


SELECT USER_STATUS_ID
,      OBJECT_VERSION_NUMBER
,      SYSTEM_STATUS_TYPE
,      ACTIVITY_NAME
,      SYSTEM_STATUS_CODE
,      SYSTEM_STATUS_NAME
,      NAME
,      DESCRIPTION
,      ENABLED_FLAG
,      SEEDED_FLAG
,      DEFAULT_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.AMS_USER_STATUSES_V;

Dependencies

[top of page]

APPS.AMS_USER_STATUSES_V references the following:

APPS: AMS_LOOKUPS; AMS_USER_STATUSES_VL; FND_LOOKUP_TYPES_VL

APPS.AMS_USER_STATUSES_V is referenced by following:

APPS: AMS_ACTRESOURCE_PVT - show dependent code; AMS_ACT_RESOURCES_V