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: HZ_LOCATIONS

Product:	AR - Receivables
Description:	Physical addresses
Implementation/DBA Data:	AR.HZ_LOCATIONS

Primary Key: HZ_LOCATIONS_PK

LOCATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_LOCATIONS	FND_LANGUAGES	HZ_LOCATIONS.LANGUAGE
HZ_LOCATIONS	FND_TERRITORIES	HZ_LOCATIONS.COUNTRY
HZ_LOCATIONS	HZ_TIMEZONES	HZ_LOCATIONS.TIMEZONE_ID
HZ_LOCATIONS	FND_LANGUAGES	HZ_LOCATIONS.LANGUAGE
HZ_LOCATIONS	FND_TERRITORIES	HZ_LOCATIONS.COUNTRY
AMS_EVENT_OFFERS_ALL_B	HZ_LOCATIONS	AMS_EVENT_OFFERS_ALL_B.EVENT_LOCATION_ID
AMS_IMP_SOURCE_LINES	HZ_LOCATIONS	AMS_IMP_SOURCE_LINES.LOCATION_ID
AMS_LIST_ENTRIES	HZ_LOCATIONS	AMS_LIST_ENTRIES.LOCATION_ID
AMS_VENUES_B	HZ_LOCATIONS	AMS_VENUES_B.LOCATION_ID
AS_REF_ACT_LOCATIONS	HZ_LOCATIONS	AS_REF_ACT_LOCATIONS.LOCATION_ID
JTA_SYNC_CONTACT_MAPPING	HZ_LOCATIONS	JTA_SYNC_CONTACT_MAPPING.BUSINESS_PARTY_LOCATION_ID
CS_INCIDENTS_ALL_B	HZ_LOCATIONS	CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID
JTA_SYNC_CONTACT_MAPPING	HZ_LOCATIONS	JTA_SYNC_CONTACT_MAPPING.HOME_PARTY_LOCATION_ID
HZ_LOCATIONS_EXT_B	HZ_LOCATIONS	HZ_LOCATIONS_EXT_B.LOCATION_ID
HZ_LOCATIONS_EXT_TL	HZ_LOCATIONS	HZ_LOCATIONS_EXT_TL.LOCATION_ID
HZ_LOCATION_PROFILES	HZ_LOCATIONS	HZ_LOCATION_PROFILES.LOCATION_ID
HZ_LOC_ASSIGNMENTS_OBS	HZ_LOCATIONS	HZ_LOC_ASSIGNMENTS_OBS.LOCATION_ID
HZ_LOC_ASSIGNMENTS	HZ_LOCATIONS	HZ_LOC_ASSIGNMENTS.LOCATION_ID
HZ_PARTY_SITES	HZ_LOCATIONS	HZ_PARTY_SITES.LOCATION_ID
IBY_BANKACCT	HZ_LOCATIONS	IBY_BANKACCT.ADDRESSID
JAI_PA_DRAFT_INVOICES	HZ_LOCATIONS	JAI_PA_DRAFT_INVOICES.LOCATION_ID
JAI_PA_DRAFT_INVOICE_LINES	HZ_LOCATIONS	JAI_PA_DRAFT_INVOICE_LINES.LOCATION_ID
JAI_RGM_REFS_ALL	HZ_LOCATIONS	JAI_RGM_REFS_ALL.LOCATION_ID
OZF_CLAIMS_ALL	HZ_LOCATIONS	OZF_CLAIMS_ALL.LOCATION_ID
IGS_PE_HZ_LOCATIONS	HZ_LOCATIONS	IGS_PE_HZ_LOCATIONS.LOCATION_ID
ZX_LINES_DET_FACTORS	HZ_LOCATIONS	ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID
ZX_LINES_DET_FACTORS	HZ_LOCATIONS	ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS	HZ_LOCATIONS	ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID
ZX_LINES_DET_FACTORS	HZ_LOCATIONS	ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID