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]

TABLE: JTF.JTF_RS_DEFAULT_GROUPS_INT

Object Details

Object Name:	JTF_RS_DEFAULT_GROUPS_INT
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_DEFAULT_GROUPS_INT
Subobject Name:
Status:	VALID

This is intermediate table for processing data and inserting into JTF_RS_DEFAULT_GROUPS table. This table is populated by concurrent programs like Populate Primary Districts for Field Service Engineers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_DEFAULT_GROUPS_INT_N1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	"START_DATE"

Columns

Name	Datatype	Length	Mandatory	Comments
DEFAULT_GROUPS_ID	NUMBER		Yes	Unique Identifier
RESOURCE_ID	NUMBER		Yes	Resource Id for which default group has to be checked
USER_ID	NUMBER			User Id corresponding to Resource Id
RESOURCE_NUMBER	VARCHAR2	(30)		Resource Number of the resource
GROUP_ID	NUMBER			Group Id of group to which resource belongs
USAGE	VARCHAR2	(240)		Usage of Group
ROLE_TYPE_CODE	VARCHAR2	(60)		Role Type Code
ROLE_ID	NUMBER			Role Id
ROLE_TYPE_PRIORITY	NUMBER			Role Type Priority based on rules defined by Product Teams
ROLE_PRIORITY	NUMBER			Role Priority based on rules defined by Product Teams
START_DATE	DATE			Start Date of role in group
END_DATE	DATE			End Date of role in group
DENORM_COUNT	NUMBER			Position of group in a group hierarchy
CREATED_BY	NUMBER		Yes	Record Created by user id
CREATION_DATE	DATE		Yes	Record Created on date
LAST_UPDATED_BY	NUMBER		Yes	User Id of user who last updated this record
LAST_UPDATE_DATE	DATE		Yes	Date on which this record was last updated
LAST_UPDATE_LOGIN	NUMBER			Login Id of user who updated this record
SECURITY_GROUP_ID	NUMBER			Security Group Id

Query Text

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


SELECT DEFAULT_GROUPS_ID
,      RESOURCE_ID
,      USER_ID
,      RESOURCE_NUMBER
,      GROUP_ID
,      USAGE
,      ROLE_TYPE_CODE
,      ROLE_ID
,      ROLE_TYPE_PRIORITY
,      ROLE_PRIORITY
,      START_DATE
,      END_DATE
,      DENORM_COUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM JTF.JTF_RS_DEFAULT_GROUPS_INT;

Dependencies

[top of page]

JTF.JTF_RS_DEFAULT_GROUPS_INT does not reference any database object

JTF.JTF_RS_DEFAULT_GROUPS_INT is referenced by following:

APPS: JTF_RS_DEFAULT_GROUPS_INT