OPI Tables (34)
OPI - Operations Intelligence (Obsolete) — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
EDW_MTL_ILDM_LOCATOR_LSTG |
21 | Staging Table for the LOCATOR level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_OU_LSTG |
26 | Staging Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_OU_LTC |
20 | Level Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_PCMP_LSTG |
22 | Staging Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_PCMP_LTC |
16 | Level Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_PLANT_LSTG |
23 | Staging Table for the Inventory Org level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_PORG_LSTG |
22 | Staging Table for the Inventory Organization Group level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_PORG_LTC |
16 | Level Table for the Inventory Organization Group level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_SUB_INV_LSTG |
20 | Staging Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_ILDM_SUB_INV_LTC |
15 | Level Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension) |
EDW_MTL_INVENTORY_LOC_A_LTC |
5 | Level Table for the A (All) level of the (Inventory Locator Dimension |
EDW_MTL_INVENTORY_LOC_M |
86 | Dimension Table for the(Inventory Locator Dimension |
EDW_MTL_LOCAL_UOM_M |
9 | Local Table of EDW_MTL_UOM_M (Unit Of Measure) Dimension within a source system |
EDW_MTL_UOMD_UOM_LTC |
18 | This is the Unit Of Measure level table in the Unit Of Measure Dimension. |
EDW_MTL_UOM_A_LTC |
5 | Top level table for Unit Of Measure dimension |
EDW_MTL_UOM_M |
19 | Unit Of Measure dimension |
EDW_OPI_ACTV_ACTV_LSTG |
24 | Activity DimensionStaging Table |
EDW_OPI_ACTV_ACTV_LTC |
17 | Activity Dimension Level Table |
EDW_OPI_ACTV_A_LTC |
5 | Activity Dimension All Level Table |
EDW_OPI_ACTV_M |
19 | Activity Dimensiom contains all the Activities of Discrete and Process Manufacturing. |
EDW_OPI_LOTD_LOT_LSTG |
27 | Staging Table for the LOT level of the LOTD (Lot Dimension) |
EDW_OPI_LOTD_LOT_LTC |
21 | Level Table for the LOT level of the LOTD (Lot Dimension) |
EDW_OPI_LOT_A_LTC |
5 | Level Table for the A (All) level of the LOT Dimension |
EDW_OPI_LOT_M |
23 | Dimension Table for the LOT Dimension |
EDW_OPI_OPRN_A_LTC |
5 | Operation Dimension All Level Table |
EDW_OPI_OPRN_M |
29 | Operations Dimension Table |
EDW_OPI_OPRN_OPRC_LSTG |
20 | Operations Class Staging Table |
EDW_OPI_OPRN_OPRC_LTC |
13 | Operation Class Level Table |
EDW_OPI_OPRN_OPRN_LSTG |
24 | Operations Staging Table |
EDW_OPI_OPRN_OPRN_LTC |
17 | Operations Level Table |
EDW_OPI_PRDL_A_LTC |
5 | Level table for the A(All) level of the Production line dimension. |
EDW_OPI_PRDL_M |
18 | Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines |
EDW_OPI_PRDL_PRDL_LSTG |
23 | Level staging table for the Production Line level of the Production Line dimension. |
EDW_OPI_PRDL_PRDL_LTC |
17 | Level table for the Production Line level of the Production Line dimension. |