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_SETUP_TYPES

Object Details

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

This table stores the set type codes required by custom setups. It stores the dispaly sequence of the setup attributes and activity with which these setups can be associated.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_SETUP_TYPES_U1	NORMAL	UNIQUE	APPS_TS_SEED	SETUP_TYPE_ID
AMS_SETUP_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	OBJECT_TYPE
AMS_SETUP_TYPES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	APPLICATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SETUP_TYPE_ID	NUMBER		Yes	Setup Type 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.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of activity.
ACTIVITY_TYPE_CODE	VARCHAR2	(30)		Media type code.
DISPLAY_SEQUENCE_NO	NUMBER	(3)	Yes	Display sequence of setup attribute.
SETUP_ATTRIBUTE	VARCHAR2	(30)	Yes	Setup Attribute code.
MANDATORY_FLAG	VARCHAR2	(1)	Yes	Mandatory falg which indicates that this setup type is must for the activity for which custom setup is being created.
USER_INTERFACE_FUNCTION	VARCHAR2	(240)		User Interface function.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FUNCTION_NAME	VARCHAR2	(30)		Security function associated to the attribute.
PARENT_DISPLAY_SEQUENCE	NUMBER			parent_display_sequence is the order in which the parent attributes will be rendered.
PARENT_FUNCTION_NAME	VARCHAR2	(30)		Attributes for a setup are grouped using this column. If this function is not available through security then all the attributes with in this group are also not available.
PARENT_SETUP_ATTRIBUTE	VARCHAR2	(30)		Lookup used to display the name for the parent attribute group.
SHOW_IN_REPORT	VARCHAR2	(1)		Flag to indicate the attribute to be available on the metadata report
SHOW_IN_CUE_CARD	VARCHAR2	(1)		Flag to indicate whether this attribute will be visible in the cue card
RELATED_AK_ATTRIBUTE	VARCHAR2	(30)		Related AK attribute
APPLICATION_ID	NUMBER			Application Identifier
COPY_ALLOWED_FLAG	VARCHAR2	(1)		Copy allowed flag
ESSENTIAL_SEQ_NUM	NUMBER	(3)		Display Sequence of the Essential Attribute
USAGE	VARCHAR2	(30)		Lite or Classic

Query Text

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


SELECT SETUP_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OBJECT_TYPE
,      ACTIVITY_TYPE_CODE
,      DISPLAY_SEQUENCE_NO
,      SETUP_ATTRIBUTE
,      MANDATORY_FLAG
,      USER_INTERFACE_FUNCTION
,      SECURITY_GROUP_ID
,      FUNCTION_NAME
,      PARENT_DISPLAY_SEQUENCE
,      PARENT_FUNCTION_NAME
,      PARENT_SETUP_ATTRIBUTE
,      SHOW_IN_REPORT
,      SHOW_IN_CUE_CARD
,      RELATED_AK_ATTRIBUTE
,      APPLICATION_ID
,      COPY_ALLOWED_FLAG
,      ESSENTIAL_SEQ_NUM
,      USAGE
FROM AMS.AMS_SETUP_TYPES;

Dependencies

[top of page]

AMS.AMS_SETUP_TYPES does not reference any database object

AMS.AMS_SETUP_TYPES is referenced by following:

APPS: AMS_SETUP_TYPES