Table: WIP_LPN_COMPLETIONS_LOTS | Oracle EBS ETRM Search

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 →

View: MTL_MFG_BATCHES_SECURITY_V 12.1.1

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 →

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 →

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 →

View: MTL_LOT_NUMBERS_VAL_V 12.2.2

INV - Inventory·98 columns

10SC ONLY

APPS.MTL_LOT_NUMBERS_VAL_V·↳ MTL_LOT_NUMBERS·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 →

View: MTL_TRANSACTION_LOT_VAL_V 12.1.1

INV - Inventory·107 columns

10SC ONLY

APPS.MTL_TRANSACTION_LOT_VAL_V·↳ MTL_LOT_NUMBERS·↳ MTL_TRANSACTION_LOT_NUMBERS·Explore INV 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_LOT_NUMBERS_VAL_V 12.1.1

INV - Inventory·98 columns

10SC ONLY

APPS.MTL_LOT_NUMBERS_VAL_V·↳ MTL_LOT_NUMBERS·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 →

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_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 →

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 →

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_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 →

Table: WMS_TRANSACTION_LOTS_TRACE 12.1.1

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: WIP_LPN_COMPLETIONS_LOTS 12.2.2 standalone

owner WIP·WIP - Work in Process·91 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: MTL_TRANSACTION_LOT_NUMBERS 12.2.2 link

owner INV·INV - Inventory·158 columns

Transaction lot numbers

INV.MTL_TRANSACTION_LOT_NUMBERS·Explore INV module →

Table: MTL_TRANSACTION_LOTS_INTERFACE 12.2.2 satellite-leaning

owner INV·INV - Inventory·163 columns

Temporary lot storage for transaction processor

INV.MTL_TRANSACTION_LOTS_INTERFACE·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 →

View: MTL_TRANSACTION_LOTS_TEMP_V 12.2.2

INV - Inventory·105 columns

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

Table: MTL_LOT_NUMBERS 12.1.1 hub

owner INV·INV - Inventory·150 columns

Lot number definitions

INV.MTL_LOT_NUMBERS·Explore INV module →

Table: MTL_LOT_NUMBERS 12.2.2 hub

owner INV·INV - Inventory·150 columns

Lot number definitions

INV.MTL_LOT_NUMBERS·Explore INV module →

Table: MTL_TRANSACTION_LOTS_TEMP 12.1.1 standalone

owner INV·INV - Inventory·165 columns

Temporary lot numbers holding table

INV.MTL_TRANSACTION_LOTS_TEMP·Explore INV module →

VIEW: WMS.WMS_TRANSACTION_LOTS_TRACE# 12.2.2

VIEW: WIP.WIP_LPN_COMPLETIONS_LOTS# 12.2.2

VIEW: WMS.WMS_LPN_CONTENTS_INTERFACE# 12.2.2

VIEW: INV.MTL_LOT_NUMBERS# 12.2.2

VIEW: INV.MTL_TRANSACTION_LOTS_TEMP# 12.2.2

PACKAGE BODY: APPS.INV_LOT_EO_PVT 12.1.1 PVT API

used by 1

VIEW: INV.MTL_TRANSACTION_LOT_NUMBERS# 12.2.2

PACKAGE: APPS.INV_LOT_EO_PVT 12.1.1 PVT API

used by 1

VIEW: INV.MTL_TRANSACTION_LOTS_INTERFAC# 12.2.2

VIEW: APPS.MTL_LOT_NUMBERS_VAL_V 12.2.2

PACKAGE BODY: APPS.INV_LOT_EO_PVT 12.2.2 PVT API

used by 1

PACKAGE: APPS.INV_LOT_EO_PVT 12.2.2 PVT API

used by 1

TABLE: POS.POS_EXASN_LOTS 12.2.2

owner POS

VIEW: APPS.MTL_LOT_NUMBERS_VAL_V 12.1.1

PACKAGE: APPS.WSM_LOTATTR_PVT 12.1.1 PVT API

used by 4

PACKAGE: APPS.WSM_LOTATTR_PVT 12.2.2 PVT API

used by 4

PACKAGE BODY: APPS.WSM_LOTATTR_PVT 12.2.2 PVT API

used by 4

VIEW: APPS.MTL_TRANSACTION_LOTS_TEMP_V 12.2.2

VIEW: APPS.MTL_LOT_NUMBERS_VAL_V 12.2.2

VIEW: APPS.MTL_TRANSACTION_LOTS_TEMP_V 12.1.1

TABLE: POS.POS_EXASN_LOTS 12.1.1

owner POS

VIEW: WIP.WIP_LPN_COMPLETIONS_LOTS# 12.2.2

owner WIP

Results for “date_code”