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_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: 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: OPI.OPI_EDW_MARGIN_PERD_FDLG 12.1.1

owner OPI

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 →

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.MLOG$_OPI_EDW_MARGIN_F 12.1.1

owner OPI

VIEW: BIM.BIM_EDW_RVCT_DLY_F# 12.2.2

TABLE: OPI.OPI_EDW_PERD_MARGIN_FUR 12.1.1

owner OPI

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

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

APPS.OPI_EDW_COGS_F_C SQL Statements 12.1.1

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

APPS.OPI_EDW_OPMCOGS_F_C SQL Statements 12.1.1

VIEW: APPS.OPI_EDW_OPMCOGS_FCV 12.1.1

PACKAGE BODY: APPS.OPI_EDW_COGS_F_C 12.1.1

used by 1

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

PACKAGE: APPS.OPI_EDW_COGS_F_C 12.1.1

used by 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

TABLE: BIM.BIM_EDW_RVCT_MTH_F 12.1.1

owner BIM

VIEW: APPS.OPI_EDW_COGS_FCV 12.1.1

TABLE: BIM.BIM_EDW_RVCT_MTH_F 12.2.2

owner BIM

VIEW: APPS.OPI_EDW_OPMCOGS_FCV 12.1.1

VIEW: APPS.OPI_EDW_COGS_FCV 12.1.1

TABLE: OPI.OPI_EDW_COGS_F_DLOG 12.1.1

owner OPI

PACKAGE BODY: APPS.OPI_EDW_COGS_FOPM_SZ 12.1.1

Results for “cogs_b”