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]

TABLE: AMS.AMS_CUSTOM_SETUP_ATTR

Object Details

Object Name:	AMS_CUSTOM_SETUP_ATTR
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_CUSTOM_SETUP_ATTR
Subobject Name:
Status:	VALID

This table stores the attributes of a custom setup. These attributes identify what modules are associated to an activity in Oracle Marketing. Some attributes are required for an activity.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_CUSTOM_SETUP_ATTR_U1	NORMAL	UNIQUE	APPS_TS_SEED	SETUP_ATTRIBUTE_ID
AMS_CUSTOM_SETUP_ATTR_U2	NORMAL	UNIQUE	APPS_TS_SEED	CUSTOM_SETUP_ID OBJECT_ATTRIBUTE
AMS_CUSTOM_SETUP_ATTR_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	FUNCTION_NAME
AMS_CUSTOM_SETUP_ATTR_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_FUNCTION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SETUP_ATTRIBUTE_ID	NUMBER		Yes	Unique Identifier
CUSTOM_SETUP_ID	NUMBER		Yes	Custom Setup Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
DISPLAY_SEQUENCE_NO	NUMBER	(3)	Yes	Sequence number in which object attributes are displayed.
OBJECT_ATTRIBUTE	VARCHAR2	(30)	Yes	Object Attributes.
ATTR_MANDATORY_FLAG	VARCHAR2	(1)	Yes	Mandatory Flag indicates what object attributes are must for a custom setup.
ATTR_AVAILABLE_FLAG	VARCHAR2	(1)	Yes	Available Flag indicates what object attributes are available for a custom setup.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FUNCTION_NAME	VARCHAR2	(30)		Security function associated to the attribute.
PARENT_FUNCTION_NAME	VARCHAR2	(30)		Used for setup attribute grouping. If this function is not available through security then all the attributes in this group are also not available.
PARENT_DISPLAY_SEQUENCE	NUMBER			parent_display_sequence is the order in which the parent attributes will be rendered.
PARENT_SETUP_ATTRIBUTE	VARCHAR2	(30)		Indicates the parent attribute for the object attribute
SHOW_IN_CUE_CARD	VARCHAR2	(1)		Flag to indicate whether this attribute will be visible in the cue card
SHOW_IN_REPORT	VARCHAR2	(1)		Flag to indicate whether this attributes details will be printed on metadata reports
RELATED_AK_ATTRIBUTE	VARCHAR2	(30)		Attribute in AK which will provide the jsp details
COPY_ALLOWED_FLAG	VARCHAR2	(1)		Flag to indicate whether this attribute will be displayed as a possible attribute for copy
ESSENTIAL_SEQ_NUM	NUMBER	(3)		Display sequence of the essential attribute

Query Text

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


SELECT SETUP_ATTRIBUTE_ID
,      CUSTOM_SETUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DISPLAY_SEQUENCE_NO
,      OBJECT_ATTRIBUTE
,      ATTR_MANDATORY_FLAG
,      ATTR_AVAILABLE_FLAG
,      SECURITY_GROUP_ID
,      FUNCTION_NAME
,      PARENT_FUNCTION_NAME
,      PARENT_DISPLAY_SEQUENCE
,      PARENT_SETUP_ATTRIBUTE
,      SHOW_IN_CUE_CARD
,      SHOW_IN_REPORT
,      RELATED_AK_ATTRIBUTE
,      COPY_ALLOWED_FLAG
,      ESSENTIAL_SEQ_NUM
FROM AMS.AMS_CUSTOM_SETUP_ATTR;

Dependencies

[top of page]

AMS.AMS_CUSTOM_SETUP_ATTR does not reference any database object

AMS.AMS_CUSTOM_SETUP_ATTR is referenced by following:

APPS: AMS_CUSTOM_SETUP_ATTR