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.

[Home] [Help]

Table: JTF_LOC_HIERARCHIES_B

Product:	JTF - CRM Foundation
Description:	Stores a flattened out structure of all geographical information.
Implementation/DBA Data:	JTF.JTF_LOC_HIERARCHIES_B

Primary Key: JTF_LOC_HIERARCHIES_B_PK

LOCATION_HIERARCHY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_LOC_HIERARCHIES_B	JTF_LOC_TYPES_B	JTF_LOC_HIERARCHIES_B.LOCATION_TYPE_CODE
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.POSTAL_CODE_ID
JTF_LOC_HIERARCHIES_B	FND_APPLICATION	JTF_LOC_HIERARCHIES_B.CREATED_BY_APPLICATION_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.AREA1_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.AREA2_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.COUNTRY_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.STATE_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.COUNTRY_REGION_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.STATE_REGION_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.CITY_ID
AMS_ACT_GEO_AREAS	JTF_LOC_HIERARCHIES_B	AMS_ACT_GEO_AREAS.GEO_HIERARCHY_ID
AMS_CAMPAIGNS_ALL_B	JTF_LOC_HIERARCHIES_B	AMS_CAMPAIGNS_ALL_B.CITY_ID