Table: MTH_PLANTS_STG | Oracle EBS ETRM Search

Table: MTH_PLANTS_STG 12.2.2

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

This table will be used to as staging table to load the plants data from CSV

MTH.MTH_PLANTS_STG·Explore MTH module →

Table: MTH_PLANTS_ERR 12.2.2

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

This table will be used to store the error rows when loading data from the staging table to MTH_PLANTS_D table.

MTH.MTH_PLANTS_ERR·Explore MTH module →

Table: MTH_PLANTS_D 12.1.1 standalone

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

MTH.MTH_PLANTS_D·Explore MTH module →

Table: MTH_PLANTS_D 12.2.2 standalone

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

This table stores information for the plant dimension. It provides information like Plant name, Currency code, Plant start date, Plant end date and Graveyard shift definition for the plant.

MTH.MTH_PLANTS_D·Explore MTH module →

VIEW: MTH.MTH_PLANTS_STG# 12.2.2

VIEW: MTH.MTH_PLANTS_D# 12.2.2

VIEW: MTH.MTH_PLANTS_ERR# 12.2.2

VIEW: MTH.MTH_PLANTS_STG# 12.2.2

owner MTH

VIEW: MTH.MTH_PLANTS_ERR# 12.2.2

owner MTH

VIEW: MTH.MTH_PLANTS_D# 12.2.2

owner MTH

VIEW: APPS.MTH_EQUIPMENTS_OCV 12.2.2

VIEW: APPS.MTH_EQUIPMENTS_OCV 12.1.1

TABLE: MTH.MTH_PLANTS_STG 12.2.2

owner MTH

TABLE: MTH.MTH_PLANTS_D 12.1.1

owner MTH

VIEW: APPS.MTH_ALL_ENTITIES_VIEW_V 12.2.2

TABLE: MTH.MTH_PLANTS_D 12.2.2

owner MTH

VIEW: APPS.MTH_ALL_ENTITIES_MV# 12.2.2

VIEW: APPS.MTH_ALL_ENTITIES_V 12.2.2

TABLE: MTH.MTH_PLANTS_ERR 12.2.2

owner MTH

MATERIALIZED VIEW: APPS.MTH_ALL_ENTITIES_MV 12.2.2

APPS.MTH_UTIL_PKG SQL Statements 12.2.2

APPS.MTH_SEED_DATA_PKG SQL Statements 12.2.2

PACKAGE BODY: APPS.MTH_SEED_DATA_PKG 12.2.2

PACKAGE BODY: APPS.MTH_UTIL_PKG 12.2.2

eTRM - MTH Tables and Views 12.2.2

eTRM - MTH Tables and Views 12.1.1

Results for “plant_name”