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

Object Details

Object Name:	FND_OBJECT_TYPE_MEMBERS#
Object Type:	VIEW
Owner:	APPLSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
OBJECT_ID	NUMBER	(15)	Yes
MEMBER_NAME	VARCHAR2	(240)	Yes
MEMBER_SEQUENCE	NUMBER	(15)	Yes
INNERTYPE_SEQUENCE	NUMBER	(15)	Yes
MEMBER_TYPE	VARCHAR2	(430)
MEMBER_PRECISION	NUMBER	(15)
NULL_ALLOWED	VARCHAR2	(1)	Yes
DESCRIPTION	VARCHAR2	(4000)
ATTRIBUTE_SET	VARCHAR2	(240)
PRIMARY_KEY	VARCHAR2	(1)	Yes
TRANSLATABLE	VARCHAR2	(1)	Yes
COMPOSITE	VARCHAR2	(1)	Yes
MEMBER_SCALE	NUMBER	(15)
MEMBER_TYPE_NAME	VARCHAR2	(400)
SEARCH_CRITERIA_TYPE	VARCHAR2	(30)
ATTACHMENT	VARCHAR2	(1)	Yes
MIME_TYPE	VARCHAR2	(120)
DOMAIN_NAME	VARCHAR2	(120)
DOMAIN_IMPLEMENTATION	VARCHAR2	(400)
IS_SORTABLE	VARCHAR2	(1)
SEARCHID	VARCHAR2	(240)
IS_DATE_BASED	VARCHAR2	(1)
VISIBILITY_LEVEL	VARCHAR2	(8)
IS_DISPLAYED	VARCHAR2	(1)
UI_FUNC_PARAMETER_NAME	VARCHAR2	(240)
CRAWL_INDEXED	VARCHAR2	(1)
CRAWL_STORED	VARCHAR2	(1)
IS_SECURE	VARCHAR2	(1)
IS_TITLE	VARCHAR2	(1)
WEIGHT	NUMBER
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# references the following:

APPLSYS: FND_OBJECT_TYPE_MEMBERS

APPLSYS.FND_OBJECT_TYPE_MEMBERS# is referenced by following:

APPS: FND_OBJECT_TYPE_MEMBERS; FND_OBJECT_TYPE_MEMBERS+