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_BK

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
SETUP_ATTRIBUTE_ID	NUMBER
CUSTOM_SETUP_ID	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
DISPLAY_SEQUENCE_NO	NUMBER	(3)
OBJECT_ATTRIBUTE	VARCHAR2	(30)
ATTR_MANDATORY_FLAG	VARCHAR2	(1)
ATTR_AVAILABLE_FLAG	VARCHAR2	(1)
SECURITY_GROUP_ID	NUMBER
FUNCTION_NAME	VARCHAR2	(30)
PARENT_FUNCTION_NAME	VARCHAR2	(30)
PARENT_DISPLAY_SEQUENCE	NUMBER
PARENT_SETUP_ATTRIBUTE	VARCHAR2	(30)
SHOW_IN_CUE_CARD	VARCHAR2	(1)
SHOW_IN_REPORT	VARCHAR2	(1)
RELATED_AK_ATTRIBUTE	VARCHAR2	(30)
COPY_ALLOWED_FLAG	VARCHAR2	(1)
ESSENTIAL_SEQ_NUM	NUMBER	(3)

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_BK;

Dependencies

[top of page]

AMS.AMS_CUSTOM_SETUP_ATTR_BK does not reference any database object

AMS.AMS_CUSTOM_SETUP_ATTR_BK is referenced by following:

APPS: AMS_CUSTOM_SETUP_ATTR_BK