Table: OPI_EDW_IDS_NET_CHG | Oracle EBS ETRM Search

Job Detail fact will store the detail information of the Jobs/Batches. There will be one row for each jobs and each end products. For example, if a batch produces two products ( one main product and one co-product) then the fact table will

OPI.OPI_EDW_JOB_DETAIL_F·Explore OPI module →

Table: ISC_EDW_BACKLOGS_F 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·89 columns

Backlog Snapshot fact table

ISC.ISC_EDW_BACKLOGS_F·Explore ISC module →

Table: OPI_EDW_JOB_DETAIL_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·109 columns

Job Detail Fact Staging Table Sourced from the Fllowing Views OPI_EDW_OPM_JOB_DETAIL_FCV and OPI_EDW_OPI_JOB_DETAILS_FCV

OPI.OPI_EDW_JOB_DETAIL_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: 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: POA_EDW_ALINES_F 12.1.1

owner POA·POA - Purchasing Intelligence·103 columns

Contract Lines fact table

POA.POA_EDW_ALINES_F·Explore POA 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_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: POA_EDW_ALINES_FSTG 12.1.1 standalone

owner POA·POA - Purchasing Intelligence·156 columns

Interface table for Contract Lines fact

POA.POA_EDW_ALINES_FSTG·Explore POA module →

View: EDW_MTL_UOM_CONV_F_IV 12.1.1

BIS - Applications BIS

Not implemented in this database·Explore BIS module →

View: EDW_MTL_UOM_CONV_F_IV 12.1.1

INV - Inventory

Not implemented in this database·Explore INV module →

View: EDW_MTL_UOM_CONV_F_IV 12.2.2

BIS - Applications BIS

Not implemented in this database·Explore BIS module →

View: EDW_MTL_UOM_CONV_F_IV 12.2.2

INV - Inventory

Not implemented in this database·Explore INV module →

TABLE: OPI.OPI_EDW_IDS_NET_CHG 12.1.1

owner OPI

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

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 →

PACKAGE: APPS.OPI_COLLECTION_HOOK_P 12.1.1

used by 1

TABLE: OPI.OPI_EDW_INV_PERD_STAT_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_IPS_NET_CHG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_INV_DAILY_STAT_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_JOB_DETAIL_F 12.1.1

owner OPI

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

TABLE: ISC.ISC_EDW_BACKLOGS_F 12.1.1

owner ISC

TABLE: POA.POA_EDW_ALINES_F 12.1.1

owner POA

TABLE: OPI.OPI_EDW_COGS_F 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_COGS_F_DLOG 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_FSTG 12.1.1

owner OPI

TABLE: ISC.ISC_EDW_BACKLOGS_FSTG 12.1.1

owner ISC

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

TABLE: OPI.OPI_EDW_COGS_FSTG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_JOB_DETAIL_FSTG 12.1.1

owner OPI

TABLE: POA.POA_EDW_ALINES_FSTG 12.1.1

owner POA

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

eTRM - POA Tables and Views 12.1.1

UNSPSC Item interface table

Results for “base_uom_fk_key”