Table: OPI_EDW_MARGIN_F | 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: BIM_EDW_RVCT_MTH_F 12.1.1 link

owner BIM·BIM - Marketing Intelligence·113 columns

Monthly summarized fact table .

BIM.BIM_EDW_RVCT_MTH_F·Explore BIM module →

Table: BIM_EDW_RVCT_DLY_F 12.2.2 link

owner BIM·BIM - Marketing Intelligence(Obsolete)·113 columns

Daily derived fact table .

BIM.BIM_EDW_RVCT_DLY_F·Explore BIM module →

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: BIM_EDW_RVCT_DLY_F_IV 12.1.1

BIM - Marketing Intelligence

Instead of Views

Not implemented in this database·Explore BIM module →

View: BIM_EDW_RVCT_MTH_F_IV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Instead of Views

Not implemented in this database·Explore BIM module →

TABLE: OPI.MLOG$_OPI_EDW_MARGIN_F 12.1.1

owner OPI

VIEW: BIM.BIM_EDW_RVCT_DLY_F# 12.2.2

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

View: BIM_EDW_RVCT_MTH_F_IV 12.1.1

BIM - Marketing Intelligence

Instead of Views

Not implemented in this database·Explore BIM module →

VIEW: BIM.BIM_EDW_RVCT_MTH_F# 12.2.2

TABLE: OPI.OPI_EDW_PERD_MARGIN_FT 12.1.1

owner OPI

View: BIM_EDW_RVCT_DLY_F_IV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Instead of Views

Not implemented in this database·Explore BIM module →

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

VIEW: APPS.OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.1.1

View: OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.2.2

OPI - Operations Intelligence (Obsolete)

Product Gross Margin report source view

Not implemented in this database·Explore OPI module →

VIEW: BIM.BIM_EDW_RVCT_DLY_F# 12.2.2

owner BIM

VIEW: BIM.BIM_EDW_RVCT_MTH_F# 12.2.2

owner BIM

TABLE: BIM.BIM_EDW_RVCT_DLY_F_TEMP 12.2.2

owner BIM

APPS.OPI_EDW_OPMCOGS_F_C SQL Statements 12.1.1

View: OPI_EDW_PRODUCT_GROSS_MARGIN_V 12.1.1

OPI - Operations Intelligence·27 columns

Product Gross Margin report source view

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

TABLE: BIM.BIM_EDW_RVCT_DLY_F_TEMP 12.1.1

owner BIM

TABLE: BIM.BIM_EDW_RVCT_MTH_F_TEMP 12.2.2

owner BIM

TABLE: BIM.BIM_EDW_RVCT_MTH_F_TEMP 12.1.1

owner BIM

TABLE: OPI.OPI_EDW_PERD_MARGIN_F 12.1.1

owner OPI

View: OPI_EDW_OPMCOGS_FCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This is the source view for extracting Cost of gods sold and shipment data from the Process Manufacturing source tables.

Not implemented in this database·Explore OPI module →

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

TABLE: OPI.OPI_EDW_MARGIN_F 12.1.1

owner OPI

VIEW: APPS.OPI_EDW_OPMCOGS_FCV 12.1.1

View: CST_EDW_COGS_V 12.2.2

BOM - Bills of Material

Not implemented in this database·Explore BOM module →

View: CST_EDW_COGS_V 12.1.1

BOM - Bills of Material

Not implemented in this database·Explore BOM module →

PACKAGE BODY: APPS.OPI_EDW_COGS_F_C 12.1.1

used by 1

PACKAGE: APPS.OPI_EDW_COGS_F_C 12.1.1

used by 1

VIEW: APPS.OPI_EDW_COGS_FCV 12.1.1

TABLE: BIM.BIM_EDW_RVCT_MTH_F 12.1.1

owner BIM

APPS.OPI_EDW_COGS_F_C SQL Statements 12.1.1

TABLE: BIM.BIM_EDW_RVCT_DLY_F 12.1.1

owner BIM

TABLE: BIM.BIM_EDW_RVCT_DLY_F 12.2.2

owner BIM

Results for “cogs_g”