Table: JL_BR_AR_BORDEROS_ALL | Oracle EBS ETRM Search

Interface table for the Job Resource Fact. This will be the staging area for data coming into the Warehouse from Discrete and Process Manufacturing sources.

OPI.OPI_EDW_JOB_RSRC_FSTG·Explore OPI 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: BIL.BIL_DO_L1_LD_OPPTY_DLY 12.1.1

owner BIL

TABLE: BIL.BIL_DO_L1_OPPTY_SUMRY 12.1.1

owner BIL

VIEW: JL.JL_BR_AR_BORDEROS_ALL# 12.2.2

Table: BIL_DO_L1_OPPTY_SUMRY 12.2.2

BIL - Sales Intelligence (Obsolete)

Not implemented in this database·Explore BIL module →

Table: BIL_DO_L1_LD_OPPTY_DLY 12.2.2

BIL - Sales Intelligence (Obsolete)

Data Out Level 1 Lead to Opportunity Daily

Not implemented in this database·Explore BIL module →

VIEW: APPS.JL_BR_AR_BORDEROS_SAB_V 12.1.1

Table: BIL_DO_LD_OPPTY_PRD_DLY 12.1.1

BIL - Sales Intelligence

Not implemented in this database·Explore BIL module →

Table: BIL_DO_L2_OPPTY_CAMP_SUMRY 12.2.2

BIL - Sales Intelligence (Obsolete)

Data Out Phase 2: Campaign Summary by sales group.

Not implemented in this database·Explore BIL module →

Table: BIL_DO_LD_OPPTY_DLY 12.2.2

BIL - Sales Intelligence (Obsolete)

Data Out Lead to Opportunity Collection by Date

Not implemented in this database·Explore BIL module →

VIEW: JL.JL_BR_AR_BORDEROS_ALL# 12.2.2

owner JL

APPS.BIL_DO_L1_OPPTY_SUMRY_PKG SQL Statements 12.1.1

Table: BIL_DO_LD_OPPTY_PRD_DLY 12.2.2

BIL - Sales Intelligence (Obsolete)

Not implemented in this database·Explore BIL module →

VIEW: APPS.JL_BR_AR_BORDEROS_SAB_V 12.2.2

Table: BIL_DO_LD_OPPTY_DLY 12.1.1

BIL - Sales Intelligence

Data Out Lead to Opportunity Collection by Date

Not implemented in this database·Explore BIL module →

Table: BIL_DO_L2_OPPTY_CAMP_SUMRY 12.1.1

BIL - Sales Intelligence

Data Out Phase 2: Campaign Summary by sales group.

Not implemented in this database·Explore BIL module →

TABLE: JL.JL_BR_AR_BORDEROS_ALL 12.1.1

owner JL

VIEW: APPS.JL_BR_AR_BORDEROS_V 12.2.2

VIEW: APPS.JL_BR_AR_BORDEROS_V 12.1.1

PACKAGE BODY: APPS.BIL_DO_L1_OPPTY_SUMRY_PKG 12.1.1

TABLE: JL.JL_BR_AR_BORDEROS_ALL 12.2.2

owner JL

PACKAGE: APPS.BIL_DO_L1_OPPTY_SUMRY_PKG 12.1.1

PACKAGE: APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG 12.1.1

PACKAGE BODY: APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG 12.1.1

VIEW: APPS.JL_BR_AR_BORDEROS_SAB_V 12.1.1

VIEW: APPS.JL_BR_AR_BORDEROS_SAB_V 12.2.2

APPS.JL_BR_AR_BORDEROS_PKG SQL Statements 12.2.2

APPS.JL_BR_AR_BORDEROS_PKG SQL Statements 12.1.1

PACKAGE BODY: APPS.BIL_DO_L1_OPPTY_SUMRY_PKG 12.1.1

APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG SQL Statements 12.1.1

PACKAGE BODY: APPS.JL_BR_AR_BORDEROS_PKG 12.2.2

PACKAGE BODY: APPS.JL_BR_AR_BORDEROS_PKG 12.1.1

TABLE: OPI.OPI_EDW_JOB_RSRC_FSTG 12.1.1

owner OPI

TABLE: OPI.OPI_EDW_JOB_DETAIL_FSTG 12.1.1

owner OPI

PACKAGE BODY: APPS.BIL_DO_L1_LD_OPPTY_DLY_PKG 12.1.1

eTRM - BIL Tables and Views 12.1.1

eTRM - JL Tables and Views 12.1.1

Temporary Table For Inflation Adjustment Report

eTRM - JL Tables and Views 12.2.2

JL_ZZ_INFO_T is temporary table

eTRM - OPI Tables and Views 12.1.1

Results for “collection_date”