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: INV.MTL_FLEX_CONTEXT

Object Details

Object Name:	MTL_FLEX_CONTEXT
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_FLEX_CONTEXT
Subobject Name:
Status:	VALID

MTL_FLEX_CONTEXT Stores context mapping for Lot & Serial attributes Descriptive Flex Fields.
You can store context values for an item or Category for structure definition of Lot/Serial attribute Descriptive flex flield.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_FLEX_CONTEXT_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID DESCRIPTIVE_FLEXFIELD_NAME CONTEXT_COLUMN_NAME CONTEXT_COLUMN_VALUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization Id
DESCRIPTIVE_FLEXFIELD_NAME	VARCHAR2	(40)	Yes	Descriptive Flex Field name
CONTEXT_COLUMN_NAME	VARCHAR2	(30)	Yes	Context can be based on Item or Category.This column will store if context it is assigned to Item or Category.
DESCRIPTIVE_FLEX_CONTEXT_CODE	VARCHAR2	(30)	Yes	Context Code
CONTEXT_COLUMN_VALUE_ID	NUMBER		Yes	This has the value of context column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column (For future use only)
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column (For future use only)
CREATION_DATE	DATE		Yes	Standard Who Column (For future use only)
CREATED_BY	NUMBER		Yes	Standard Who Column (For future use only)
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column (For future use only)
REQUEST_ID	NUMBER			Standard Who Column (For future use only)
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column (For future use only)
PROGRAM_ID	NUMBER			Standard Who Column (For future use only)
PROGRAM_UPDATE_DATE	DATE			Standard Who Column (For future use only)
CATEGORY_SET_ID	NUMBER			Category set id if the context_reference = 'Category'

Query Text

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


SELECT ORGANIZATION_ID
,      DESCRIPTIVE_FLEXFIELD_NAME
,      CONTEXT_COLUMN_NAME
,      DESCRIPTIVE_FLEX_CONTEXT_CODE
,      CONTEXT_COLUMN_VALUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CATEGORY_SET_ID
FROM INV.MTL_FLEX_CONTEXT;

Dependencies

[top of page]

INV.MTL_FLEX_CONTEXT does not reference any database object

INV.MTL_FLEX_CONTEXT is referenced by following:

INV: MTL_FLEX_CONTEXT#