View: MTL_COUNTRY_ASSIGNMENTS_V | Oracle EBS ETRM Search

View: MTL_COUNTRY_ASSIGNMENTS_V 12.2.2

INV - Inventory·11 columns

View joins territories and country assignments

APPS.MTL_COUNTRY_ASSIGNMENTS_V·↳ FND_TERRITORIES_VL·↳ MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

Table: MTL_COUNTRY_ASSIGNMENTS 12.1.1 link

owner INV·INV - Inventory·9 columns

stores information concerning the assignment of countries to economic zones.

INV.MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

View: MTL_COUNTRY_ASSIGNMENTS_V 12.1.1

INV - Inventory·11 columns

View joins territories and country assignments

APPS.MTL_COUNTRY_ASSIGNMENTS_V·↳ FND_TERRITORIES_VL·↳ MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

Table: MTL_COUNTRY_ASSIGNMENTS 12.2.2 link

owner INV·INV - Inventory·10 columns

stores information concerning the assignment of countries to economic zones.

INV.MTL_COUNTRY_ASSIGNMENTS·Explore INV module →

View: MTL_UNIT_TRANSACTIONS_ALL_V 12.2.2

INV - Inventory·89 columns

10SC ONLY

APPS.MTL_UNIT_TRANSACTIONS_ALL_V·↳ MTL_UNIT_TRANSACTIONS·Explore INV module →

View: MTL_SERIAL_NUMBERS_VAL_V 12.2.2

INV - Inventory·111 columns

10SC ONLY

APPS.MTL_SERIAL_NUMBERS_VAL_V·↳ MTL_SERIAL_NUMBERS·Explore INV 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 →

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_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_SERIAL_NUMBERS_VAL_V 12.1.1

INV - Inventory·111 columns

10SC ONLY

APPS.MTL_SERIAL_NUMBERS_VAL_V·↳ MTL_SERIAL_NUMBERS·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 →

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

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 →

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_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_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_SERIAL_NUMBERS_INTERFACE 12.2.2 hub-leaning

owner INV·INV - Inventory·141 columns

Temporary serial number storage for transactions processor

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

View: MTL_SERIAL_NUMBERS_ALL_V 12.2.2

INV - Inventory·117 columns

10SC ONLY

APPS.MTL_SERIAL_NUMBERS_ALL_V·↳ MFG_LOOKUPS·↳ MTL_MATERIAL_STATUSES_TL·↳ MTL_PARAMETERS·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_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.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_EAM_ASSET_NUM_INTERFACE 12.2.2 standalone

owner INV·INV - Inventory·106 columns

Asset Number Interface table

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

Table: MTL_SERIAL_NUMBERS 12.1.1 hub

owner INV·INV - Inventory·187 columns

Serial number definitions

INV.MTL_SERIAL_NUMBERS·Explore INV module →

View: MTL_MOVEMENT_STATISTICS_V 12.2.2

INV - Inventory

Not implemented in this database·Explore INV module →

View: MTL_MOVEMENT_STATISTICS_V 12.1.1

INV - Inventory

Not implemented in this database·Explore INV module →

View: INVFV_MOVEMENT_STATISTICS 12.2.2

INV - Inventory

- Retrofitted

Not implemented in this database·Explore INV module →

View: INVFV_MOVEMENT_STATISTICS 12.1.1

INV - Inventory

- Retrofitted

Not implemented in this database·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_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 →

Results for “territory_code”