Table: BIM_EDW_LEADS_FSTG | Oracle EBS ETRM Search

Table: BIM_EDW_LEADS_FSTG 12.1.1 standalone

owner BIM·BIM - Marketing Intelligence·85 columns

Interface table for lead fact table .

BIM.BIM_EDW_LEADS_FSTG·Explore BIM module →

Table: OPI_EDW_RES_UTIL_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·54 columns

This is the interface table for Resource Utilization Fact. Data from multiple transactional systems is staged here for verification and cleansing before being loaded into the fact table.

OPI.OPI_EDW_RES_UTIL_FSTG·Explore OPI module →

View: OPI_EDW_OPM_RES_UTIL_FCV 12.1.1

OPI - Operations Intelligence·36 columns

This view contains the extraction logic for data to the Resource Utilization fact from process manufacturing side.

APPS.OPI_EDW_OPM_RES_UTIL_FCV·↳ CR_RSRC_DTL·↳ CR_RSRC_MST·↳ EDW_LOCAL_INSTANCE·Explore OPI 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: BIM_EDW_EVTFRCST_FSTG 12.1.1 standalone

owner BIM·BIM - Marketing Intelligence·90 columns

Interface table for event forecast fact .

BIM.BIM_EDW_EVTFRCST_FSTG·Explore BIM module →

View: OPI_EDW_OPI_RES_UTIL_FCV 12.1.1

OPI - Operations Intelligence·36 columns

This is the source view for extracting job-resource data from the Discrete Manufacturing source tables.

APPS.OPI_EDW_OPI_RES_UTIL_FCV·↳ EDW_LOCAL_INSTANCE·↳ EDW_TIME_PKG·↳ OPI_EDW_RES_UTIL_PUSH_LOG·Explore OPI module →

View: FII_AR_TRX_DIST_FCV 12.1.1

FII - Financial Intelligence·157 columns

Internal view used for warehouse data extraction

APPS.FII_AR_TRX_DIST_FCV·↳ EDW_CURRENCY·↳ EDW_UTIL·↳ FIIBV_AR_TRX_DIST_FCV·Explore FII module →

Table: BIM_EDW_CMPFRCST_FSTG 12.1.1 satellite-leaning

owner BIM·BIM - Marketing Intelligence·82 columns

Interface table for campaign forecast fact .

BIM.BIM_EDW_CMPFRCST_FSTG·Explore BIM module →

Table: BIM_EDW_OPRNTIES_FSTG 12.1.1 standalone

owner BIM·BIM - Marketing Intelligence·85 columns

Interface table for opportunity fact .

BIM.BIM_EDW_OPRNTIES_FSTG·Explore BIM 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 →

View: OPI_EDW_OPI_RES_UTIL_FCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This is the source view for extracting job-resource data from the Discrete Manufacturing source tables.

Not implemented in this database·Explore OPI module →

APPS.OPI_EDW_OPM_RES_UTIL_F_C SQL Statements 12.1.1

APPS.OPI_EDW_OPI_RES_UTIL_F_C SQL Statements 12.1.1

View: BIM_EDW_OPRNTIES_FCV 12.1.1

BIM - Marketing Intelligence

Not implemented in this database·Explore BIM module →

View: BIM_EDW_LEADS_FCV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Not implemented in this database·Explore BIM module →

View: BIM_EDW_OPRNTIES_FCV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Not implemented in this database·Explore BIM module →

View: BIM_EDW_EVTFRCST_FCV 12.1.1

BIM - Marketing Intelligence

Not implemented in this database·Explore BIM module →

View: BIM_EDW_CMPFRCST_FCV 12.1.1

BIM - Marketing Intelligence

Not implemented in this database·Explore BIM module →

View: BIM_EDW_CMPFRCST_FCV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Not implemented in this database·Explore BIM module →

VIEW: APPS.OPI_EDW_OPI_RES_UTIL_FCV 12.1.1

View: BIM_EDW_LEADS_FCV 12.1.1

BIM - Marketing Intelligence

Not implemented in this database·Explore BIM module →

APPS.FII_AR_TRX_DIST_F_C SQL Statements 12.1.1

View: FII_AR_TRX_DIST_FCV 12.2.2

FII - Financial Intelligence (Obsolete)

Internal view used for warehouse data extraction

Not implemented in this database·Explore FII module →

PACKAGE BODY: APPS.OPI_EDW_OPI_RES_UTIL_F_C 12.1.1

used by 1

PACKAGE BODY: APPS.OPI_EDW_OPM_RES_UTIL_F_C 12.1.1

View: BIM_EDW_EVTFRCST_FCV 12.2.2

BIM - Marketing Intelligence(Obsolete)

Not implemented in this database·Explore BIM module →

VIEW: APPS.OPI_EDW_OPI_RES_UTIL_FCV 12.1.1

VIEW: APPS.OPI_EDW_OPM_RES_UTIL_FCV 12.1.1

PACKAGE: APPS.OPI_EDW_OPM_RES_UTIL_F_C 12.1.1

PACKAGE: APPS.OPI_EDW_OPI_RES_UTIL_F_C 12.1.1

used by 1

View: FII_AR_E_REVENUE_FCV 12.1.1

FII - Financial Intelligence

FII_AR_E_REVENUE_FCV is the collection view for FII_AR_E_REVENUE_F fact

Not implemented in this database·Explore FII module →

VIEW: APPS.FII_AR_TRX_DIST_FCV 12.1.1

TABLE: OPI.OPI_EDW_RES_UTIL_FSTG 12.1.1

owner OPI

View: FII_AR_E_REVENUE_FCV 12.2.2

FII - Financial Intelligence (Obsolete)

FII_AR_E_REVENUE_FCV is the collection view for FII_AR_E_REVENUE_F fact

Not implemented in this database·Explore FII module →

View: OPI_EDW_OPM_RES_UTIL_FCV 12.2.2

OPI - Operations Intelligence (Obsolete)

This view contains the extraction logic for data to the Resource Utilization fact from process manufacturing side.

Not implemented in this database·Explore OPI module →

VIEW: APPS.FII_AR_TRX_DIST_FCV 12.1.1

PACKAGE BODY: APPS.OPI_EDW_OPM_RES_UTIL_F_C 12.1.1

APPS.FII_AR_TRX_DIST_F_D SQL Statements 12.1.1

PACKAGE BODY: APPS.OPI_EDW_OPI_RES_UTIL_F_C 12.1.1

TABLE: BIM.BIM_EDW_OPRNTIES_FSTG 12.1.1

owner BIM

TABLE: BIM.BIM_EDW_LEADS_FSTG 12.1.1

owner BIM

TABLE: BIM.BIM_EDW_CMPFRCST_FSTG 12.1.1

owner BIM

PACKAGE BODY: APPS.FII_AR_TRX_DIST_F_C 12.1.1

TABLE: BIM.BIM_EDW_EVTFRCST_FSTG 12.1.1

owner BIM

PACKAGE: APPS.FII_AR_TRX_DIST_F_C 12.1.1

TABLE: FII.FII_E_REVENUE_FSTG 12.1.1

owner FII

PACKAGE BODY: APPS.FII_AR_TRX_DIST_F_C 12.1.1

PACKAGE BODY: APPS.OPI_EDW_RES_UTIL_F_SZ 12.1.1

PACKAGE BODY: APPS.FII_AR_TRX_DIST_F_D 12.1.1

VIEW: APPS.FIIBV_AR_TRX_DIST_FCV 12.1.1

Results for “uom_fk”