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_CC_SERIAL_NUMBERS

Object Details

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

This tables is used to store serial numbers associated to a cycle
count entry involving a serialized item. This table is used only
when the user has selected the serial control option "Count: Multiple
Per Request" in the corresponding cycle count header.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CC_SERIAL_NUMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CYCLE_COUNT_ENTRY_ID SERIAL_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CYCLE_COUNT_ENTRY_ID	NUMBER		Yes	Cycle count entry identifier
SERIAL_NUMBER	VARCHAR2	(30)	Yes	Serial number to be counted for the cycle count entry
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
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
NUMBER_OF_COUNTS	NUMBER			Number of times the serial number is counted for the current count
UNIT_STATUS_CURRENT	NUMBER			Current serial number status (Present-1 /Absent-2) at the count location
UNIT_STATUS_PRIOR	NUMBER			Status (Presnt-1 /Absent-2) of the serial number at the time of previous count
POS_ADJUSTMENT_QTY	NUMBER			Adjustment quantity for the serial number (1 if a new serial number is found at the count location)
NEG_ADJUSTMENT_QTY	NUMBER			Negative adjustment quantity (1 if serial number is not found at the count location)
UNIT_STATUS_FIRST	NUMBER			Status of the serial number (Present-1 /Absent - 2) at the time of the first count
APPROVAL_CONDITION	NUMBER			Condition of approval

Query Text

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


SELECT CYCLE_COUNT_ENTRY_ID
,      SERIAL_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      NUMBER_OF_COUNTS
,      UNIT_STATUS_CURRENT
,      UNIT_STATUS_PRIOR
,      POS_ADJUSTMENT_QTY
,      NEG_ADJUSTMENT_QTY
,      UNIT_STATUS_FIRST
,      APPROVAL_CONDITION
FROM INV.MTL_CC_SERIAL_NUMBERS;

Dependencies

[top of page]

INV.MTL_CC_SERIAL_NUMBERS does not reference any database object

INV.MTL_CC_SERIAL_NUMBERS is referenced by following:

APPS: MTL_CC_SERIAL_NUMBERS