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_AVAILABLE_INVENTORY_V

Object Details

Object Name:	MTL_AVAILABLE_INVENTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_AVAILABLE_INVENTORY_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
LOCATOR_ID	NUMBER		Locator id is used to get the location
LOT_NUMBER	VARCHAR2	(80)	Lot number from lost master
SUBINVENTORY_CODE	VARCHAR2	(10)	Sub inventory code is used to check the material
CONCATENATED_SEGMENTS	VARCHAR2	(4000)	Item number from different segments
CREATION_DATE	DATE		Lot creation date is used to check validity
EXPIRATION_DATE	DATE		Lot expiration date is used to check the expiry date
GRADE_CODE	VARCHAR2	(150)	Grade code is used to check valid grades
TRANSACTION_TEMP_ID	NUMBER		Temp id is used to identify the existing transactons
REASON_ID	NUMBER		Reason id is used to check get the reason name from the master table
REASON_NAME	VARCHAR2	(30)	Reason Name from master
TRANS_QTY	NUMBER		Transaction qty from the exisiting transactions
TRANS_QTY2	NUMBER		Secondary Transaction qty from the exisiting transactions
TRANSACTION_UOM	VARCHAR2	(3)	Transaction uom from the exisiting transactions
SECONDARY_UOM	VARCHAR2	(3)	Secondary uom from the exisiting transactions
REVISION	VARCHAR2	(3)	Item Revision
ORDER_BY	NUMBER		Order by column is used to show the existing transactions on the top
WMS_RULE_ID	NUMBER		Wms rules id to check the rule

Query Text

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


SELECT LOCATOR_ID
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      CONCATENATED_SEGMENTS
,      CREATION_DATE
,      EXPIRATION_DATE
,      GRADE_CODE
,      TRANSACTION_TEMP_ID
,      REASON_ID
,      REASON_NAME
,      TRANS_QTY
,      TRANS_QTY2
,      TRANSACTION_UOM
,      SECONDARY_UOM
,      REVISION
,      ORDER_BY
,      WMS_RULE_ID
FROM APPS.MTL_AVAILABLE_INVENTORY_V;

Dependencies

[top of page]

APPS.MTL_AVAILABLE_INVENTORY_V references the following:

APPS: INV_PROJECT - show dependent code; MTL_AVAILABLE_INVENTORY_TEMP; MTL_ITEM_LOCATIONS_KFV; MTL_LOT_NUMBERS; MTL_TRANSACTION_REASONS

APPS.MTL_AVAILABLE_INVENTORY_V is not referenced by any database object