Table: MTL_SERIAL_NUMBERS_GT | Oracle EBS ETRM Search

Table: MTL_SERIAL_NUMBERS_GT 12.1.1 standalone

owner INV·INV - Inventory·10 columns

INV.MTL_SERIAL_NUMBERS_GT·Explore INV module →

Table: MTH_OPEN_SALES_ORDERS_F 12.2.2 standalone

owner MTH·MTH - Oracle Manufacturing Operations Center·5 columns

MTH.MTH_OPEN_SALES_ORDERS_F·Explore MTH module →

Table: MTL_AVAILABLE_INVENTORY_TEMP 12.2.2 standalone

owner INV·INV - Inventory·29 columns

INV.MTL_AVAILABLE_INVENTORY_TEMP·Explore INV module →

Table: AHL_MM_TXN_INTERFACE 12.2.2 standalone

owner AHL·AHL - Complex Maintenance Repair and Overhaul·9 columns

AHL.AHL_MM_TXN_INTERFACE·Explore AHL module →

Table: MTH_WO_SALES_ORDERS_I_STG 12.2.2 standalone

owner MTH·MTH - Oracle Manufacturing Operations Center·14 columns

Interface table for MTH_WO_SALES_ORDERS_F

MTH.MTH_WO_SALES_ORDERS_I_STG·Explore MTH module →

View: MTL_GROSS_REQ_COST_V 12.2.2

INV - Inventory·37 columns

- Retrofitted

APPS.MTL_GROSS_REQ_COST_V·↳ CST_CG_ITEM_COSTS_VIEW·↳ MRP_GROSS_REQUIREMENTS·↳ MRP_PROJECT_PARAMETERS·Explore INV module →

Table: MTL_SERIAL_NUMBERS_GT 12.2.2 standalone

owner INV·INV - Inventory·10 columns

INV.MTL_SERIAL_NUMBERS_GT·Explore INV module →

Table: GMO_MATERIAL_DISPENSES 12.1.1 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·39 columns

GMO Material Dispenses

GMO.GMO_MATERIAL_DISPENSES·Explore GMO module →

Table: GMO_DISPENSING_PLANNING 12.1.1 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·14 columns

Dispense Planning Table

GMO.GMO_DISPENSING_PLANNING·Explore GMO module →

View: OKX_QTE_SHIPMENTS_V 12.2.2

OKX - Contracts Integration·49 columns

APPS.OKX_QTE_SHIPMENTS_V·↳ ASO_SHIPMENTS·Explore OKX module →

Table: GMO_DISPENSING_PLANNING 12.2.2 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·14 columns

Dispense Planning Table

GMO.GMO_DISPENSING_PLANNING·Explore GMO module →

View: MRP_SCHEDULE_DATES_V 12.2.2

MRP - Master Scheduling/MRP·62 columns

Schedule entries view

APPS.MRP_SCHEDULE_DATES_V·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·↳ MRP_SCHEDULE_CONSUMPTIONS·Explore MRP module →

View: AHL_MM_WRK_ORDER_RESERVTN_V 12.2.2

AHL - Complex Maintenance Repair and Overhaul·22 columns

APPS.AHL_MM_WRK_ORDER_RESERVTN_V·↳ AHL_CMP_UTIL_PKG·↳ AHL_UNIT_EFFECTIVITIES_B·↳ AHL_VISITS_VL·Explore AHL module →

Table: WMS_TRANSACTIONS_TEMP 12.1.1 link

owner WMS·WMS - Warehouse Management·29 columns

WMS Detailing Temporary Table

WMS.WMS_TRANSACTIONS_TEMP·Explore WMS module →

View: WIP_RESERVATIONS_V 12.1.1

WIP - Work in Process·35 columns

This view is used to select reservations to WIP Discrete Jobs or WIP Flow Schedules.

APPS.WIP_RESERVATIONS_V·↳ INV_CONVERT·↳ MTL_RESERVATIONS·↳ MTL_SALES_ORDERS·Explore WIP module →

Table: WMS_TRANSACTIONS_TEMP 12.2.2 link

owner WMS·WMS - Warehouse Management·29 columns

WMS Detailing Temporary Table

WMS.WMS_TRANSACTIONS_TEMP·Explore WMS module →

Table: GMO_MATERIAL_UNDISPENSES 12.1.1 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·40 columns

GMO Material UNDispenses

GMO.GMO_MATERIAL_UNDISPENSES·Explore GMO module →

Table: GMO_MATERIAL_UNDISPENSES 12.2.2 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·40 columns

GMO Material UNDispenses

GMO.GMO_MATERIAL_UNDISPENSES·Explore GMO module →

View: WIP_RESERVATIONS_V 12.2.2

WIP - Work in Process·35 columns

This view is used to select reservations to WIP Discrete Jobs or WIP Flow Schedules.

APPS.WIP_RESERVATIONS_V·↳ INV_CONVERT·↳ MTL_RESERVATIONS·↳ MTL_SALES_ORDERS·Explore WIP module →

Table: MRP_SCHEDULE_DATES 12.2.2 link

owner MRP·MRP - Master Scheduling/MRP·55 columns

Master production schedule and master demand schedule

MRP.MRP_SCHEDULE_DATES·Explore MRP module →

View: MTL_GROSS_REQ_COST_V 12.1.1

INV - Inventory·37 columns

- Retrofitted

APPS.MTL_GROSS_REQ_COST_V·↳ CST_CG_ITEM_COSTS_VIEW·↳ MRP_GROSS_REQUIREMENTS·↳ MRP_PROJECT_PARAMETERS·Explore INV module →

Table: GMD_MATERIAL_DETAILS_GTMP 12.2.2 standalone

owner GMD·GMD - Process Manufacturing Product Development·72 columns

GMD.GMD_MATERIAL_DETAILS_GTMP·Explore GMD module →

Table: GMO_MATERIAL_DISPENSES 12.2.2 standalone

owner GMO·GMO - Manufacturing Execution System for Process Manufacturing·39 columns

GMO Material Dispenses

GMO.GMO_MATERIAL_DISPENSES·Explore GMO module →

Table: CSP_REQUIREMENT_LINES 12.1.1 link

owner CSP·CSP - Spares Management·41 columns

Parts requirement details.

CSP.CSP_REQUIREMENT_LINES·Explore CSP module →

Table: MRP_GROSS_REQUIREMENTS 12.1.1 satellite-leaning

owner MRP·MRP - Master Scheduling/MRP·39 columns

Gross requirements

MRP.MRP_GROSS_REQUIREMENTS·Explore MRP module →

Table: MRP_GROSS_REQUIREMENTS 12.2.2 satellite-leaning

owner MRP·MRP - Master Scheduling/MRP·39 columns

Gross requirements

MRP.MRP_GROSS_REQUIREMENTS·Explore MRP module →

View: OKX_QTE_SHIPMENTS_V 12.1.1

OKX - Contracts Integration·49 columns

APPS.OKX_QTE_SHIPMENTS_V·↳ ASO_SHIPMENTS·Explore OKX module →

Table: CSP_REQUIREMENT_LINES 12.2.2 link

owner CSP·CSP - Spares Management·41 columns

Parts requirement details.

CSP.CSP_REQUIREMENT_LINES·Explore CSP module →

Table: MRP_SCHEDULE_DATES 12.1.1 link

owner MRP·MRP - Master Scheduling/MRP·55 columns

Master production schedule and master demand schedule

MRP.MRP_SCHEDULE_DATES·Explore MRP module →

Table: LM_SPRD_DTL 12.2.2 link

owner GMD·GMD - Process Manufacturing Product Development·44 columns

Table to store Lab Spreadsheet detail

GMD.LM_SPRD_DTL·Explore GMD module →

View: MTL_RESERVATIONS_ALL_V 12.1.1

INV - Inventory·74 columns

APPS.MTL_RESERVATIONS_ALL_V·↳ MTL_LOT_NUMBERS·↳ MTL_RESERVATIONS·↳ MTL_TXN_SOURCE_TYPES·Explore INV module →

Table: LM_SPRD_DTL 12.1.1 link

owner GMD·GMD - Process Manufacturing Product Development·43 columns

Table to store Lab Spreadsheet detail

GMD.LM_SPRD_DTL·Explore GMD module →

Table: MTL_RESERVATIONS 12.2.2 satellite-leaning

owner INV·INV - Inventory·87 columns

Reservations

INV.MTL_RESERVATIONS·Explore INV module →

Table: WMS_MATERIAL_TXN_TRACE 12.1.1 standalone

owner WMS·WMS - Warehouse Management·228 columns

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

WMS.WMS_MATERIAL_TXN_TRACE·Explore WMS module →

View: CSP_PICK_TRANSACTIONS_V 12.1.1

CSP - Spares Management·197 columns

Material Transactions and Picklist information

APPS.CSP_PICK_TRANSACTIONS_V·↳ CSP_PICKLIST_HEADERS·↳ CSP_PICKLIST_LINES·↳ MTL_MATERIAL_TRANSACTIONS_TEMP·Explore CSP module →

Table: GMD_MATERIAL_DETAILS_GTMP 12.1.1 standalone

owner GMD·GMD - Process Manufacturing Product Development·72 columns

GMD.GMD_MATERIAL_DETAILS_GTMP·Explore GMD module →

Table: WMS_WP_RESERVATIONS_GTMP 12.2.2 standalone

owner WMS·WMS - Warehouse Management·87 columns

WMS.WMS_WP_RESERVATIONS_GTMP·Explore WMS module →

Table: ASO_SHIPMENTS 12.1.1 hub-leaning

owner ASO·ASO - Order Capture·61 columns

ASO_SHIPMENTS store shipping information for a quote at header level or line level.

ASO.ASO_SHIPMENTS·Explore ASO module →

View: ASO_SHIPMENTS_V 12.1.1

ASO - Order Capture·65 columns

APPS.ASO_SHIPMENTS_V·↳ ASO_I_COUNTRIES_V·↳ ASO_I_PARTIES_V·↳ ASO_I_PARTY_SITES_V·Explore ASO module →

View: MTL_RESERVATIONS_ALL_V 12.2.2

INV - Inventory·74 columns

APPS.MTL_RESERVATIONS_ALL_V·↳ MTL_LOT_NUMBERS·↳ MTL_RESERVATIONS·↳ MTL_TXN_SOURCE_TYPES·Explore INV module →

Table: WMS_CARTONIZATION_TEMP1 12.2.2 standalone

owner INV·INV - Inventory·237 columns

INV.WMS_CARTONIZATION_TEMP1·Explore INV module →

Table: ASO_SHIPMENTS 12.2.2 hub-leaning

owner ASO·ASO - Order Capture·61 columns

ASO_SHIPMENTS store shipping information for a quote at header level or line level.

ASO.ASO_SHIPMENTS·Explore ASO module →

View: MRP_SCHEDULE_DATES_V 12.1.1

MRP - Master Scheduling/MRP·62 columns

Schedule entries view

APPS.MRP_SCHEDULE_DATES_V·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·↳ MRP_SCHEDULE_CONSUMPTIONS·Explore MRP module →

Table: MTL_COGS_RECOGNITION_TEMP 12.1.1 standalone

owner INV·INV - Inventory·177 columns

INV.MTL_COGS_RECOGNITION_TEMP·Explore INV module →

Table: MTL_COGS_RECOGNITION_TEMP 12.2.2 standalone

owner INV·INV - Inventory·177 columns

INV.MTL_COGS_RECOGNITION_TEMP·Explore INV module →

Table: MTL_RESERVATIONS 12.1.1 satellite-leaning

owner INV·INV - Inventory·87 columns

Reservations

INV.MTL_RESERVATIONS·Explore INV module →

View: ASO_SHIPMENTS_V 12.2.2

ASO - Order Capture·65 columns

APPS.ASO_SHIPMENTS_V·↳ ASO_I_COUNTRIES_V·↳ ASO_I_PARTIES_V·↳ ASO_I_PARTY_SITES_V·Explore ASO module →

View: MRP_SCHEDULE_ITEM_DATES_V 12.1.1

MRP - Master Scheduling/MRP·71 columns

Master schedule entries view

APPS.MRP_SCHEDULE_ITEM_DATES_V·↳ BOM_CALENDAR_DATES·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·Explore MRP module →

Table: WMS_CARTONIZATION_TEMP 12.1.1 standalone

owner INV·INV - Inventory·236 columns

INV.WMS_CARTONIZATION_TEMP·Explore INV module →

View: ASO_PVT_SHIPMENTS_V 12.1.1

ASO - Order Capture·68 columns

APPS.ASO_PVT_SHIPMENTS_V·↳ ASO_SHIPMENTS·↳ FND_TERRITORIES_VL·↳ HZ_CUST_ACCOUNTS·Explore ASO module →

Results for “reservation_id”