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: IMC.IMC_OBJECT_METADATA

Object Details

Object Name:	IMC_OBJECT_METADATA
Object Type:	TABLE
Owner:	IMC
FND Design Data:	IMC.IMC_OBJECT_METADATA
Subobject Name:
Status:	VALID

The IMC_OBJECT_METADATA table maintains metadata for objects. The objects are not limited to party types (person, organization, party_relationship) -- they may include opportunities, lleads and other such objects, in future.
Function name, parameter name, menu information (in the additional_value1 column) are stored for each object. More information may be included in the additional_value columns, based on need.
This table is used in conjunction with the Metadata setup page in IMC Admin, and in constructing queries for Recent Items.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IMC_OBJECT_METADATA_U1	NORMAL	UNIQUE	APPS_TS_SEED	METADATA_ID ZD_EDITION_NAME
IMC_OBJECT_METADATA_U2	NORMAL	UNIQUE	APPS_TS_SEED	OBJECT_TYPE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
METADATA_ID	NUMBER	(15)	Yes	Metadata unique identifier
OBJECT_TYPE	VARCHAR2	(50)	Yes	Person, Organization, Party_Relationship, etc.
DESCRIPTION	VARCHAR2	(240)		Description of the object for which metadata is being stored.
FUNCTION_NAME	VARCHAR2	(30)		Name of the function, such as IMC_CUST_PER_OVERVIEW, that represents a page or activity.
PARAMETER_NAME	VARCHAR2	(30)		Parameter required for the function specified.
ENABLED	VARCHAR2	(1)		Should the metadata be considered active?
APPLICATION_ID	NUMBER	(15)		Id of the application which created this entry.
ADDITIONAL_VALUE1	VARCHAR2	(150)		Used to store information pertaining to the JTF Menu hierarchy.
ADDITIONAL_VALUE2	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE3	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE4	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE5	VARCHAR2	(150)		Placeholder for future additional values.
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT METADATA_ID
,      OBJECT_TYPE
,      DESCRIPTION
,      FUNCTION_NAME
,      PARAMETER_NAME
,      ENABLED
,      APPLICATION_ID
,      ADDITIONAL_VALUE1
,      ADDITIONAL_VALUE2
,      ADDITIONAL_VALUE3
,      ADDITIONAL_VALUE4
,      ADDITIONAL_VALUE5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM IMC.IMC_OBJECT_METADATA;

Dependencies

[top of page]

IMC.IMC_OBJECT_METADATA does not reference any database object

IMC.IMC_OBJECT_METADATA is referenced by following:

IMC: IMC_OBJECT_METADATA#