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_AREAS_B

Product:	JTF - CRM Foundation
Description:	A generic table to hold geographical location definitions that is not stored somewhere else in Oracle Applications.
Implementation/DBA Data:	JTF.JTF_LOC_AREAS_B

Primary Key: JTF_LOC_AREAS_B_PK

LOCATION_AREA_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_LOC_AREAS_B	JTF_LOC_TYPES_B	JTF_LOC_AREAS_B.LOCATION_TYPE_CODE
JTF_LOC_AREAS_B	JTF_LOC_AREAS_B	JTF_LOC_AREAS_B.PARENT_LOCATION_AREA_ID
JTF_LOC_AREAS_B	JTF_LOC_AREAS_B	JTF_LOC_AREAS_B.PARENT_LOCATION_AREA_ID
JTF_LOC_AREAS_TL	JTF_LOC_AREAS_B	JTF_LOC_AREAS_TL.LOCATION_AREA_ID
JTF_LOC_HIERARCHIES_B	JTF_LOC_AREAS_B	JTF_LOC_HIERARCHIES_B.POSTAL_CODE_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
JTF_LOC_POSTAL_CODES	JTF_LOC_AREAS_B	JTF_LOC_POSTAL_CODES.LOCATION_AREA_ID
OKR_IP_RGTS_TXN_TERR	JTF_LOC_AREAS_B	OKR_IP_RGTS_TXN_TERR.TERRITORY_ID