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_CAMPAIGN_TEAM_V

Object Details

Object Name:	AMS_CAMPAIGN_TEAM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_CAMPAIGN_TEAM_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	Comments
ACTIVITY_ACCESS_ID	NUMBER		Unique access identifier.
NAME	VARCHAR2	(360)	Name of the resource.
ADMIN_FLAG	VARCHAR2	(1)	Admin Flag indicates whether the resource has view/update privileges on an activity.
ACTIVE_FROM_DATE	DATE		Date from which the resource is active from.
PHONE	VARCHAR2	(2000)	Phone number of the resource.
EMAIL	VARCHAR2	(2000)	Email Id of the resource.
OBJECT_VERSION_NUMBER	NUMBER	(9)	This column is used for locking purposes.
ACT_ACCESS_TO_OBJECT_ID	NUMBER		Unique activity id used across systems.
ARC_ACT_ACCESS_TO_OBJECT	VARCHAR2	(30)	Unique activity code used across systems.
USER_OR_ROLE_ID	NUMBER		Unique Identifier of user or role.
ARC_USER_OR_ROLE_TYPE	VARCHAR2	(30)	User or Role.
CREATION_DATE	DATE		Date on which access is created.
MEANING	VARCHAR2	(80)	Meaning of activity from ams_lookups.
DELETE_FLAG	VARCHAR2	(1)	Groups that are deleted initially will have a delete flag of "N"
OWNER_FLAG	VARCHAR2	(1)	Indicates that the resource is the owner of the object

Query Text

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


SELECT ACTIVITY_ACCESS_ID
,      NAME
,      ADMIN_FLAG
,      ACTIVE_FROM_DATE
,      PHONE
,      EMAIL
,      OBJECT_VERSION_NUMBER
,      ACT_ACCESS_TO_OBJECT_ID
,      ARC_ACT_ACCESS_TO_OBJECT
,      USER_OR_ROLE_ID
,      ARC_USER_OR_ROLE_TYPE
,      CREATION_DATE
,      MEANING
,      DELETE_FLAG
,      OWNER_FLAG
FROM APPS.AMS_CAMPAIGN_TEAM_V;

Dependencies

[top of page]

APPS.AMS_CAMPAIGN_TEAM_V references the following:

APPS: AMS_ACT_ACCESS; AMS_JTF_RS_EMP_V; AMS_LOOKUPS; JTF_RS_GROUPS_VL

APPS.AMS_CAMPAIGN_TEAM_V is not referenced by any database object