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: FTE.FTE_SEL_GROUP_ASSIGNMENTS

Object Details

Object Name:	FTE_SEL_GROUP_ASSIGNMENTS
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_SEL_GROUP_ASSIGNMENTS
Subobject Name:
Status:	VALID

this table provides the method to assign entities such as customer, customer site, shipping organization, etc... to a group or groups. The shipping enterprise group is not assigned in this table as the shipping enterprise is not defined as an entity itself in the database. Therefore, the assigned flag in the FTE_SEL_GROUPS table with a value of 'E' would associate a group to the shipping enterprise.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SEL_GROUP_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_SITE_ID
FTE_SEL_GROUP_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
FTE_SEL_GROUP_ASSIGNMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
FTE_SEL_GROUP_ASSIGNMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
FTE_SEL_GROUP_ASSIGNMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID

Columns

Name	Datatype	Mandatory	Comments
GROUP_ASSIGNMENT_ID	NUMBER	Yes	Primary key for the table
GROUP_ID	NUMBER	Yes	Group identifier for the assignment
CUSTOMER_ID	NUMBER		Customer id - populated when a group is assigned to a customer
CUSTOMER_SITE_ID	NUMBER		customer site identifier - populated when a group is assigned to a customer site
ORGANIZATION_ID	NUMBER		ship from organization identifier - populated when a group is assigned to an organization
CREATION_DATE	DATE	Yes	standard who column
CREATED_BY	NUMBER	Yes	standard who column
LAST_UPDATE_DATE	DATE	Yes	standard who column
LAST_UPDATED_BY	NUMBER	Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER		standard who column
LOCATION_ID	NUMBER		ship to location identifier for the customer site

Query Text

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


SELECT GROUP_ASSIGNMENT_ID
,      GROUP_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ORGANIZATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LOCATION_ID
FROM FTE.FTE_SEL_GROUP_ASSIGNMENTS;

Dependencies

[top of page]

FTE.FTE_SEL_GROUP_ASSIGNMENTS does not reference any database object

FTE.FTE_SEL_GROUP_ASSIGNMENTS is referenced by following:

APPS: FTE_SEL_GROUP_ASSIGNMENTS