[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_OBJECT_TYPE_MEMBERS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
OBJECT_ID
MEMBER_SEQUENCE INNERTYPE_SEQUENCE ZD_EDITION_NAME |
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 |
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;
APPLSYS.FND_OBJECT_TYPE_MEMBERS does not reference any database object
APPLSYS.FND_OBJECT_TYPE_MEMBERS is referenced by following:
|
|
|