Table: OPI_EDW_IDS_NET_CHG | Oracle EBS ETRM Search

This is the product gross margin fact table summarized at period level, and is derived from product gross margin fact. It contains the product sales revenue and the matching cost of goods sold by period.

OPI.OPI_EDW_PERD_MARGIN_F·Explore OPI module →

Table: OPI_EDW_PERD_MARGIN_FT 12.1.1

owner OPI·OPI - Operations Intelligence·49 columns

OPI.OPI_EDW_PERD_MARGIN_FT·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_IPS_NET_CHG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·99 columns

OPI.OPI_EDW_IPS_NET_CHG·Explore OPI module →

Table: OPI_EDW_COGS_F_DLOG 12.1.1

owner OPI·OPI - Operations Intelligence·101 columns

COGS Shipment Fact table

OPI.OPI_EDW_COGS_F_DLOG·Explore OPI module →

Table: ISC_EDW_BOOKINGS_F_DLOG 12.1.1

owner ISC·ISC - Supply Chain Intelligence·119 columns

This is the delete log table for the Bookings fact

ISC.ISC_EDW_BOOKINGS_F_DLOG·Explore ISC 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_COGS_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·152 columns

Interface table for COGS Shipment Fact

OPI.OPI_EDW_COGS_FSTG·Explore OPI module →

Table: ISC_EDW_BACKLOGS_FSTG 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·119 columns

Interface table for the Backlog Snapshot fact

ISC.ISC_EDW_BACKLOGS_FSTG·Explore ISC 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: ISC_EDW_BOOKINGS_FSTG 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·172 columns

Interface table for the Bookings fact

ISC.ISC_EDW_BOOKINGS_FSTG·Explore ISC module →

VIEW: APPS.OPI_EDW_INV_TURNS_QTR_V 12.1.1

View: OPI_EDW_PRODUCT_SALES_REV_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Product Sales Revenue report source view

Not implemented in this database·Explore OPI module →

View: OPI_EDW_INV_TURNS_QTR_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Inventory Turns (Quarter Level) report source view

Not implemented in this database·Explore OPI module →

VIEW: APPS.OPI_EDW_PRODUCT_SALES_REV_V 12.1.1

TABLE: OPI.OPI_EDW_IDS_NET_CHG 12.1.1

owner OPI

VIEW: APPS.OPI_EDW_INV_TURNS_YR_V 12.1.1

View: OPI_EDW_INV_TURNS_YR_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Inventory Turns (Year Level) report source view

Not implemented in this database·Explore OPI module →

View: OPI_EDW_INV_TURNS_QTR_V 12.1.1

OPI - Operations Intelligence·10 columns

Inventory Turns (Quarter Level) report source view

APPS.OPI_EDW_INV_TURNS_QTR_V·↳ EDW_MTL_INVENTORY_LOC_M·↳ EDW_TIME_M·↳ OPI_EDW_INV_PERD_STAT_F·Explore OPI module →

View: OPI_EDW_INV_TURNS_YR_V 12.1.1

OPI - Operations Intelligence·11 columns

Inventory Turns (Year Level) report source view

APPS.OPI_EDW_INV_TURNS_YR_V·↳ EDW_ITEMS_M·↳ EDW_MTL_INVENTORY_LOC_M·↳ EDW_TIME_M·Explore OPI module →

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

View: OPI_EDW_PRODUCT_SALES_REV_V 12.1.1

OPI - Operations Intelligence·27 columns

Product Sales Revenue report source view

APPS.OPI_EDW_PRODUCT_SALES_REV_V·↳ EDW_GEOGRAPHY_M·↳ EDW_ITEMS_M·↳ EDW_OE_SLCHNL_M·Explore OPI module →

TABLE: ENI.EDW_ITEM_ITEMREV_LTC 12.1.1

owner ENI

TABLE: OPI.OPI_EDW_MRG_KEYS 12.1.1

owner OPI

TABLE: OPI.MLOG$_OPI_EDW_MARGIN_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_MRG_MAX_VALUES 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_MARGIN_PERD_FDLG 12.1.1

owner OPI

View: EDW_CST_COGS_F_IV 12.1.1

INV - Inventory

Not implemented in this database·Explore INV module →

View: EDW_CST_COGS_F_IV 12.2.2

INV - Inventory

Not implemented in this database·Explore INV module →

TABLE: OPI.OPI_EDW_PERD_MARGIN_FUR 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_PERD_MARGIN_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_PERD_MARGIN_FT 12.1.1

owner OPI

VIEW: APPS.OPI_EDW_INV_TURNS_PERD_V 12.1.1

TABLE: ENI.EDW_ITEM_ITEMREV_LSTG 12.1.1

owner ENI

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

View: OPI_EDW_INV_TURNS_PERD_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Inventory Turns (Period Level) report source view

Not implemented in this database·Explore OPI module →

View: OPI_EDW_INV_TURNS_PERD_V 12.1.1

OPI - Operations Intelligence·10 columns

Inventory Turns (Period Level) report source view

APPS.OPI_EDW_INV_TURNS_PERD_V·↳ EDW_MTL_INVENTORY_LOC_M·↳ EDW_TIME_M·↳ OPI_EDW_INV_PERD_STAT_F·Explore OPI module →

TABLE: OPI.OPI_EDW_MARGIN_F 12.1.1

owner OPI

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

TABLE: OPI.OPI_EDW_INV_PERD_STAT_F 12.1.1

owner OPI

Results for “item_org_fk_key”