Table: EDW_PROJ_TOP_TASK_LTC | 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: FII_PA_REVENUE_F 12.1.1

owner FII·FII - Financial Intelligence·46 columns

FII_PA_REVENUE_F is the project revenue fact table

FII.FII_PA_REVENUE_F·Explore FII 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: FII_E_REVENUE_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·182 columns

Interface table for Consolidated Revenue fact

FII.FII_E_REVENUE_FSTG·Explore FII module →

Table: FII_AR_REVENUE_F_DLOG 12.1.1

owner FII·FII - Financial Intelligence·116 columns

This is a delete log table for the Consolidated Revenue Fact table.

FII.FII_AR_REVENUE_F_DLOG·Explore FII module →

Table: FII_E_REVENUE_F 12.1.1

owner FII·FII - Financial Intelligence·126 columns

For Internal Use Only.Consolidated Revenue fact table

FII.FII_E_REVENUE_F·Explore FII module →

Table: FII_PA_BUDGET_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·66 columns

FII_PA_BUDGET_FSTG is the interface table for the project budget fact

FII.FII_PA_BUDGET_FSTG·Explore FII module →

Table: FII_AR_TRX_DIST_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·192 columns

Accounts Receivable Revenue Fact table

FII.FII_AR_TRX_DIST_FSTG·Explore FII module →

Table: FII_PA_REVENUE_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·75 columns

FII_PA_REVENUE_FSTG is the staging table for the project revenue fact.

FII.FII_PA_REVENUE_FSTG·Explore FII module →

Table: FII_PA_COST_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·91 columns

FII_PA_COST_FSTG is the staging table for the project cost fact.

FII.FII_PA_COST_FSTG·Explore FII 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: FII_AR_TRX_DIST_F 12.1.1 standalone

owner FII·FII - Financial Intelligence·134 columns

Accounts Receivable Revenue Fact table.

FII.FII_AR_TRX_DIST_F·Explore FII module →

Table: FII_AR_TRX_DIST_F_DLOG 12.1.1 standalone

owner FII·FII - Financial Intelligence·134 columns

This is a delete log table for the Accounts Receivable Revenue Fact (FII_AR_TRX_DIST_F). When a record is updated in the Accounts Receivable Revenue Fact, the old record is moved into the DLOG table. Thus, the DLOG table remembers the val

FII.FII_AR_TRX_DIST_F_DLOG·Explore FII module →

Table: FII_AP_INV_LINES_F 12.1.1

owner FII·FII - Financial Intelligence·135 columns

AP invoice lines fact table

FII.FII_AP_INV_LINES_F·Explore FII module →

TABLE: FII.EDW_PROJ_TOP_TASK_LTC 12.1.1

owner FII

TABLE: OPI.OPI_EDW_MRG_KEYS 12.1.1

owner OPI

APPS.OPI_COLLECTION_HOOK_P SQL Statements 12.1.1

TABLE: OPI.OPI_EDW_MRG_MAX_VALUES 12.1.1

owner OPI

TABLE: OPI.MLOG$_OPI_EDW_MARGIN_F 12.1.1

owner OPI

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

INV - Inventory

Not implemented in this database·Explore INV 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 →

TABLE: OPI.OPI_EDW_MARGIN_PERD_FDLG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_PERD_MARGIN_FT 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_PERD_MARGIN_F 12.1.1

owner OPI

TABLE: FII.FII_E_REVENUE_SUMMARY_F 12.1.1

owner FII

TABLE: FII.EDW_PROJ_TOP_TASK_LSTG 12.1.1

owner FII

TABLE: OPI.OPI_EDW_MARGIN_F 12.1.1

owner OPI

TABLE: FII.FII_PA_REVENUE_F 12.1.1

owner FII

TABLE: FII.FII_PA_BUDGET_F 12.1.1

owner FII

PACKAGE BODY: APPS.OPI_COLLECTION_HOOK_P 12.1.1

TABLE: FII.FII_PA_COST_F 12.1.1

owner FII

PACKAGE: APPS.FII_PA_COST_HOOK 12.1.1

PACKAGE: APPS.FII_PA_REVENUE_HOOK 12.1.1

PACKAGE: APPS.FII_PA_BUDGET_HOOK 12.1.1

TABLE: FII.FII_PA_BUDGET_FSTG 12.1.1

owner FII

TABLE: FII.FII_PA_REVENUE_FSTG 12.1.1

owner FII

Results for “project_fk_key”