[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | 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 |
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;
FTE.FTE_SEL_GROUP_ASSIGNMENTS does not reference any database object
FTE.FTE_SEL_GROUP_ASSIGNMENTS is referenced by following:
|
|
|