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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.JTF_RS_SRP_GROUPS_V

Object Details

Object Name:	JTF_RS_SRP_GROUPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_SRP_GROUPS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is for fetching the Default Group for a Salesrep. The filters to be applied to get the data are: salesrep_id, org_id. If the primary group is required for a specific date, then role_start_date and role_end_date also has to be used in filter. The resultset is ordered. So, the first row will be the best fit for primary group.

[View Source]

Columns

Name	Datatype	Length	Comments
RESOURCE_ID	NUMBER		Resource Id of the Salesrep
SALESREP_ID	NUMBER		Salesrep Id of the Salesrep
ORG_ID	NUMBER		Org Id of the Salesrep
USER_ID	NUMBER		User Id of the Salesrep
GROUP_ID	NUMBER		Group Id for the Salesrep
GROUP_NAME	VARCHAR2	(60)	Group Name of the corresponding Group Id
ROLE_TYPE_CODE	VARCHAR2	(240)	Role Type Code
ROLE_ID	NUMBER		Role Id of the role Salesrep has in Group
ROLE_TYPE_PRIORITY	NUMBER		Role Type Priority. Value '1' for any role of role type 'SALES'. All others will have priority of '2'.
ROLE_PRIORITY	NUMBER		Role Priority. For Manager, Admin, Lead and Member, the values are 1,2,3 and 4 respectively.
ROLE_START_DATE	DATE		Start date for role.
ROLE_END_DATE	DATE		End date for role.
DENORM_COUNT	NUMBER		Value of the position of group in the hierarchy. Lower the count, higher is the group in the hierarchy.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_ID
,      SALESREP_ID
,      ORG_ID
,      USER_ID
,      GROUP_ID
,      GROUP_NAME
,      ROLE_TYPE_CODE
,      ROLE_ID
,      ROLE_TYPE_PRIORITY
,      ROLE_PRIORITY
,      ROLE_START_DATE
,      ROLE_END_DATE
,      DENORM_COUNT
FROM APPS.JTF_RS_SRP_GROUPS_V;

Dependencies

[top of page]

APPS.JTF_RS_SRP_GROUPS_V references the following:

APPS: JTF_RS_GROUPS_DENORM; JTF_RS_GROUPS_TL; JTF_RS_GROUP_MEMBERS; JTF_RS_GROUP_USAGES; JTF_RS_RESOURCE_EXTNS; JTF_RS_ROLES_B; JTF_RS_ROLE_RELATIONS; JTF_RS_SALESREPS
PUBLIC: DUAL

APPS.JTF_RS_SRP_GROUPS_V is not referenced by any database object