View: MTL_ONHAND_ATP | Oracle EBS ETRM Search

View: MTL_ONHAND_ATP 12.2.2

INV - Inventory·10 columns

This view would be used by Planning to calculate the ATPable quantity for an item.

APPS.MTL_ONHAND_ATP·↳ MTL_ITEM_LOCATIONS·↳ MTL_LOT_NUMBERS·↳ MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

View: MTL_ONHAND_NET 12.1.1

INV - Inventory·12 columns

The view shows the net onhand quantity and checks the validity of lot number and locator.

APPS.MTL_ONHAND_NET·↳ MTL_ITEM_LOCATIONS·↳ MTL_LOT_NUMBERS·↳ MTL_MATERIAL_STATUSES·Explore INV module →

Table: MTL_MOQD_BACKUP 12.2.2 standalone

owner INV·INV - Inventory·37 columns

Back up table for Inventory onhand

INV.MTL_MOQD_BACKUP·Explore INV module →

Table: MTL_ONHAND_QUANTITIES_DETAIL 12.1.1 standalone

owner INV·INV - Inventory·33 columns

FIFO quantities by control level and receipt

INV.MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

Table: MTL_ONHAND_QUANTITIES_DETAIL 12.2.2 standalone

owner INV·INV - Inventory·33 columns

FIFO quantities by control level and receipt

INV.MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

View: MTL_ONHAND_ATP 12.1.1

INV - Inventory·10 columns

This view would be used by Planning to calculate the ATPable quantity for an item.

APPS.MTL_ONHAND_ATP·↳ MTL_ITEM_LOCATIONS·↳ MTL_LOT_NUMBERS·↳ MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

View: MTL_ONHAND_NET 12.2.2

INV - Inventory·12 columns

APPS.MTL_ONHAND_NET·↳ MTL_ITEM_LOCATIONS·↳ MTL_LOT_NUMBERS·↳ MTL_MATERIAL_STATUSES·Explore INV module →

Table: MTL_MOQD_BACKUP 12.1.1 standalone

owner INV·INV - Inventory·36 columns

Back up table for Inventory onhand

INV.MTL_MOQD_BACKUP·Explore INV module →

APPS.INV_REDUCE_MOQD_PVT SQL Statements 12.1.1

APPS.INV_REDUCE_MOQD_PVT SQL Statements 12.2.2

VIEW: APPS.MTL_NEGATIVE_VIEW 12.2.2

VIEW: APPS.MTL_NEGATIVE_VIEW 12.1.1

PACKAGE: APPS.INV_REDUCE_MOQD_PVT 12.1.1 PVT API

PACKAGE BODY: APPS.INV_REDUCE_MOQD_PVT 12.2.2 PVT API

PACKAGE BODY: APPS.INV_REDUCE_MOQD_PVT 12.1.1 PVT API

PACKAGE: APPS.INV_REDUCE_MOQD_PVT 12.2.2 PVT API

View: MTL_NEGATIVE_VIEW 12.2.2

INV - Inventory·7 columns

View of onhand negative inventory

APPS.MTL_NEGATIVE_VIEW·↳ MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

View: MTL_NEGATIVE_VIEW 12.1.1

INV - Inventory·7 columns

View of onhand negative inventory

APPS.MTL_NEGATIVE_VIEW·↳ MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

VIEW: INV.MTL_ONHAND_QUANTITIES_DETAIL# 12.2.2

VIEW: INV.MTL_ONHAND_QUANTITIES_D_BKP# 12.2.2

VIEW: INV.MTL_ONHAND_DISCREPANCIES# 12.2.2

VIEW: INV.MTL_MOQD_BACKUP# 12.2.2

VIEW: APPS.ICX_MTL_DEMAND_SUMMARY_V 12.1.1

VIEW: APPS.ICX_MTL_DEMAND_SUMMARY_V 12.2.2

View: ICX_MTL_DEMAND_SUMMARY_V 12.1.1

INV - Inventory·13 columns

APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →

View: ICX_MTL_DEMAND_SUMMARY_V 12.1.1

ICX - Oracle iProcurement·13 columns

Item Availability by Organization View

APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ICX module →

View: ICX_MTL_DEMAND_SUMMARY_V 12.2.2

INV - Inventory·13 columns

APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →

View: ICX_MTL_DEMAND_SUMMARY_V 12.2.2

ICX - Oracle iProcurement·13 columns

Item Availability by Organization View

APPS.ICX_MTL_DEMAND_SUMMARY_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ICX module →

APPS.PO_INV_THIRD_PARTY_STOCK_MDTR SQL Statements 12.1.1

VIEW: INV.MTL_ONHAND_QUANTITIES_DETAIL# 12.2.2

owner INV

VIEW: INV.MTL_MOQD_BACKUP# 12.2.2

owner INV

VIEW: APPS.MTL_ONHAND_ATP 12.2.2

VIEW: APPS.MTL_ONHAND_ATP 12.1.1

TABLE: INV.MTL_ONHAND_DISCREPANCIES 12.1.1

owner INV

VIEW: APPS.MTL_SECINV_QUANTITIES_VIEW 12.1.1

VIEW: APPS.MTL_ITEM_LOCATIONS_VIEW 12.2.2

TABLE: INV.MTL_ONHAND_DISCREPANCIES 12.2.2

owner INV

TABLE: INV.MTL_ONHAND_QUANTITIES_D_BKP 12.2.2

owner INV

VIEW: INV.MTL_ONHAND_DISCREPANCIES# 12.2.2

owner INV

VIEW: APPS.MTL_ITEM_QUANTITIES_VIEW 12.1.1

VIEW: APPS.MTL_ITEM_LOCATIONS_VIEW 12.1.1

VIEW: APPS.MTL_SECINV_QUANTITIES_VIEW 12.2.2

TABLE: INV.MTL_ONHAND_QUANTITIES_D_BKP 12.1.1

owner INV

VIEW: INV.MTL_ONHAND_QUANTITIES_D_BKP# 12.2.2

owner INV

VIEW: APPS.MTL_ONHAND_NET 12.2.2

VIEW: APPS.MTL_ITEM_QUANTITIES_VIEW 12.2.2

VIEW: APPS.MTL_ONHAND_NET 12.1.1

APPS.PO_INV_THIRD_PARTY_STOCK_MDTR SQL Statements 12.2.2

View: MTL_SECINV_QUANTITIES_VIEW 12.1.1

INV - Inventory·4 columns

View of Item subinventory

APPS.MTL_SECINV_QUANTITIES_VIEW·↳ MTL_ONHAND_QUANTITIES_DETAIL·Explore INV module →

VIEW: APPS.MTL_ITEM_LOT_QUANTITIES_VIEW 12.2.2

Results for “primary_transaction_quantity”