Table: BIL_BI_PROCESSED_FST_ID | Oracle EBS ETRM Search

Table: BIL_BI_PROCESSED_FST_ID 12.1.1 standalone

Table that stores all processed forecasts. It is cummulative for all runs of the concurrent program tat populates the fact table.

Table: BIL_OBI_FST_PG_MV 12.1.1 standalone

Table: BIL_BI_FST_DTL_F 12.1.1 standalone

Sales Forecast Base Summary table contains the summarized data for forecast by period for each sales group and salesperson.

Table: BIL_BI_FST_DTL_STG 12.1.1 standalone

Staging table used to populate the fact table BIL_BI_FST_DTL_F

MATERIALIZED VIEW: APPS.BIL_BI_FST_G_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_BI_FST1_PG_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_BI_FST_PG_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_OBI_FST_PG_MV 12.1.1

TABLE: BIL.MLOG$_BIL_BI_FST_DTL_F 12.1.1

owner BIL

TABLE: APPS.MLOG$_BIL_BI_FST1_PG_MV 12.1.1

VIEW: APPS.BIL_OBI_FST_PG_V 12.1.1

APPS.BIL_BI_FST_DTL_F_PKG SQL Statements 12.1.1

TABLE: BIL.BIL_BI_PROCESSED_FST_ID 12.1.1

owner BIL

PACKAGE: APPS.BIL_BI_TREND_MGMT_RPTS_PKG 12.1.1

PACKAGE BODY: APPS.BIL_BI_TREND_MGMT_RPTS_PKG 12.1.1

TABLE: BIL.BIL_BI_FST_DTL_F 12.1.1

owner BIL

MATERIALIZED VIEW: APPS.BIL_BI_FST_G_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_BI_FST1_PG_MV 12.1.1

TABLE: APPS.BIL_BI_FST1_PG_MV 12.1.1

TABLE: APPS.BIL_BI_FST_G_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_BI_FST_PG_MV 12.1.1

TABLE: APPS.BIL_BI_FST_PG_MV 12.1.1

MATERIALIZED VIEW: APPS.BIL_OBI_FST_PG_MV 12.1.1

TABLE: BIL.BIL_BI_FST_DTL_STG 12.1.1

owner BIL

TABLE: APPS.BIL_OBI_FST_PG_MV 12.1.1

APPS.BIL_BI_TREND_MGMT_RPTS_PKG SQL Statements 12.1.1

PACKAGE BODY: APPS.BIL_BI_FST_DTL_F_PKG 12.1.1

PACKAGE BODY: APPS.BIL_BI_TREND_MGMT_RPTS_PKG 12.1.1

eTRM - BIL Tables and Views 12.1.1

eTRM - FND Tables and Views 12.1.1

No longer used

Results for “forecast_amt”