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

Object Details

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

This table contains information about default groups for specific set of resources for given usage for a specific date. For example, what was the primary district (group) of Field Service Engineer, Bill on 12-Jul-2004. This table is not populated online. It depends on Concurrant programs for its population.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_DEFAULT_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID RESOURCE_NUMBER START_DATE END_DATE USAGE

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 primary group of resource
START_DATE	DATE			Start Date from which group becomes primary
END_DATE	DATE			End Date till which group remains primary
USAGE	VARCHAR2	(240)		Usage of the group
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
,      START_DATE
,      END_DATE
,      USAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM JTF.JTF_RS_DEFAULT_GROUPS;

Dependencies

[top of page]

JTF.JTF_RS_DEFAULT_GROUPS does not reference any database object

JTF.JTF_RS_DEFAULT_GROUPS is referenced by following:

APPS: ISC_FS_015_MV; ISC_FS_016_MV; JTF_RS_DEFAULT_GROUPS