Table: OPI_EDW_MRG_KEYS | 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_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: OPI_EDW_PERD_MARGIN_FUR 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·38 columns

OPI.OPI_EDW_PERD_MARGIN_FUR·Explore OPI module →

Table: OPI_EDW_MARGIN_PERD_FDLG 12.1.1

owner OPI·OPI - Operations Intelligence·43 columns

OPI.OPI_EDW_MARGIN_PERD_FDLG·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_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_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_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: 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: APPS.OPI_EDW_PRODUCT_SALES_REV_V 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: OPI.OPI_EDW_MRG_KEYS 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_MRG_MAX_VALUES 12.1.1

owner OPI

TABLE: OPI.MLOG$_OPI_EDW_MARGIN_F 12.1.1

owner OPI

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

TABLE: OPI.OPI_EDW_MARGIN_PERD_FDLG 12.1.1

owner OPI

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

TABLE: OPI.OPI_EDW_MARGIN_F 12.1.1

owner OPI

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

PACKAGE: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

TABLE: OPI.OPI_EDW_COGS_F 12.1.1

owner OPI

TABLE: ISC.ISC_EDW_BOOKINGS_F 12.1.1

owner ISC

TABLE: ISC.ISC_EDW_BOOKINGS_F_DLOG 12.1.1

owner ISC

TABLE: OPI.OPI_EDW_COGS_F_DLOG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_COGS_FSTG 12.1.1

owner OPI

TABLE: ISC.ISC_EDW_BOOKINGS_FSTG 12.1.1

owner ISC

eTRM - OPI Tables and Views 12.1.1

eTRM - ISC Tables and Views 12.1.1

This is a temporary table used by the Bookings collection program

Results for “ship_to_loc_fk_key”