View: RCV_OPSM_LOT_SERIAL_V | Oracle EBS ETRM Search

The view is based on mtl_lot_numbers, mtl_system_items_kfv and mfg_lookups where the lot number's origination_type is amongst specified origination types.

APPS.MTL_LOT_NUMBERS_ERV·↳ MFG_LOOKUPS·↳ MTL_LOT_NUMBERS·↳ MTL_SYSTEM_ITEMS_KFV·Explore INV module →

View: MTL_MFG_BATCHES_V 12.2.2

INV - Inventory·96 columns

View of gme batches for Genealogy

APPS.MTL_MFG_BATCHES_V·↳ GEM_LOOKUPS·↳ GME_BATCH_HEADER·↳ MTL_SYSTEM_ITEMS·Explore INV module →

View: MTL_MFG_BATCHES_V 12.1.1

INV - Inventory·96 columns

View of gme batches for Genealogy

APPS.MTL_MFG_BATCHES_V·↳ GEM_LOOKUPS·↳ GME_BATCH_HEADER·↳ MTL_SYSTEM_ITEMS·Explore INV module →

Table: WIP_LPN_COMPLETIONS_LOTS 12.1.1 standalone

owner WIP·WIP - Work in Process·87 columns

This table contains lot information for materials being processed in WIP Lpn completions (Mobile Apps)

WIP.WIP_LPN_COMPLETIONS_LOTS·Explore WIP module →

Table: WMS_TRANSACTION_LOTS_TRACE 12.2.2

owner WMS·WMS - Warehouse Management·91 columns

WMS_TRANSACTION_LOTS is history table - This for WMS internal Use only.

WMS.WMS_TRANSACTION_LOTS_TRACE·Explore WMS module →

Table: WMS_LPN_CONTENTS_INTERFACE 12.2.2 satellite-leaning

owner WMS·WMS - Warehouse Management·110 columns

Open interface table for preprocessing LPNs shipped with ASN

WMS.WMS_LPN_CONTENTS_INTERFACE·Explore WMS module →

View: MTL_UNIT_TRANSACTIONS_ALL_V 12.1.1

INV - Inventory·89 columns

10SC ONLY

APPS.MTL_UNIT_TRANSACTIONS_ALL_V·↳ MTL_UNIT_TRANSACTIONS·Explore INV module →

View: MTL_MWB_GTMP_V 12.2.2

INV - Inventory·88 columns

Material Workbench Global Temporary Table View

APPS.MTL_MWB_GTMP_V·↳ MTL_MWB_GTMP·Explore INV module →

View: MTL_SERIAL_NUMBERS_ALL_V 12.1.1

INV - Inventory·117 columns

10SC ONLY

APPS.MTL_SERIAL_NUMBERS_ALL_V·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_STATUSES_TL·↳ MTL_PARAMETERS·Explore INV module →

View: MTL_SERIAL_NUMBERS_TEMP_ERV 12.1.1

INV - Inventory·63 columns

Required by electronic records to snapshot serial numbers.

APPS.MTL_SERIAL_NUMBERS_TEMP_ERV·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS·↳ MTL_SERIAL_NUMBERS_TEMP·Explore INV module →

View: MTL_MFG_BATCHES_SECURITY_V 12.2.2

INV - Inventory·96 columns

View of gme batches with securities for genealogy

APPS.MTL_MFG_BATCHES_SECURITY_V·↳ FND_DATE·↳ FND_MESSAGE·↳ GEM_LOOKUPS·Explore INV module →

View: MTL_WORK_ORDER_HEADER_V 12.2.2

INV - Inventory·112 columns

APPS.MTL_WORK_ORDER_HEADER_V·↳ GEM_LOOKUPS·↳ GME_BATCH_HEADER·↳ GME_MATERIAL_DETAILS·Explore INV module →

View: MTL_WORK_ORDER_HEADER_V 12.1.1

INV - Inventory·112 columns

APPS.MTL_WORK_ORDER_HEADER_V·↳ GEM_LOOKUPS·↳ GME_BATCH_HEADER·↳ GME_MATERIAL_DETAILS·Explore INV module →

Table: MTL_MWB_GTMP 12.2.2 standalone

owner INV·INV - Inventory·88 columns

INV.MTL_MWB_GTMP·Explore INV module →

Table: WIP_LPN_COMPLETIONS_SERIALS 12.2.2 standalone

owner WIP·WIP - Work in Process·73 columns

This table contains serial information for materials being processed in WIP Lpn completions (Mobile Apps)

WIP.WIP_LPN_COMPLETIONS_SERIALS·Explore WIP module →

Table: WMS_SERIAL_NUMBERS_TRACE 12.2.2

owner WMS·WMS - Warehouse Management·74 columns

WMS_SERIAL_NUMBERS_TEMP is a history table . - This for WMS internal Use only.

WMS.WMS_SERIAL_NUMBERS_TRACE·Explore WMS module →

Table: MTL_SERIAL_NUMBERS_INTERFACE 12.1.1 hub-leaning

owner INV·INV - Inventory·141 columns

Temporary serial number storage for transactions processor

INV.MTL_SERIAL_NUMBERS_INTERFACE·Explore INV module →

View: MTL_LOT_NUMBERS_ERV 12.2.2

INV - Inventory·81 columns

APPS.MTL_LOT_NUMBERS_ERV·↳ MFG_LOOKUPS·↳ MTL_LOT_NUMBERS·↳ MTL_MATERIAL_STATUSES·Explore INV module →

Table: MTL_SERIAL_NUMBERS_TEMP 12.1.1 standalone

owner INV·INV - Inventory·144 columns

Temporary serial number holding table

INV.MTL_SERIAL_NUMBERS_TEMP·Explore INV module →

Table: MTL_UNIT_TRANSACTIONS 12.2.2 link

owner INV·INV - Inventory·149 columns

Serial number transactions

INV.MTL_UNIT_TRANSACTIONS·Explore INV module →

Table: MTL_SERIAL_NUMBERS_TEMP 12.2.2 standalone

owner INV·INV - Inventory·144 columns

Temporary serial number holding table

INV.MTL_SERIAL_NUMBERS_TEMP·Explore INV module →

Table: MTL_TRANSACTION_LOTS_TEMP 12.2.2 standalone

owner INV·INV - Inventory·165 columns

Temporary lot numbers holding table

INV.MTL_TRANSACTION_LOTS_TEMP·Explore INV module →

View: MTL_LOT_NUMBERS_ALL_V 12.2.2

INV - Inventory·108 columns

10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL

APPS.MTL_LOT_NUMBERS_ALL_V·↳ AP_SUPPLIERS·↳ MTL_LOT_NUMBERS·↳ MTL_MATERIAL_STATUSES_B·Explore INV module →

View: MTL_SERIAL_NUMBERS_TEMP_ERV 12.2.2

INV - Inventory·63 columns

Required by electronic records to snapshot serial numbers.

APPS.MTL_SERIAL_NUMBERS_TEMP_ERV·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_SERIAL_NUMBERS·↳ MTL_SERIAL_NUMBERS_TEMP·Explore INV module →

Table: MTL_UNIT_TRANSACTIONS 12.1.1 link

owner INV·INV - Inventory·149 columns

Serial number transactions

INV.MTL_UNIT_TRANSACTIONS·Explore INV module →

Table: MTL_MWB_GTMP 12.1.1 standalone

owner INV·INV - Inventory·87 columns

INV.MTL_MWB_GTMP·Explore INV module →

Table: MTL_TRANSACTION_LOT_NUMBERS 12.1.1 link

owner INV·INV - Inventory·158 columns

Transaction lot numbers

INV.MTL_TRANSACTION_LOT_NUMBERS·Explore INV module →

Table: MTL_TRANSACTION_LOTS_INTERFACE 12.1.1 satellite-leaning

owner INV·INV - Inventory·163 columns

Temporary lot storage for transaction processor

INV.MTL_TRANSACTION_LOTS_INTERFACE·Explore INV module →

View: MTL_TRANSACTION_LOTS_TEMP_V 12.1.1

INV - Inventory·89 columns

APPS.MTL_TRANSACTION_LOTS_TEMP_V·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·↳ MTL_TRANSACTION_LOTS_TEMP·↳ MTL_TXN_REQUEST_LINES·Explore INV module →

Table: WMS_LPN_CONTENTS_INTERFACE 12.1.1 satellite-leaning

owner WMS·WMS - Warehouse Management·110 columns

Open interface table for preprocessing LPNs shipped with ASN

WMS.WMS_LPN_CONTENTS_INTERFACE·Explore WMS module →

Table: MTL_SERIAL_NUMBERS 12.2.2 hub

owner INV·INV - Inventory·187 columns

Serial number definitions

INV.MTL_SERIAL_NUMBERS·Explore INV module →

Table: MTL_EAM_ASSET_NUM_INTERFACE 12.1.1 standalone

owner INV·INV - Inventory·106 columns

Asset Number Interface table

INV.MTL_EAM_ASSET_NUM_INTERFACE·Explore INV module →

View: MTL_TRANSACTION_LOT_VAL_V 12.2.2

INV - Inventory·107 columns

10SC ONLY

APPS.MTL_TRANSACTION_LOT_VAL_V·↳ MTL_LOT_NUMBERS·↳ MTL_TRANSACTION_LOT_NUMBERS·Explore INV module →

View: MTL_LOT_NUMBERS_ALL_V 12.1.1

INV - Inventory·108 columns

10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL

APPS.MTL_LOT_NUMBERS_ALL_V·↳ MTL_LOT_NUMBERS·↳ MTL_MATERIAL_STATUSES_B·↳ MTL_MATERIAL_STATUSES_TL·Explore INV module →

Results for “origination_date”