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_PHYSICAL_ADJUSTMENTS

Object Details

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

MTL_PHYSICAL_ADJUSTMENTS contains all the information about the
adjustment transactions, including the size of the necessary
adjustment, the accounts to which the adjustment transaction was
posted, and the approval-status of each transaction. An adjustment of
zero will still be stored in this table, although it will not cause
an adjustment transaction to be posted. This table will always be
correct and consistent with any tags that have been entered in
MTL_PHYSICAL_INVENTORY_TAGS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_PHYSICAL_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID
MTL_PHYSICAL_ADJUSTMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID PHYSICAL_INVENTORY_ID ADJUSTMENT_ID
MTL_PHYSICAL_ADJUSTMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHYSICAL_INVENTORY_ID APPROVAL_STATUS
MTL_PHYSICAL_ADJUSTMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHYSICAL_INVENTORY_ID INVENTORY_ITEM_ID SUBINVENTORY_NAME
MTL_PHYSICAL_ADJUSTMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHYSICAL_INVENTORY_ID SUBINVENTORY_NAME INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER		Yes	Physical inventory adjustment identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
PHYSICAL_INVENTORY_ID	NUMBER		Yes	Identifier of physical inventory owning the adjustment
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
SUBINVENTORY_NAME	VARCHAR2	(10)	Yes	Subinventory of adjustment
SYSTEM_QUANTITY	NUMBER		Yes	Frozen quantity of this SKU
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_QUANTITY	NUMBER			Quantity of this SKU counted during the physical inventory
ADJUSTMENT_QUANTITY	NUMBER		Yes	Quantity adjustment required to correct frozen quantity to counted quantity
REVISION	VARCHAR2	(3)		Revision of item being adjusted
LOCATOR_ID	NUMBER			Identifier of locator of this SKU
LOT_NUMBER	VARCHAR2	(80)		Lot number of the item being adjusted
LOT_EXPIRATION_DATE	DATE			Expiration date of the lot number of this adjustment
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of the item being adjusted
ACTUAL_COST	NUMBER			Cost per unit of this item
APPROVAL_STATUS	NUMBER	(22)		Whether this adjustment has been approved for transaction or not
APPROVED_BY_EMPLOYEE_ID	NUMBER	(9)		Identifier of employee who approved or rejected this adjustment
AUTOMATIC_APPROVAL_CODE	NUMBER			If this adjustment was approved automatically (not used)
GL_ADJUST_ACCOUNT	NUMBER			Identifier of account to which this adjustment was posted
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
LOT_SERIAL_CONTROLS	VARCHAR2	(1)		Dummy column required by AOL for protected decsriptive flexfield
TEMP_APPROVER	NUMBER	(1)		Dummy column required by AOL
PARENT_LPN_ID	NUMBER			Parent LPN Identifier of the item
OUTERMOST_LPN_ID	NUMBER			Outermost LPN Identifier of the item
COST_GROUP_ID	NUMBER			Cost Group Identifier - Used by WMS only
SECONDARY_SYSTEM_QTY	NUMBER			Secondary System Quantity
SECONDARY_COUNT_QTY	NUMBER			Secondary Count Quantity
SECONDARY_ADJUSTMENT_QTY	NUMBER			Secondary Adjustment Quantity

Query Text

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


SELECT ADJUSTMENT_ID
,      ORGANIZATION_ID
,      PHYSICAL_INVENTORY_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_NAME
,      SYSTEM_QUANTITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COUNT_QUANTITY
,      ADJUSTMENT_QUANTITY
,      REVISION
,      LOCATOR_ID
,      LOT_NUMBER
,      LOT_EXPIRATION_DATE
,      SERIAL_NUMBER
,      ACTUAL_COST
,      APPROVAL_STATUS
,      APPROVED_BY_EMPLOYEE_ID
,      AUTOMATIC_APPROVAL_CODE
,      GL_ADJUST_ACCOUNT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOT_SERIAL_CONTROLS
,      TEMP_APPROVER
,      PARENT_LPN_ID
,      OUTERMOST_LPN_ID
,      COST_GROUP_ID
,      SECONDARY_SYSTEM_QTY
,      SECONDARY_COUNT_QTY
,      SECONDARY_ADJUSTMENT_QTY
FROM INV.MTL_PHYSICAL_ADJUSTMENTS;

Dependencies

[top of page]

INV.MTL_PHYSICAL_ADJUSTMENTS does not reference any database object

INV.MTL_PHYSICAL_ADJUSTMENTS is referenced by following:

INV: MTL_PHYSICAL_ADJUSTMENTS#