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_ABC_ASSIGNMENTS

Object Details

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

MTL_ABC_ASSIGNMENTS holds assignments of inventory items to ABC
Classes and ABC Groups.
.
An item can belong to 1 or more ABC Classes, but not more than once in
each ABC Group.
.
An ABC Class can belong to 1 or more ABC Groups, but not more than
once in each ABC Group.
.
The Assign ABC Items window allows the user to specify for a given
ABC Group, the range of items to assign to every single ABC Class in
the ABC Group. The range of items is indicated as an absolute sequence
number or value; or as a percent of item, or value. Then, a
concurrent program (INCAAA) looks at this assignment information and
at the items compiled for that group, and assigns items to their
corresponding classes. This information is stored in
the MTL_ABC_ASSIGNMENTS table.
.
Oracle Inventory uses this information to load the cycle count
process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ABC_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_GROUP_ID INVENTORY_ITEM_ID
MTL_ABC_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID

Columns

Name	Datatype	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory item identifier
ASSIGNMENT_GROUP_ID	NUMBER	Yes	Assignment group identifier
ABC_CLASS_ID	NUMBER	Yes	Identifer of the class to which this item has been assigned in the assignment group
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
REQUEST_ID	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ASSIGNMENT_GROUP_ID
,      ABC_CLASS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_ABC_ASSIGNMENTS;

Dependencies

[top of page]

INV.MTL_ABC_ASSIGNMENTS does not reference any database object

INV.MTL_ABC_ASSIGNMENTS is referenced by following:

INV: MTL_ABC_ASSIGNMENTS#