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_CYCLE_COUNT_CLASSES

Object Details

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

MTL_CYCLE_COUNT_CLASSES stores information about cycle count classes
such as associated cycle count name, approval tolerance limits, and
minimum counting frequency.
.
Oracle Inventory uses Cycle Count Classes as a unit for specifying and
defaulting cycle count attributes. The cycle count scheduler uses
counting frequency to determine if the class is eligible, and if so,
how many and which items are eligible for scheduling. The count entry
and approvals form uses tolerance limits to determine if an adjustment
needs to be made.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CYCLE_COUNT_CLASSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID CYCLE_COUNT_HEADER_ID ABC_CLASS_ID

Columns

Name	Datatype	Mandatory	Comments
ABC_CLASS_ID	NUMBER	Yes	ABC class identifier
CYCLE_COUNT_HEADER_ID	NUMBER	Yes	Cycle count identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
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
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
NUM_COUNTS_PER_YEAR	NUMBER		Number of times an item in this class should be counted per year
APPROVAL_TOLERANCE_POSITIVE	NUMBER		Positive percent tolerance, above which an adjustment transaction requires explicit approval
APPROVAL_TOLERANCE_NEGATIVE	NUMBER		Negative percent tolerance, below which an adjustment transaction requires explicit approval
COST_TOLERANCE_POSITIVE	NUMBER		Positive currency tolerance, above which an adjustment transaction requires explicit approval
COST_TOLERANCE_NEGATIVE	NUMBER		Negative currency tolerance, below which an adjustment transaction requires explicit approval
HIT_MISS_TOLERANCE_POSITIVE	NUMBER		Positive percent tolerance used for hit/miss analysis
HIT_MISS_TOLERANCE_NEGATIVE	NUMBER		Negative percent tolerance used for hit/miss analysis
ABC_ASSIGNMENT_GROUP_ID	NUMBER		Identifier of ABC group upon which this class is based
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 ABC_CLASS_ID
,      CYCLE_COUNT_HEADER_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NUM_COUNTS_PER_YEAR
,      APPROVAL_TOLERANCE_POSITIVE
,      APPROVAL_TOLERANCE_NEGATIVE
,      COST_TOLERANCE_POSITIVE
,      COST_TOLERANCE_NEGATIVE
,      HIT_MISS_TOLERANCE_POSITIVE
,      HIT_MISS_TOLERANCE_NEGATIVE
,      ABC_ASSIGNMENT_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_CYCLE_COUNT_CLASSES;

Dependencies

[top of page]

INV.MTL_CYCLE_COUNT_CLASSES does not reference any database object

INV.MTL_CYCLE_COUNT_CLASSES is referenced by following:

INV: MTL_CYCLE_COUNT_CLASSES#