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_SRP_GROUPS_STAGE

Object Details

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

This table is staging table for JTF_RS_SRP_GROUPS table which will be incrmentaly refreshed from this table. Intermediate table JTF_RS_SRP_GROUPS_INT will populate this table. This table will be refreshed by concurrent program "Update Primary Groups for Salespersons".

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_SRP_GROUPS_STAGE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALESREP_ID ORG_ID START_DATE END_DATE

Columns

Name	Datatype	Mandatory	Comments
SRP_GROUPS_ID	NUMBER	Yes	Unique Identifier
RESOURCE_ID	NUMBER	Yes	Resource Identifier of Salesrep
SALESREP_ID	NUMBER	Yes	Salesrep Identifier
ORG_ID	NUMBER		Organization Identifier for Salesrep
USER_ID	NUMBER		User Identifier for Salesrep
GROUP_ID	NUMBER		Primary Group Identifier for Salesrep
START_DATE	DATE		Start Date from which group becomes primary
END_DATE	DATE		End Date till which group remains primary
CREATED_BY	NUMBER	Yes	Record Created By
CREATION_DATE	DATE	Yes	Record Creation Date
LAST_UPDATED_BY	NUMBER	Yes	Record Updated By
LAST_UPDATE_DATE	DATE	Yes	Record Updation Date
LAST_UPDATE_LOGIN	NUMBER		Last Update Login
SECURITY_GROUP_ID	NUMBER		Security Group Id

Query Text

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


SELECT SRP_GROUPS_ID
,      RESOURCE_ID
,      SALESREP_ID
,      ORG_ID
,      USER_ID
,      GROUP_ID
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM JTF.JTF_RS_SRP_GROUPS_STAGE;

Dependencies

[top of page]

JTF.JTF_RS_SRP_GROUPS_STAGE does not reference any database object

JTF.JTF_RS_SRP_GROUPS_STAGE is referenced by following:

JTF: JTF_RS_SRP_GROUPS_STAGE#