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]

VIEW: APPS.MTL_GRD_STS_HISTORY_V

Object Details

Object Name:	MTL_GRD_STS_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_GRD_STS_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
HISTORY_ID	NUMBER		Unique identifier for the history row
INVENTORY_ITEM_ID	NUMBER		Internal unique identifier of the item
LOT_NUMBER	VARCHAR2	(80)	Lot number for which the change was made
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number for which the change was made
OLD_VALUE	VARCHAR2	(150)	Old value of the grade/status
NEW_VALUE	VARCHAR2	(150)	New value of grade/status
DATE_STAMP	DATE		Date of change
ACTION	VARCHAR2	(13)	Action performed
PRIMARY_QUANTITY	NUMBER		Quantity in Primary UOM
SECONDARY_QUANTITY	NUMBER		Quantity in Secondary UOM
UPDATE_ON_MOBILE	VARCHAR2	(150)	Mobile action indicator
CHANGE_REASON	VARCHAR2	(30)	Reason code for the change
USER_ID	NUMBER		Oracle Application user id performing the change action
ORGANIZATION_ID	NUMBER		Organization identifier
ACTION_CODE	NUMBER		Code of Action performed
GROUP_ID	NUMBER		Group Identifier
LOCATOR_ID	NUMBER		Locator KFF Identifier
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory Code
PENDING_STATUS	NUMBER		Pending Status Flag

Query Text

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


SELECT HISTORY_ID
,      INVENTORY_ITEM_ID
,      LOT_NUMBER
,      SERIAL_NUMBER
,      OLD_VALUE
,      NEW_VALUE
,      DATE_STAMP
,      ACTION
,      PRIMARY_QUANTITY
,      SECONDARY_QUANTITY
,      UPDATE_ON_MOBILE
,      CHANGE_REASON
,      USER_ID
,      ORGANIZATION_ID
,      ACTION_CODE
,      GROUP_ID
,      LOCATOR_ID
,      SUBINVENTORY_CODE
,      PENDING_STATUS
FROM APPS.MTL_GRD_STS_HISTORY_V;

Dependencies

[top of page]

APPS.MTL_GRD_STS_HISTORY_V references the following:

APPS: MTL_LOT_GRADE_HISTORY; MTL_MATERIAL_STATUSES; MTL_MATERIAL_STATUS_HISTORY; MTL_TRANSACTION_REASONS

APPS.MTL_GRD_STS_HISTORY_V is referenced by following:

APPS: INV_GENEALOGY_REPORT_GEN - show dependent code