Table: OKI_BI_GRP_CNT_MV | Oracle EBS ETRM Search

Table: OKI_BI_GRP_CNT_MV 12.1.1

FND - Application Object Library·2 columns

APPS.OKI_BI_GRP_CNT_MV·Explore FND module →

View: AS_SALESGROUP_SUB_V 12.1.1

AS - Sales Foundation·6 columns

This view shows all the first level sub-groups from JTF resource manager

APPS.AS_SALESGROUP_SUB_V·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUPS_TL·↳ JTF_RS_GROUP_USAGES·Explore AS module →

Table: ASF_OPP_CHN_FRCST_MV 12.1.1 standalone

ASF - Sales Online·17 columns

APPS.ASF_OPP_CHN_FRCST_MV·Explore ASF module →

Table: AS_SALES_CREDIT_ADJS 12.1.1 standalone

owner OSM·AS - Sales Foundation·19 columns

Stores adjustments to sales credits.

OSM.AS_SALES_CREDIT_ADJS·Explore AS module →

View: AS_SALESGROUP_SUB_V 12.2.2

AS - Sales Foundation·6 columns

This view shows all the first level sub-groups from JTF resource manager

APPS.AS_SALESGROUP_SUB_V·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUPS_TL·↳ JTF_RS_GROUP_USAGES·Explore AS module →

View: AS_SALESFORCE_SUB_V 12.1.1

AS - Sales Foundation·7 columns

This view shows all the salesforce from JTF resource manager who are members or managers

APPS.AS_SALESFORCE_SUB_V·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AS module →

View: AS_SALES_GRP_DENORM_V 12.1.1

AS - Sales Foundation·26 columns

This view shows the sales group hierarchy information

APPS.AS_SALES_GRP_DENORM_V·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUP_USAGES·Explore AS module →

View: AS_RPT_MANAGERS_V 12.2.2

AS - Sales Foundation·30 columns

This view shows the sales reporting hierarchy information for manager

APPS.AS_RPT_MANAGERS_V·↳ JTF_RS_GROUP_USAGES·↳ JTF_RS_REP_MANAGERS·Explore AS module →

Table: AS_SALESFORCE 12.1.1 satellite-leaning

owner OSM·AS - Sales Foundation·31 columns

Obsolete Defines the salesforce

OSM.AS_SALESFORCE·Explore AS module →

Table: OE_SALES_CREDITS 12.1.1 link

owner ONT·ONT - Order Management·33 columns

This table stores information about sales credits.

ONT.OE_SALES_CREDITS·Explore ONT module →

View: AST_RES_TEAM_MEMBERS_V 12.1.1

AST - TeleSales·12 columns

APPS.AST_RES_TEAM_MEMBERS_V·↳ JTF_OBJECTS_TL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AST module →

View: AST_SALESREP_LOV_UWQ_V 12.2.2

AST - TeleSales·13 columns

APPS.AST_SALESREP_LOV_UWQ_V·↳ AST_SALESREP_LOV_V·Explore AST module →

Table: OKC_CONTACTS 12.2.2 satellite-leaning

owner OKC·OKC - Contracts Core·37 columns

An individual acting as a contact point or otherwise named in a Contract.

OKC.OKC_CONTACTS·Explore OKC module →

View: OKS_K_SALES_CREDITS_V 12.2.2

OKS - Service Contracts·14 columns

view for service sales credits

APPS.OKS_K_SALES_CREDITS_V·↳ OKS_K_SALES_CREDITS·Explore OKS module →

Table: AS_ACCESSES_ALL_ALL 12.2.2 satellite-leaning

owner OSM·AS - Sales Foundation·67 columns

Contains employee and partner access records for customers, sales leads and opportunities

OSM.AS_ACCESSES_ALL_ALL·Explore AS module →

Table: AS_PROD_WORKSHEET_LINES 12.1.1 link

owner OSM·AS - Sales Foundation·64 columns

Table to store the forecast information on all possible product categories for individual or sales group

OSM.AS_PROD_WORKSHEET_LINES·Explore AS module →

View: AS_ACCESSES_ALL 12.1.1

AS - Sales Foundation·59 columns

APPS.AS_ACCESSES_ALL·↳ AS_ACCESSES_ALL_ALL·Explore AS module →

View: AS_FC_SALESFORCE_V 12.2.2

AS - Sales Foundation·44 columns

This view shows all the salesforce from JTF resource manager

APPS.AS_FC_SALESFORCE_V·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AS module →

View: BIL_DIMV_SALES_GROUPS 12.1.1

BIL - Sales Intelligence·10 columns

Sales groups view

APPS.BIL_DIMV_SALES_GROUPS·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_GROUPS_B·Explore BIL module →

Table: ASF_WIN_LOSS_MV 12.1.1 standalone

ASF - Sales Online·11 columns

APPS.ASF_WIN_LOSS_MV·Explore ASF module →

View: AS_SALESFORCE_SUB_V 12.2.2

AS - Sales Foundation·7 columns

This view shows all the salesforce from JTF resource manager who are members or managers

APPS.AS_SALESFORCE_SUB_V·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AS module →

Table: OE_CREDITS_IFACE_ALL 12.2.2 satellite-leaning

owner ONT·ONT - Order Management·50 columns

This is a multi-org table for sales order/line credits open interface.

ONT.OE_CREDITS_IFACE_ALL·Explore ONT module →

Table: ASF_WIN_WON_TOP5_MV 12.1.1 standalone

ASF - Sales Online·20 columns

APPS.ASF_WIN_WON_TOP5_MV·Explore ASF module →

View: AS_TERRITORY_ACCESSES_V 12.2.2

AS - Sales Foundation·52 columns

Territory accesses view

APPS.AS_TERRITORY_ACCESSES_V·↳ AS_ACCESSES·↳ AS_LEADS·↳ AS_LOOKUPS·Explore AS module →

View: AST_SALESREP_LOV_V 12.2.2

AST - TeleSales·13 columns

APPS.AST_SALESREP_LOV_V·↳ JTF_RS_GROUPS_VL·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·Explore AST module →

Table: BIL_DO_L1_BASE_GRP_TEMP 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·13 columns

Data Out Level 1 table used for hierarchy of group levels for temporary use in collection programs.

BIL.BIL_DO_L1_BASE_GRP_TEMP·Explore BIL module →

View: AST_SALESREP_LOV_UWQ_V 12.1.1

AST - TeleSales·13 columns

APPS.AST_SALESREP_LOV_UWQ_V·↳ AST_SALESREP_LOV_V·Explore AST module →

Table: OKS_K_SALES_CREDITS 12.2.2 link

owner OKS·OKS - Service Contracts·14 columns

Records sales credits for the sale of services in a service contract.

OKS.OKS_K_SALES_CREDITS·Explore OKS module →

Table: BIL_BI_FST_DTL_F 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·23 columns

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

BIL.BIL_BI_FST_DTL_F·Explore BIL module →

View: AS_RPT_ADMINS_V 12.2.2

AS - Sales Foundation·16 columns

This view shows the sales reporting hierarchy information for admin

APPS.AS_RPT_ADMINS_V·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·Explore AS module →

View: AS_RPT_ADMINS_V 12.1.1

AS - Sales Foundation·16 columns

This view shows the sales reporting hierarchy information for admin

APPS.AS_RPT_ADMINS_V·↳ JTF_RS_GROUPS_DENORM·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·Explore AS module →

View: AST_RES_TEAM_MEMBERS_V 12.2.2

AST - TeleSales·12 columns

APPS.AST_RES_TEAM_MEMBERS_V·↳ JTF_OBJECTS_TL·↳ JTF_RS_RESOURCE_EXTNS·↳ JTF_RS_ROLES_B·Explore AST module →

Table: ENI_DBI_TOO_MV 12.1.1

ENI - Product Intelligence·12 columns

APPS.ENI_DBI_TOO_MV·Explore ENI module →

View: OKS_K_SALES_CREDITS_V 12.1.1

OKS - Service Contracts·14 columns

view for service sales credits

APPS.OKS_K_SALES_CREDITS_V·↳ OKS_K_SALES_CREDITS·Explore OKS module →

Table: ASF_WIN_LOSS_PRODCAT_MV 12.1.1 standalone

ASF - Sales Online·13 columns

APPS.ASF_WIN_LOSS_PRODCAT_MV·Explore ASF module →

View: AST_SALESREP_LOV_V 12.1.1

AST - TeleSales·13 columns

APPS.AST_SALESREP_LOV_V·↳ JTF_RS_GROUPS_VL·↳ JTF_RS_GROUP_MEMBERS·↳ JTF_RS_RESOURCE_EXTNS·Explore AST module →

View: AS_RPT_MANAGERS_V 12.1.1

AS - Sales Foundation·30 columns

This view shows the sales reporting hierarchy information for manager

APPS.AS_RPT_MANAGERS_V·↳ JTF_RS_GROUP_USAGES·↳ JTF_RS_REP_MANAGERS·Explore AS module →

Table: AS_INTERNAL_FORECASTS 12.2.2 satellite-leaning

owner OSM·AS - Sales Foundation·62 columns

Table to store the summary forecast information for individual or group

OSM.AS_INTERNAL_FORECASTS·Explore AS module →

Table: ASF_OPP_PRD_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_OPP_PRD_MV·Explore ASF module →

Table: ASF_SC_BIN_FRCST_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_SC_BIN_FRCST_MV·Explore ASF module →

Table: AS_SALES_QUOTAS 12.1.1 satellite-leaning

owner OSM·AS - Sales Foundation·45 columns

Defines sales quotas

OSM.AS_SALES_QUOTAS·Explore AS module →

Table: OKS_K_SALES_CREDITS 12.1.1 link

owner OKS·OKS - Service Contracts·14 columns

Records sales credits for the sale of services in a service contract.

OKS.OKS_K_SALES_CREDITS·Explore OKS module →

Table: BIL_BI_FST_DTL_STG 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·31 columns

Staging table used to populate the fact table BIL_BI_FST_DTL_F

BIL.BIL_BI_FST_DTL_STG·Explore BIL module →

Table: ASF_WIN_LOSS_COMPTATOR_MV 12.1.1 standalone

ASF - Sales Online·15 columns

APPS.ASF_WIN_LOSS_COMPTATOR_MV·Explore ASF module →

View: OEFV_SALES_CREDITS 12.2.2

ONT - Order Management·17 columns

Full BIS Business View for Sales Credits.

APPS.OEFV_SALES_CREDITS·↳ OE_BIS_SALESPERSON·↳ OE_SALES_CREDITS·↳ OE_SALES_CREDIT_TYPES·Explore ONT module →

View: OEFV_SALES_CREDITS 12.1.1

ONT - Order Management·17 columns

Full BIS Business View for Sales Credits.

APPS.OEFV_SALES_CREDITS·↳ OE_BIS_SALESPERSON·↳ OE_SALES_CREDITS·↳ OE_SALES_CREDIT_TYPES·Explore ONT module →

Table: AS_REPORTING_MANAGERS 12.2.2 standalone

owner OSM·AS - Sales Foundation·25 columns

Denormalized table derived from AS_SALESFORCE.

OSM.AS_REPORTING_MANAGERS·Explore AS module →

Table: OE_SALES_CREDITS 12.2.2 link

owner ONT·ONT - Order Management·34 columns

This table stores information about sales credits.

ONT.OE_SALES_CREDITS·Explore ONT module →

Table: AS_MRP_FCT_DETAIL 12.2.2 standalone

owner OSM·AS - Sales Foundation·18 columns

OSM.AS_MRP_FCT_DETAIL·Explore AS module →

Table: ASF_OPP_CMP_FRCST_MV 12.1.1 standalone

ASF - Sales Online·17 columns

APPS.ASF_OPP_CMP_FRCST_MV·Explore ASF module →

Results for “sales_group_id”