FND Design Data [Home] [Help]

Table: AS_TERRITORIES_ALL

Product: AS - Sales Foundation
Description: Obsolete Sales out to JTF Terr Core -- Holds territory definitions
Implementation/DBA Data: TableOSM.AS_TERRITORIES_ALL
Primary Key: AS_TERRITORIES_PK
  1. ColumnTERRITORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_TERRITORIES_ALL FK Joins to TableAS_TERRITORY_TYPES_ALL AS_TERRITORIES_ALL.TERRITORY_TYPE_ID
AS_TERRITORIES_ALL FK Joins to TableAS_SALESFORCE AS_TERRITORIES_ALL.SALESFORCE_ID
AS_TERRITORIES_ALL FK Joins to TableAS_TERRITORY_GROUPS_ALL AS_TERRITORIES_ALL.TERRITORY_GROUP_ID
AS_TERRITORIES_ALL FK Joins to TableAS_TERRITORIES_ALL AS_TERRITORIES_ALL.EXPANDED_FROM_TERR_ID
TableAS_CHANGED_TERRITORIES_ALL FK Joins to AS_TERRITORIES_ALL AS_CHANGED_TERRITORIES_ALL.TERRITORY_ID
TableAS_TERRITORIES_ALL FK Joins to AS_TERRITORIES_ALL AS_TERRITORIES_ALL.EXPANDED_FROM_TERR_ID
TableAS_TERRITORY_ROLLUPS FK Joins to AS_TERRITORIES_ALL AS_TERRITORY_ROLLUPS.TERRITORY_ID
TableAS_TERRITORY_ROLLUPS FK Joins to AS_TERRITORIES_ALL AS_TERRITORY_ROLLUPS.ROLLUP_TERRITORY_ID