DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_BIS_INV_VALUE_V

Object Details
Object Name: MTL_BIS_INV_VALUE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_BIS_INV_VALUE_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Stores Onhand/Intransit quantity and value for Inventory items at organization and intransit owning organizations respectively.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier for the assembly the job or schedule creates.
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code.
QUANTITY NUMBER

Quantity for the inventory items
VALUE NUMBER

Value for the inventory items
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      QUANTITY
,      VALUE
FROM APPS.MTL_BIS_INV_VALUE_V;

Dependencies

[top of page]

APPS.MTL_BIS_INV_VALUE_V references the following:

SchemaAPPS
ViewCST_CG_ITEM_COSTS_VIEW
ViewCST_INTRANSIT_VALUE_VIEW
ViewMTL_ONHAND_QTY_COST_V
SynonymMTL_PARAMETERS

APPS.MTL_BIS_INV_VALUE_V is not referenced by any database object