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

VIEW: APPS.ICX_MTL_DEMAND_ITEM_SUM_V

Object Details
Object Name: ICX_MTL_DEMAND_ITEM_SUM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_MTL_DEMAND_ITEM_SUM_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The ICX_MTL_DEMAND_ITEM_SUM_V view is used in Total Item Availability
inquiry of Web Employees. This view retrieves on-hand and available
quantities of items across all organizations. If the item has
different descriptions and primary units of measures in different
organizations, it will appear more than once in this view.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM VARCHAR2 (40)
Item
DESCRIPTION VARCHAR2 (240)
Item description
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary stocking unit of measure for the item
ONHAND_QUANTITY NUMBER

On-hand quantity
DEMAND_QUANTITY NUMBER

Demanded quantity
HARD_RESERVATION_QUANTITY NUMBER

Hard reservation quantity
SUPPLY_RESERVATION_QUANTITY NUMBER

Supply reservation quantity
TRANSACTABLE_QUANTITY NUMBER

Transactable quantity
NET_AVAILABLE_QUANTITY NUMBER

Net available quantity
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ITEM
,      DESCRIPTION
,      PRIMARY_UNIT_OF_MEASURE
,      ONHAND_QUANTITY
,      DEMAND_QUANTITY
,      HARD_RESERVATION_QUANTITY
,      SUPPLY_RESERVATION_QUANTITY
,      TRANSACTABLE_QUANTITY
,      NET_AVAILABLE_QUANTITY
FROM APPS.ICX_MTL_DEMAND_ITEM_SUM_V;

Dependencies

[top of page]

APPS.ICX_MTL_DEMAND_ITEM_SUM_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewICX_MTL_DEMAND_SUMMARY_V
PL/SQL PackageINV_DECIMALS_PUB - show dependent code

APPS.ICX_MTL_DEMAND_ITEM_SUM_V is not referenced by any database object