eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: JTF_RS_GROUPS_B

Product:	JTF - CRM Foundation
Description:	Base Table JTF_RS_GROUPS_B stores general information about a given Group.
Implementation/DBA Data:	JTF.JTF_RS_GROUPS_B

Primary Key: JTF_RS_GROUPS_B_PK

GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_ACT_ACCESS	JTF_RS_GROUPS_B	AMS_ACT_ACCESS.USER_OR_ROLE_ID
AMV_U_ACCESS	JTF_RS_GROUPS_B	AMV_U_ACCESS.USER_OR_GROUP_ID
AMV_U_MY_CHANNELS	JTF_RS_GROUPS_B	AMV_U_MY_CHANNELS.USER_OR_GROUP_ID
AR_COLLECTORS	JTF_RS_GROUPS_B	AR_COLLECTORS.RESOURCE_ID
AR_REVENUE_ADJUSTMENTS_ALL	JTF_RS_GROUPS_B	AR_REVENUE_ADJUSTMENTS_ALL.FROM_SALESGROUP_ID
AR_REVENUE_ADJUSTMENTS_ALL	JTF_RS_GROUPS_B	AR_REVENUE_ADJUSTMENTS_ALL.TO_SALESGROUP_ID
ASO_APR_APPROVAL_DET_B	JTF_RS_GROUPS_B	ASO_APR_APPROVAL_DET_B.JTF_RS_APPROVER_GROUP_ID
ASO_APR_RULE_APPROVERS	JTF_RS_GROUPS_B	ASO_APR_RULE_APPROVERS.JTF_RS_APPROVER_GROUP_ID
ASO_SALES_CREDITS	JTF_RS_GROUPS_B	ASO_SALES_CREDITS.RESOURCE_GROUP_ID
AS_ACCESSES_ALL_ALL	JTF_RS_GROUPS_B	AS_ACCESSES_ALL_ALL.SALES_GROUP_ID
AS_ACCESSES_ALL_ALL	JTF_RS_GROUPS_B	AS_ACCESSES_ALL_ALL.SALES_GROUP_ID
AS_FORECAST_ACTUALS	JTF_RS_GROUPS_B	AS_FORECAST_ACTUALS.SALES_GROUP_ID
AS_INTERNAL_FORECASTS	JTF_RS_GROUPS_B	AS_INTERNAL_FORECASTS.SALES_GROUP_ID
AS_LEADS_ALL	JTF_RS_GROUPS_B	AS_LEADS_ALL.OWNER_SALES_GROUP_ID
AS_SALES_CREDITS_DENORM	JTF_RS_GROUPS_B	AS_SALES_CREDITS_DENORM.SALES_GROUP_ID
AS_SALES_CREDITS	JTF_RS_GROUPS_B	AS_SALES_CREDITS.SALESGROUP_ID
AS_SALES_LEADS	JTF_RS_GROUPS_B	AS_SALES_LEADS.ASSIGN_SALES_GROUP_ID
AS_TERR_RESOURCES_TMP	JTF_RS_GROUPS_B	AS_TERR_RESOURCES_TMP.RESOURCE_GROUP_ID
CSF_PLAN_TERRS	JTF_RS_GROUPS_B	CSF_PLAN_TERRS.GROUP_ID
CSS_DEF_DEFECTS_B	JTF_RS_GROUPS_B	CSS_DEF_DEFECTS_B.PHASE_OWNER_ID
CSS_DEF_DEF_CONTACTS	JTF_RS_GROUPS_B	CSS_DEF_DEF_CONTACTS.OBJECT_ID
CS_INCIDENTS_ALL_B	JTF_RS_GROUPS_B	CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID
CUG_SR_TASK_TYPE_DETS_B	JTF_RS_GROUPS_B	CUG_SR_TASK_TYPE_DETS_B.OWNER_ID
FII_AR_SALES_CREDITS	JTF_RS_GROUPS_B	FII_AR_SALES_CREDITS.SALESGROUP_ID
AST_GRP_CAMPAIGNS	JTF_RS_GROUPS_B	AST_GRP_CAMPAIGNS.GROUP_ID
JTF_RS_ACTIVE_GRP_MBRS	JTF_RS_GROUPS_B	JTF_RS_ACTIVE_GRP_MBRS.GROUP_ID
JTF_RS_GROUPS_AUD_B	JTF_RS_GROUPS_B	JTF_RS_GROUPS_AUD_B.GROUP_ID
JTF_RS_GROUPS_DENORM	JTF_RS_GROUPS_B	JTF_RS_GROUPS_DENORM.GROUP_ID
JTF_RS_GROUPS_DENORM	JTF_RS_GROUPS_B	JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID
JTF_RS_GROUPS_TL	JTF_RS_GROUPS_B	JTF_RS_GROUPS_TL.GROUP_ID
JTF_RS_GROUP_MEMBERS	JTF_RS_GROUPS_B	JTF_RS_GROUP_MEMBERS.GROUP_ID
JTF_RS_GROUP_USAGES	JTF_RS_GROUPS_B	JTF_RS_GROUP_USAGES.GROUP_ID
JTF_RS_GRP_RELATIONS	JTF_RS_GROUPS_B	JTF_RS_GRP_RELATIONS.GROUP_ID
JTF_RS_GRP_RELATIONS	JTF_RS_GROUPS_B	JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID
JTF_RS_REP_MANAGERS	JTF_RS_GROUPS_B	JTF_RS_REP_MANAGERS.GROUP_ID
JTF_RS_ROLE_RELATIONS	JTF_RS_GROUPS_B	JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID
JTF_RS_TEAM_MEMBERS	JTF_RS_GROUPS_B	JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID
JTF_TERR_RSC_ALL	JTF_RS_GROUPS_B	JTF_TERR_RSC_ALL.GROUP_ID
JTF_TTY_ACCT_RSC_DN	JTF_RS_GROUPS_B	JTF_TTY_ACCT_RSC_DN.RSC_GROUP_ID
JTF_TTY_ALIGN_PTERR	JTF_RS_GROUPS_B	JTF_TTY_ALIGN_PTERR.RSC_GROUP_ID
JTF_TTY_NAMED_ACCT_RSC	JTF_RS_GROUPS_B	JTF_TTY_NAMED_ACCT_RSC.RSC_GROUP_ID
JTF_TTY_RSC_ACCT_SUMM	JTF_RS_GROUPS_B	JTF_TTY_RSC_ACCT_SUMM.RSC_GROUP_ID
JTF_TTY_TERR_GRP_OWNERS	JTF_RS_GROUPS_B	JTF_TTY_TERR_GRP_OWNERS.RSC_GROUP_ID
OKC_K_ACCESSES	JTF_RS_GROUPS_B	OKC_K_ACCESSES.GROUP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL	JTF_RS_GROUPS_B	RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_SALESGROUP_ID
RA_CUST_TRX_LINE_SALESREPS_ALL	JTF_RS_GROUPS_B	RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_SALESGROUP_ID
RA_INTERFACE_SALESCREDITS_ALL	JTF_RS_GROUPS_B	RA_INTERFACE_SALESCREDITS_ALL.SALESGROUP_ID