DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_CYCLE_COUNT_ENTRIES

Object Details
Object Name: MTL_CYCLE_COUNT_ENTRIES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_CYCLE_COUNT_ENTRIES
Subobject Name:
Status: VALID


MTL_CYCLE_COUNT_ENTRIES stores the actual counts of a cycle count. A
row in this table without a count is considered to be a
count request. Oracle Inventory uses this information to determine
and store cycle count adjustments, recounts, and approval
requirements.
.
When a cycle count adjustment is approved, the count status is set to
completed and the adjustment amount field is populated. The Cycle
Count Approval form then calls a user exit to post an entry in the
MTL_MATERIAL_TRANSACTIONS_TEMP, from which the Oracle Inventory
Transaction Processor picks it up and does the accounting, costing,
and history update.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_CYCLE_COUNT_ENTRIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_ENTRY_ID
MTL_CYCLE_COUNT_ENTRIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_HEADER_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnSUBINVENTORY
ColumnLOCATOR_ID
ColumnREVISION
ColumnLOT_NUMBER
MTL_CYCLE_COUNT_ENTRIES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_HEADER_ID
ColumnORGANIZATION_ID
ColumnSUBINVENTORY
ColumnCOUNT_LIST_SEQUENCE
MTL_CYCLE_COUNT_ENTRIES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_HEADER_ID
ColumnCOUNT_LIST_SEQUENCE
MTL_CYCLE_COUNT_ENTRIES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_HEADER_ID
ColumnINVENTORY_ITEM_ID
MTL_CYCLE_COUNT_ENTRIES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnCREATION_DATE
MTL_CYCLE_COUNT_ENTRIES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTRY_STATUS_CODE
ColumnCOUNT_DUE_DATE
ColumnEXPORT_FLAG
MTL_CYCLE_COUNT_ENTRIES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSTANDARD_OPERATION_ID
MTL_CYCLE_COUNT_ENTRIES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
CYCLE_COUNT_ENTRY_ID NUMBER
Yes Cycle count entry 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
COUNT_LIST_SEQUENCE NUMBER

Sequence number in Count List Report
COUNT_DATE_FIRST DATE

Date of first count
COUNT_DATE_CURRENT DATE

Date of current count
COUNT_DATE_PRIOR DATE

Date of count prior to current
COUNT_DATE_DUMMY DATE

Dummy column required for protected descriptive flexfield
COUNTED_BY_EMPLOYEE_ID_FIRST NUMBER

Identifier of employee who made first count
COUNTED_BY_EMPLOYEE_ID_CURRENT NUMBER

Identifier of employee who made current count
COUNTED_BY_EMPLOYEE_ID_PRIOR NUMBER

Identifier of employee who made count prior to current
COUNTED_BY_EMPLOYEE_ID_DUMMY NUMBER

Dummy column required for protected descriptive flexfield
COUNT_UOM_FIRST VARCHAR2 (3)
Unit of measure of first count
COUNT_UOM_CURRENT VARCHAR2 (3)
Unit of measure of current count
COUNT_UOM_PRIOR VARCHAR2 (3)
Unit of measure of count prior to current
COUNT_QUANTITY_FIRST NUMBER

First count quantity
COUNT_QUANTITY_CURRENT NUMBER

Current count quantity
COUNT_QUANTITY_PRIOR NUMBER

Quantity counted in count prior to current
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SUBINVENTORY VARCHAR2 (10) Yes Subinventory-name
ENTRY_STATUS_CODE NUMBER

Current status of count entry
COUNT_DUE_DATE DATE

Date count is due
ORGANIZATION_ID NUMBER
Yes Organization identifier
CYCLE_COUNT_HEADER_ID NUMBER
Yes Cycle count identifier
NUMBER_OF_COUNTS NUMBER

Number of counts that have been made on this entry
LOCATOR_ID NUMBER

Locator identifier
ADJUSTMENT_QUANTITY NUMBER

Quantity of adjustment to bring system quantity in line with count quantity
ADJUSTMENT_DATE DATE

Date adjustment transaction was posted
ADJUSTMENT_AMOUNT NUMBER

Cost of adjustment transaction
ITEM_UNIT_COST NUMBER

Cost of item per unit
INVENTORY_ADJUSTMENT_ACCOUNT NUMBER

GL account to which adjustment transaction was posted
APPROVAL_DATE DATE

Date adjustment was approved
APPROVER_EMPLOYEE_ID NUMBER

Identifier of employee who approved the adjustment
REVISION VARCHAR2 (3)
Item revision code
LOT_NUMBER VARCHAR2 (80)
Lot number
LOT_CONTROL VARCHAR2 (1)
Dummy column required for protected descriptive flexfield
SYSTEM_QUANTITY_FIRST NUMBER

System quantity at time of first count
SYSTEM_QUANTITY_CURRENT NUMBER

System quantity at time of current count
SYSTEM_QUANTITY_PRIOR NUMBER

System quantity at time of count prior to current
REFERENCE_FIRST VARCHAR2 (240)
Notes pertaining to first count
REFERENCE_CURRENT VARCHAR2 (240)
Notes pertaining to current count
REFERENCE_PRIOR VARCHAR2 (240)
Notes pertaining to count prior to current
PRIMARY_UOM_QUANTITY_FIRST NUMBER

Quantity of first count at item's primary unit of measure
PRIMARY_UOM_QUANTITY_CURRENT NUMBER

Quantity of current count at item's primary unit of measure
PRIMARY_UOM_QUANTITY_PRIOR NUMBER

Quantity of count prior to current at item's primary unit of measure
COUNT_TYPE_CODE NUMBER

Type of count performed
TRANSACTION_REASON_ID NUMBER

Reason adjustment transaction was performed
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
APPROVAL_TYPE NUMBER

Type of approval given
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
SERIAL_NUMBER VARCHAR2 (30)
Serial number to be counted in case of 'ONE SERIAL NUMBER / COUNT' option
SERIAL_DETAIL NUMBER

Detail level of serial count
APPROVAL_CONDITION NUMBER

Condition of approval
NEG_ADJUSTMENT_QUANTITY NUMBER

Quantity of negative adjustment
NEG_ADJUSTMENT_AMOUNT NUMBER

Value of negative adjustment
EXPORT_FLAG NUMBER

Exported Flag, 1 - Yes, 2 - No
PARENT_LPN_ID NUMBER

Parent LPN Identifier of the item.
OUTERMOST_LPN_ID NUMBER

Outermost LPN Identifier of the item.
STANDARD_OPERATION_ID NUMBER

Standard Operation Identifier
TASK_PRIORITY NUMBER

Task Priority
COST_GROUP_ID NUMBER

Cost Group Identifier - Used by WMS only
SECONDARY_UOM_QUANTITY_FIRST NUMBER

QUANITY OF FIRST COUNT IN SECONDARY UNIT OF MEASURE OF ITEM
SECONDARY_UOM_QUANTITY_CURRENT NUMBER

Quantity of current count in secondary unit of measure or item
SECONDARY_UOM_QUANTITY_PRIOR NUMBER

Quantity of count prior to current in secondary unit of measure of item
COUNT_SECONDARY_UOM_FIRST VARCHAR2 (3)
Secondary unit of measure of first count
COUNT_SECONDARY_UOM_CURRENT VARCHAR2 (3)
Secondary Unit of measure of current count
COUNT_SECONDARY_UOM_PRIOR VARCHAR2 (3)
Unit of measure of count prior to current
SECONDARY_ADJUSTMENT_QUANTITY NUMBER

Secondary quantity of adjustment to bring secondary system quantity in line with secondary count quantity
SECONDARY_SYSTEM_QTY_CURRENT NUMBER

Secondary system quantity at time of current count
SECONDARY_SYSTEM_QTY_FIRST NUMBER

Secondary system quantity at time of first count
SECONDARY_SYSTEM_QTY_PRIOR NUMBER

Secondary System Quantity Prior
Query Text

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


SELECT CYCLE_COUNT_ENTRY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COUNT_LIST_SEQUENCE
,      COUNT_DATE_FIRST
,      COUNT_DATE_CURRENT
,      COUNT_DATE_PRIOR
,      COUNT_DATE_DUMMY
,      COUNTED_BY_EMPLOYEE_ID_FIRST
,      COUNTED_BY_EMPLOYEE_ID_CURRENT
,      COUNTED_BY_EMPLOYEE_ID_PRIOR
,      COUNTED_BY_EMPLOYEE_ID_DUMMY
,      COUNT_UOM_FIRST
,      COUNT_UOM_CURRENT
,      COUNT_UOM_PRIOR
,      COUNT_QUANTITY_FIRST
,      COUNT_QUANTITY_CURRENT
,      COUNT_QUANTITY_PRIOR
,      INVENTORY_ITEM_ID
,      SUBINVENTORY
,      ENTRY_STATUS_CODE
,      COUNT_DUE_DATE
,      ORGANIZATION_ID
,      CYCLE_COUNT_HEADER_ID
,      NUMBER_OF_COUNTS
,      LOCATOR_ID
,      ADJUSTMENT_QUANTITY
,      ADJUSTMENT_DATE
,      ADJUSTMENT_AMOUNT
,      ITEM_UNIT_COST
,      INVENTORY_ADJUSTMENT_ACCOUNT
,      APPROVAL_DATE
,      APPROVER_EMPLOYEE_ID
,      REVISION
,      LOT_NUMBER
,      LOT_CONTROL
,      SYSTEM_QUANTITY_FIRST
,      SYSTEM_QUANTITY_CURRENT
,      SYSTEM_QUANTITY_PRIOR
,      REFERENCE_FIRST
,      REFERENCE_CURRENT
,      REFERENCE_PRIOR
,      PRIMARY_UOM_QUANTITY_FIRST
,      PRIMARY_UOM_QUANTITY_CURRENT
,      PRIMARY_UOM_QUANTITY_PRIOR
,      COUNT_TYPE_CODE
,      TRANSACTION_REASON_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      APPROVAL_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SERIAL_NUMBER
,      SERIAL_DETAIL
,      APPROVAL_CONDITION
,      NEG_ADJUSTMENT_QUANTITY
,      NEG_ADJUSTMENT_AMOUNT
,      EXPORT_FLAG
,      PARENT_LPN_ID
,      OUTERMOST_LPN_ID
,      STANDARD_OPERATION_ID
,      TASK_PRIORITY
,      COST_GROUP_ID
,      SECONDARY_UOM_QUANTITY_FIRST
,      SECONDARY_UOM_QUANTITY_CURRENT
,      SECONDARY_UOM_QUANTITY_PRIOR
,      COUNT_SECONDARY_UOM_FIRST
,      COUNT_SECONDARY_UOM_CURRENT
,      COUNT_SECONDARY_UOM_PRIOR
,      SECONDARY_ADJUSTMENT_QUANTITY
,      SECONDARY_SYSTEM_QTY_CURRENT
,      SECONDARY_SYSTEM_QTY_FIRST
,      SECONDARY_SYSTEM_QTY_PRIOR
FROM INV.MTL_CYCLE_COUNT_ENTRIES;

Dependencies

[top of page]

INV.MTL_CYCLE_COUNT_ENTRIES does not reference any database object

INV.MTL_CYCLE_COUNT_ENTRIES is referenced by following:

SchemaINV
ViewMTL_CYCLE_COUNT_ENTRIES#