View: MTL_TRANSACTION_LOT_VAL_V | Oracle EBS ETRM Search

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 →

View: MTL_OPSM_LOT_EXPORT_V 12.2.2

INV - Inventory·39 columns

APPS.MTL_OPSM_LOT_EXPORT_V·↳ MTL_CROSS_REFERENCES_VL·↳ MTL_LOT_NUMBERS·↳ MTL_PARAMETERS·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_LOTATT_SYNC_REPORT_TEMP 12.2.2

owner INV·INV - Inventory·69 columns

INV.MTL_LOTATT_SYNC_REPORT_TEMP·Explore INV module →

View: MTL_LOT_NUMBERS_ERV 12.1.1

INV - Inventory·79 columns

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 →

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 →

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 →

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 →

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_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: MTL_LOT_NUMBERS 12.1.1 hub

owner INV·INV - Inventory·150 columns

Lot number definitions

INV.MTL_LOT_NUMBERS·Explore INV 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_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 →

PACKAGE: APPS.INV_LOT_ATTRIBUTE_SYNC_PVT 12.2.2 PVT API

used by 1

PACKAGE BODY: APPS.INV_LOT_ATTRIBUTE_SYNC_PVT 12.2.2 PVT API

used by 1

PACKAGE BODY: APPS.MTL_TRANSACTION_LOTS_INTF_PKG 12.2.2

PACKAGE BODY: APPS.INV_INVLTATT_XMLP_PKG 12.2.2

PACKAGE: APPS.INV_INVLTATT_XMLP_PKG 12.2.2

APPS.INV_LOT_ATTRIBUTE_SYNC_PVT SQL Statements 12.2.2

PACKAGE: APPS.MTL_TRANSACTION_LOTS_INTF_PKG 12.1.1

PACKAGE: APPS.MTL_TRANSACTION_LOTS_INTF_PKG 12.2.2

PACKAGE BODY: APPS.MTL_TRANSACTION_LOTS_INTF_PKG 12.1.1

VIEW: APPS.MTL_OPSM_LOT_EXPORT_V 12.2.2

VIEW: WIP.WIP_LPN_COMPLETIONS_LOTS# 12.2.2

VIEW: INV.MTL_LOT_NUMBERS# 12.2.2

VIEW: INV.MTL_TRANSACTION_LOTS_INTERFAC# 12.2.2

VIEW: INV.MTL_TRANSACTION_LOT_NUMBERS# 12.2.2

VIEW: INV.MTL_TRANSACTION_LOTS_TEMP# 12.2.2

TABLE: INV.MTL_LOTATT_SYNC_REPORT_TEMP 12.2.2

owner INV

APPS.INV_INVLTATT_XMLP_PKG SQL Statements 12.2.2

PACKAGE: APPS.MTL_LOT_NUMBERS_PKG 12.2.2

used by 1

PACKAGE BODY: APPS.MTL_LOT_NUMBERS_PKG 12.2.2

used by 1

VIEW: WIP.WIP_LPN_COMPLETIONS_LOTS# 12.2.2

owner WIP

PACKAGE: APPS.INV_LABEL_PVT2 12.2.2

used by 1

PACKAGE: APPS.INV_LABEL_PVT2 12.1.1

used by 1

PACKAGE BODY: APPS.INV_LABEL_PVT2 12.1.1

used by 1

PACKAGE BODY: APPS.INV_LABEL_PVT2 12.2.2

used by 1

VIEW: APPS.MTL_LOT_NUMBERS_ALL_V 12.1.1

VIEW: APPS.MTL_TRANSACTION_LOT_VAL_V 12.2.2

VIEW: INV.MTL_LOT_NUMBERS# 12.2.2

owner INV

VIEW: INV.MTL_TRANSACTION_LOT_NUMBERS# 12.2.2

owner INV

VIEW: APPS.MTL_TRANSACTION_LOT_VAL_V 12.1.1

PACKAGE BODY: APPS.INV_LOT_ATTRIBUTE_SYNC_PVT 12.2.2

APPS.MTL_LOT_NUMBERS_PKG SQL Statements 12.2.2

VIEW: INV.MTL_TRANSACTION_LOTS_INTERFAC# 12.2.2

owner INV

VIEW: APPS.MTL_LOT_NUMBERS_ERV 12.2.2

Results for “expiration_action_date”