Table: EDW_OPI_LOTD_LOT_LSTG | Oracle EBS ETRM Search

Table: EDW_OPI_LOTD_LOT_LSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·27 columns

Staging Table for the LOT level of the LOTD (Lot Dimension)

OPI.EDW_OPI_LOTD_LOT_LSTG·Explore OPI module →

Table: OPI_EDW_IDS_NET_CHG 12.1.1

owner OPI·OPI - Operations Intelligence·11 columns

OPI.OPI_EDW_IDS_NET_CHG·Explore OPI module →

Table: OPI_EDW_IPS_NET_CHG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·99 columns

OPI.OPI_EDW_IPS_NET_CHG·Explore OPI module →

Table: EDW_OPI_LOTD_LOT_LTC 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·21 columns

Level Table for the LOT level of the LOTD (Lot Dimension)

OPI.EDW_OPI_LOTD_LOT_LTC·Explore OPI module →

View: EDW_OPI_LOTD_LOT_LCV 12.1.1

OPI - Operations Intelligence·20 columns

This is source view to populate Lot Level data in Lot Dimension

APPS.EDW_OPI_LOTD_LOT_LCV·↳ EDW_LOCAL_INSTANCE·↳ IC_ITEM_MST·↳ IC_LOTS_MST·Explore OPI module →

View: OPI_EDW_OPIINV_DAILY_STAT_FCV 12.1.1

OPI - Operations Intelligence·104 columns

This is the source view for extracting Invetory Daily Transaction Summary data from the discrete Manufacturing source tables.

APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV·↳ CST_COST_GROUPS·↳ EDW_LOCAL_INSTANCE·↳ EDW_TIME_PKG·Explore OPI module →

Table: EDW_OPI_LOTD_LOT_LTC 12.2.2 standalone

owner OPI·OPI - Operations Intelligence (Obsolete)·21 columns

Level Table for the LOT level of the LOTD (Lot Dimension)

OPI.EDW_OPI_LOTD_LOT_LTC·Explore OPI module →

Table: EDW_OPI_LOTD_LOT_LSTG 12.2.2 standalone

owner OPI·OPI - Operations Intelligence (Obsolete)·27 columns

Staging Table for the LOT level of the LOTD (Lot Dimension)

OPI.EDW_OPI_LOTD_LOT_LSTG·Explore OPI module →

Table: OPI_IDS_PUSH_LOG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·67 columns

OPI.OPI_IDS_PUSH_LOG·Explore OPI module →

View: OPI_EDW_OPMINV_DAILY_STAT_FCV 12.1.1

OPI - Operations Intelligence·111 columns

This is the source view for extracting Invetory Daily Transaction Summary data from the Process Manufacturing source tables.

APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV·↳ EDW_CURRENCY·↳ EDW_ITEMS_PKG·↳ EDW_LOCAL_INSTANCE·Explore OPI module →

Table: OPI_EDW_INV_PERD_STAT_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·97 columns

Fact Table for the Inventory Period Status Derived Fact

OPI.OPI_EDW_INV_PERD_STAT_F·Explore OPI module →

Table: OPI_EDW_INV_DAILY_STAT_F_DLOG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·117 columns

Fact Delete log Table for the Inventory Daily Status Fact

OPI.OPI_EDW_INV_DAILY_STAT_F_DLOG·Explore OPI module →

Table: OPI_EDW_INV_DAILY_STAT_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·121 columns

Fact Staging Table for the Inventory Daily Status Fact

OPI.OPI_EDW_INV_DAILY_STAT_FSTG·Explore OPI module →

Table: OPI_EDW_INV_DAILY_STAT_F 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·102 columns

Fact Table for the Inventory Daily Status Fact

OPI.OPI_EDW_INV_DAILY_STAT_F·Explore OPI module →

VIEW: OPI.EDW_OPI_LOTD_LOT_LSTG# 12.2.2

VIEW: OPI.EDW_OPI_LOTD_LOT_LTC# 12.2.2

APPS.EDW_OPI_LOT_M_C SQL Statements 12.1.1

VIEW: OPI.EDW_OPI_LOTD_LOT_LTC# 12.2.2

owner OPI

View: EDW_OPI_LOTD_LOT_LCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This is source view to populate Lot Level data in Lot Dimension

Not implemented in this database·Explore OPI module →

TABLE: OPI.OPI_EDW_IDS_NET_CHG 12.1.1

owner OPI

VIEW: OPI.EDW_OPI_LOTD_LOT_LSTG# 12.2.2

owner OPI

VIEW: APPS.EDW_OPI_LOTD_LOT_LCV 12.1.1

TABLE: OPI.EDW_OPI_LOTD_LOT_LTC 12.1.1

owner OPI

TABLE: OPI.EDW_OPI_LOTD_LOT_LTC 12.2.2

owner OPI

PACKAGE BODY: APPS.OPI_EDW_IDS_CALC 12.1.1

used by 1

PACKAGE: APPS.OPI_EDW_IDS_CALC 12.1.1

used by 1

TABLE: OPI.EDW_OPI_LOTD_LOT_LSTG 12.1.1

owner OPI

PACKAGE BODY: APPS.EDW_OPI_LOT_M_C 12.1.1

APPS.OPI_EDW_IDS_CALC SQL Statements 12.1.1

VIEW: APPS.EDW_OPI_LOTD_LOT_LCV 12.1.1

TABLE: OPI.EDW_OPI_LOTD_LOT_LSTG 12.2.2

owner OPI

APPS.OPI_EDW_OPI_LOT_M_SZ SQL Statements 12.1.1

TABLE: OPI.OPI_EDW_IPS_NET_CHG 12.1.1

owner OPI

PACKAGE: APPS.EDW_OPI_LOT_M_C 12.1.1

APPS.OPI_EDW_INV_DAILY_STAT_F_C SQL Statements 12.1.1

View: OPI_EDW_OPMINV_DAILY_STAT_FCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This is the source view for extracting Invetory Daily Transaction Summary data from the Process Manufacturing source tables.

Not implemented in this database·Explore OPI module →

PACKAGE BODY: APPS.EDW_OPI_LOT_M_C 12.1.1

View: OPI_EDW_OPIINV_DAILY_STAT_FCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This is the source view for extracting Invetory Daily Transaction Summary data from the discrete Manufacturing source tables.

Not implemented in this database·Explore OPI module →

APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C SQL Statements 12.1.1

TABLE: OPI.OPI_IDS_PUSH_LOG 12.1.1

owner OPI

VIEW: APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV 12.1.1

PACKAGE BODY: APPS.OPI_EDW_OPI_LOT_M_SZ 12.1.1

PACKAGE: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

VIEW: APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV 12.1.1

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

TABLE: OPI.OPI_EDW_INV_PERD_STAT_F 12.1.1

owner OPI

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

TABLE: OPI.OPI_EDW_INV_DAILY_STAT_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_INV_DAILY_STAT_FSTG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_INV_DAILY_STAT_F_DLOG 12.1.1

owner OPI

Results for “nettable_flag”