Table: OPI_PMI_INV_DAILY_STAT_TEMP | Oracle EBS ETRM Search

Table: OPI_PMI_INV_DAILY_STAT_TEMP 12.1.1

owner OPI·OPI - Operations Intelligence·36 columns

OPI.OPI_PMI_INV_DAILY_STAT_TEMP·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 →

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

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_PMI_INV_DAILY_STAT_SUM 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·36 columns

OLTP-Side Summary Table, used for preprocessing IDS Staging Table rows

OPI.OPI_PMI_INV_DAILY_STAT_SUM·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 →

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

APPS.OPI_EDW_IDS_CALC SQL Statements 12.1.1

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

VIEW: APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV 12.1.1

TABLE: OPI.OPI_PMI_INV_DAILY_STAT_TEMP 12.1.1

owner OPI

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 →

TABLE: OPI.OPI_PMI_INV_DAILY_STAT_SUM 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_IPS_NET_CHG 12.1.1

owner OPI

APPS.OPI_EDW_INV_DAILY_STAT_F_C SQL Statements 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 →

PACKAGE BODY: APPS.OPI_EDW_IDS_CALC 12.1.1

APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C SQL Statements 12.1.1

VIEW: APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV 12.1.1

TABLE: OPI.OPI_IDS_PUSH_LOG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_INV_PERD_STAT_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_INV_DAILY_STAT_F_DLOG 12.1.1

owner OPI

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

VIEW: APPS.OPI_EDW_OPIINV_DAILY_STAT_FCV 12.1.1

PACKAGE BODY: APPS.OPI_EDW_INV_DAILY_STAT_F_C 12.1.1

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

VIEW: APPS.OPI_EDW_OPMINV_DAILY_STAT_FCV 12.1.1

APPS.OPIMPXWI SQL Statements 12.1.1

PACKAGE BODY: APPS.OPI_EDW_OPMINV_DAILY_STAT_F_C 12.1.1

APPS.OPI_PMI_IDS_SUMMARY SQL Statements 12.1.1

APPS.OPIMPXWP SQL Statements 12.1.1

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

PACKAGE BODY: APPS.OPI_PMI_IDS_SUMMARY 12.1.1

PACKAGE BODY: APPS.OPIMPXWI 12.1.1

eTRM - OPI Tables and Views 12.1.1

PACKAGE BODY: APPS.OPIMPXWP 12.1.1

Results for “end_onh_val_b”