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: ViewINV.MTL_GRD_STS_HISTORY_V
Subobject Name:
Status: VALID


View for lot Status , grade change history


[View Source]

Columns
Name Datatype Length Mandatory 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 chaneg 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
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
FROM APPS.MTL_GRD_STS_HISTORY_V;

Dependencies

[top of page]

APPS.MTL_GRD_STS_HISTORY_V references the following:

SchemaAPPS
SynonymMTL_LOT_GRADE_HISTORY
SynonymMTL_MATERIAL_STATUSES
SynonymMTL_MATERIAL_STATUS_HISTORY
SynonymMTL_TRANSACTION_REASONS
APPS.MTL_GRD_STS_HISTORY_V is referenced by following:

SchemaAPPS
Package BodyINV_GENEALOGY_REPORT_GEN - show dependent code