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: APPLSYS.FND_OBJECT_TYPE_MEMBERS

Object Details

Object Name:	FND_OBJECT_TYPE_MEMBERS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_OBJECT_TYPE_MEMBERS
Subobject Name:
Status:	VALID

Type members for Integration Repository shaped data

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_OBJECT_TYPE_MEMBERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	OBJECT_ID MEMBER_SEQUENCE INNERTYPE_SEQUENCE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	Pointer to owning object
MEMBER_NAME	VARCHAR2	(240)	Yes	Member Name
MEMBER_SEQUENCE	NUMBER	(15)	Yes	Sequence
INNERTYPE_SEQUENCE	NUMBER	(15)	Yes	Innertype sequence
MEMBER_TYPE	VARCHAR2	(430)		Member Type
MEMBER_PRECISION	NUMBER	(15)		Precision
NULL_ALLOWED	VARCHAR2	(1)	Yes	NUll allowed flag
DESCRIPTION	VARCHAR2	(4000)		Description
ATTRIBUTE_SET	VARCHAR2	(240)		Attribute Set
PRIMARY_KEY	VARCHAR2	(1)	Yes	Member's Primary Key
TRANSLATABLE	VARCHAR2	(1)	Yes	Translatable Flag
COMPOSITE	VARCHAR2	(1)	Yes	Composite Flag
MEMBER_SCALE	NUMBER	(15)		Member Scale
MEMBER_TYPE_NAME	VARCHAR2	(400)		Member Type Name
SEARCH_CRITERIA_TYPE	VARCHAR2	(30)		Search Criteria Type
ATTACHMENT	VARCHAR2	(1)	Yes	Attachment Flag
MIME_TYPE	VARCHAR2	(120)		Mime Type
DOMAIN_NAME	VARCHAR2	(120)		Domain Name
DOMAIN_IMPLEMENTATION	VARCHAR2	(400)		Domain Implementation
IS_SORTABLE	VARCHAR2	(1)		Sortable Flag
SEARCHID	VARCHAR2	(240)		Search engine identifier
IS_DATE_BASED	VARCHAR2	(1)		Flag to indicate if this a date based column
VISIBILITY_LEVEL	VARCHAR2	(8)		Visibility Level (GLOBAL, GUEST, GROUP, or USER)
IS_DISPLAYED	VARCHAR2	(1)		Flag to indicate if this can be displayed
UI_FUNC_PARAMETER_NAME	VARCHAR2	(240)		Name of parameter to construct the linking URL
CRAWL_INDEXED	VARCHAR2	(1)		Flag to indicate if this is to be indexed by search engine
CRAWL_STORED	VARCHAR2	(1)		Flag to indicate if this is to be stored in search engine
IS_SECURE	VARCHAR2	(1)		Flag to indicate if this field is used as security filter
IS_TITLE	VARCHAR2	(1)		Flag to indicate if this is title and will be used as default link
WEIGHT	NUMBER			Search engine weight for this field
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT OBJECT_ID
,      MEMBER_NAME
,      MEMBER_SEQUENCE
,      INNERTYPE_SEQUENCE
,      MEMBER_TYPE
,      MEMBER_PRECISION
,      NULL_ALLOWED
,      DESCRIPTION
,      ATTRIBUTE_SET
,      PRIMARY_KEY
,      TRANSLATABLE
,      COMPOSITE
,      MEMBER_SCALE
,      MEMBER_TYPE_NAME
,      SEARCH_CRITERIA_TYPE
,      ATTACHMENT
,      MIME_TYPE
,      DOMAIN_NAME
,      DOMAIN_IMPLEMENTATION
,      IS_SORTABLE
,      SEARCHID
,      IS_DATE_BASED
,      VISIBILITY_LEVEL
,      IS_DISPLAYED
,      UI_FUNC_PARAMETER_NAME
,      CRAWL_INDEXED
,      CRAWL_STORED
,      IS_SECURE
,      IS_TITLE
,      WEIGHT
,      ZD_EDITION_NAME
FROM APPLSYS.FND_OBJECT_TYPE_MEMBERS;

Dependencies

[top of page]

APPLSYS.FND_OBJECT_TYPE_MEMBERS does not reference any database object

APPLSYS.FND_OBJECT_TYPE_MEMBERS is referenced by following:

APPLSYS: FND_OBJECT_TYPE_MEMBERS#