Table: ZPB_HIER_MEMBERS | Oracle EBS ETRM Search

Table: ZPB_HIER_MEMBERS 12.1.1 standalone

owner ZPB·ZPB - Enterprise Planning and Budgeting·14 columns

This table is used to cache the Hierarchy Members of a given Business Area

ZPB.ZPB_HIER_MEMBERS·Explore ZPB module →

VIEW: APPS.MSD_SR_SALES_FCST_V 12.1.1

View: MSD_SR_SALES_FCST_V 12.2.2

This is the Source View for Sales Forecast. This view would be applied to an Oracle Applications 11i instance from which the Sales Forecast information is to be retrieved.

APPS.MSD_SR_SALES_FCST_V·↳ AS_FORECAST_CATEGORIES·↳ AS_INTERNAL_FORECASTS·↳ AS_OPP_WORKSHEET_LINES·Explore MSD module →

VIEW: APPS.MSD_SR_SALES_FCST_V 12.2.2

Table: JTF_RS_GRP_RELATIONS 12.2.2 satellite-leaning

owner JTF·JTF - CRM Foundation·30 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP'

JTF.JTF_RS_GRP_RELATIONS·Explore JTF module →

PACKAGE: APPS.JTF_RS_GROUP_RELATE_PVT 12.1.1 PVT API

used by 2

View: MSD_SR_SALES_FCST_V 12.1.1

MSD - Demand Planning·21 columns

This is the Source View for Sales Forecast. This view would be applied to an Oracle Applications 11i instance from which the Sales Forecast information is to be retrieved.

APPS.MSD_SR_SALES_FCST_V·↳ AS_FORECAST_CATEGORIES·↳ AS_INTERNAL_FORECASTS·↳ AS_OPP_WORKSHEET_LINES·Explore MSD module →

TABLE: JTF.JTF_RS_GRP_RELATIONS 12.1.1

owner JTF

TABLE: JTF.JTF_RS_GRP_RELATIONS 12.2.2

owner JTF

PACKAGE BODY: APPS.JTF_RS_GROUP_RELATE_PVT 12.1.1 PVT API

used by 2

PACKAGE BODY: APPS.JTF_RS_GROUP_RELATE_PVT 12.2.2 PVT API

used by 2

Table: JTF_RS_GRP_RELATIONS 12.1.1 satellite-leaning

owner JTF·JTF - CRM Foundation·30 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP'

JTF.JTF_RS_GRP_RELATIONS·Explore JTF module →

Lookup Type: JTF_RS_RELATION_TYPE 12.2.2

JTF - CRM Foundation·meaning JTF_RS_RELATION_TYPE_TYPE

JTF_RS_RELATION_TYPE

Explore JTF module →

Lookup Type: JTF_RS_RELATION_TYPE 12.1.1

JTF - CRM Foundation·meaning JTF_RS_RELATION_TYPE_TYPE

JTF_RS_RELATION_TYPE

Explore JTF module →

PACKAGE: APPS.JTF_RS_GROUP_RELATE_PVT 12.2.2 PVT API

used by 2

TABLE: ZPB.ZPB_HIER_MEMBERS 12.1.1

owner ZPB

APPS.JTF_RS_GROUP_RELATE_PVT SQL Statements 12.1.1

APPS.JTF_RS_GROUP_RELATE_PVT SQL Statements 12.2.2

TYPE: APPS.ZPB_HIER_MEMBER_OBJ 12.1.1

VIEW: APPS.AS_SG_ACTIVE_MGR_V 12.1.1

VIEW: APPS.JTF_RS_GRP_RELATIONS_VL 12.1.1

VIEW: APPS.AS_SG_ACTIVE_MGR_V 12.2.2

VIEW: APPS.AS_FC_SALES_GROUPS_V 12.1.1

VIEW: APPS.AS_SALES_GROUPS_V 12.2.2

VIEW: APPS.AS_SALES_GROUPS_V 12.1.1

APPS.JTF_RS_GROUP_DENORM_PVT SQL Statements 12.2.2

APPS.JTF_RS_GROUP_DENORM_PVT SQL Statements 12.1.1

VIEW: APPS.JTF_RS_GROUP_DTLS_VL 12.1.1

VIEW: APPS.JTF_RS_GROUP_DTLS_VL 12.2.2

APPS.ZPB_FEM_UTILS_PKG SQL Statements 12.1.1

eTRM - ZPB Tables and Views 12.1.1

This table is used to cache the Hierarchy Members of a given Business Area

Table: JTF_RS_CHGD_GRP_RELATIONS 12.1.1 standalone

owner JTF·JTF - CRM Foundation·13 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added)

JTF.JTF_RS_CHGD_GRP_RELATIONS·Explore JTF module →

Table: JTF_RS_CHGD_GRP_RELATIONS 12.2.2 standalone

owner JTF·JTF - CRM Foundation·13 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added)

JTF.JTF_RS_CHGD_GRP_RELATIONS·Explore JTF module →

VIEW: APPS.JTF_RS_GRP_RELATIONS_VL 12.2.2

VIEW: APPS.AS_FC_SALES_GROUPS_V 12.2.2

Table: JTF_RS_CHGD_ROLE_RELATIONS 12.2.2 standalone

owner JTF·JTF - CRM Foundation·14 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added)

JTF.JTF_RS_CHGD_ROLE_RELATIONS·Explore JTF module →

View: AS_SG_ACTIVE_MGR_V 12.2.2

AS - Sales Foundation·32 columns

This view shows all sales groups which has active manager information

APPS.AS_SG_ACTIVE_MGR_V·↳ JTF_RS_GROUPS_B·↳ JTF_RS_GROUPS_TL·↳ JTF_RS_GROUP_MEMBERS·Explore AS module →

View: AS_FC_SALES_GROUPS_V 12.2.2

AS - Sales Foundation·36 columns

This view shows all sales groups information

APPS.AS_FC_SALES_GROUPS_V·↳ JTF_RS_GROUPS_B·↳ JTF_RS_GROUPS_TL·↳ JTF_RS_GROUP_MEMBERS·Explore AS module →

TABLE: JTF.JTF_RS_CHGD_ROLE_RELATIONS 12.1.1

owner JTF

APPS.BIV_SR_DETAILS_PKG SQL Statements 12.1.1

Table: JTF_RS_CHGD_ROLE_RELATIONS 12.1.1 standalone

owner JTF·JTF - CRM Foundation·14 columns

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added)

JTF.JTF_RS_CHGD_ROLE_RELATIONS·Explore JTF module →

View: JTF_RS_GROUP_DTLS_VL 12.2.2

JTF - CRM Foundation·40 columns

This view has the groups details including name and manager

APPS.JTF_RS_GROUP_DTLS_VL·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ JTF_RS_GROUPS_B·Explore JTF module →

View: AS_SG_ACTIVE_MGR_V 12.1.1

AS - Sales Foundation·32 columns

This view shows all sales groups which has active manager information

APPS.AS_SG_ACTIVE_MGR_V·↳ JTF_RS_GROUPS_B·↳ JTF_RS_GROUPS_TL·↳ JTF_RS_GROUP_MEMBERS·Explore AS module →

View: AS_FC_SALES_GROUPS_V 12.1.1

AS - Sales Foundation·36 columns

This view shows all sales groups information