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_PARTY_SITES

Product:	AR - Receivables
Description:	Links party to physical locations
Implementation/DBA Data:	AR.HZ_PARTY_SITES

Primary Key: HZ_PARTY_SITES_PK

PARTY_SITE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_PARTY_SITES	HZ_PARTIES	HZ_PARTY_SITES.PARTY_ID
HZ_PARTY_SITES	HZ_LOCATIONS	HZ_PARTY_SITES.LOCATION_ID
AP_INVOICE_PAYMENTS_ALL	HZ_PARTY_SITES	AP_INVOICE_PAYMENTS_ALL.INVOICING_PARTY_SITE_ID
ASO_QUOTE_HEADERS_ALL	HZ_PARTY_SITES	ASO_QUOTE_HEADERS_ALL.INVOICE_TO_PARTY_SITE_ID
ASO_QUOTE_HEADERS_ALL	HZ_PARTY_SITES	ASO_QUOTE_HEADERS_ALL.SOLD_TO_PARTY_SITE_ID
ASO_QUOTE_LINES_ALL	HZ_PARTY_SITES	ASO_QUOTE_LINES_ALL.INVOICE_TO_PARTY_SITE_ID
ASO_SHIPMENTS	HZ_PARTY_SITES	ASO_SHIPMENTS.SHIP_TO_PARTY_SITE_ID
AS_ACCESSES_ALL_ALL	HZ_PARTY_SITES	AS_ACCESSES_ALL_ALL.ADDRESS_ID
AS_ACCESSES_ALL_ALL	HZ_PARTY_SITES	AS_ACCESSES_ALL_ALL.PARTNER_ADDRESS_ID
AS_CHANGED_ACCOUNTS_ALL	HZ_PARTY_SITES	AS_CHANGED_ACCOUNTS_ALL.ADDRESS_ID
AS_CURRENT_ENVIRONMENT	HZ_PARTY_SITES	AS_CURRENT_ENVIRONMENT.ADDRESS_ID
AS_INTERESTS_ALL	HZ_PARTY_SITES	AS_INTERESTS_ALL.ADDRESS_ID
AS_LEADS_ALL	HZ_PARTY_SITES	AS_LEADS_ALL.ADDRESS_ID
AS_LEAD_CONTACTS_ALL	HZ_PARTY_SITES	AS_LEAD_CONTACTS_ALL.ADDRESS_ID
AS_REF_ACT_LOCATIONS	HZ_PARTY_SITES	AS_REF_ACT_LOCATIONS.PARTY_SITE_ID
AS_REF_SITES	HZ_PARTY_SITES	AS_REF_SITES.PARTY_SITE_ID
AS_SALES_CREDITS_DENORM	HZ_PARTY_SITES	AS_SALES_CREDITS_DENORM.PARTNER_ADDRESS_ID
AS_SALES_CREDITS_DENORM	HZ_PARTY_SITES	AS_SALES_CREDITS_DENORM.ADDRESS_ID
AS_SALES_CREDITS	HZ_PARTY_SITES	AS_SALES_CREDITS.PARTNER_ADDRESS_ID
AS_SALES_LEADS	HZ_PARTY_SITES	AS_SALES_LEADS.ADDRESS_ID
AS_SALES_LEADS	HZ_PARTY_SITES	AS_SALES_LEADS.ADDRESS_ID
AS_SALES_LEAD_CONTACTS	HZ_PARTY_SITES	AS_SALES_LEAD_CONTACTS.ADDRESS_ID
AS_SALES_QUOTAS	HZ_PARTY_SITES	AS_SALES_QUOTAS.PARTNER_ADDRESS_ID
AS_TERR_RESOURCES_TMP	HZ_PARTY_SITES	AS_TERR_RESOURCES_TMP.PARTY_SITE_ID
JTA_SYNC_CONTACT_MAPPING	HZ_PARTY_SITES	JTA_SYNC_CONTACT_MAPPING.BUSINESS_PARTY_SITE_ID
CSI_ITEM_INSTANCES	HZ_PARTY_SITES	CSI_ITEM_INSTANCES.LOCATION_ID
CSI_SYSTEMS_B	HZ_PARTY_SITES	CSI_SYSTEMS_B.INSTALL_SITE_USE_ID
CSI_T_TXN_SYSTEMS	HZ_PARTY_SITES	CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID
CS_CP_AUDIT	HZ_PARTY_SITES	CS_CP_AUDIT.CURRENT_INSTALL_SITE_USE_ID
CS_CP_AUDIT	HZ_PARTY_SITES	CS_CP_AUDIT.OLD_INSTALL_SITE_USE_ID
CS_CP_AUDIT	HZ_PARTY_SITES	CS_CP_AUDIT.CURRENT_SHIP_TO_SITE_USE_ID
CS_CP_AUDIT	HZ_PARTY_SITES	CS_CP_AUDIT.OLD_SHIP_TO_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_PARTY_SITES	CS_CUSTOMER_PRODUCTS_ALL.SHIP_TO_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_PARTY_SITES	CS_CUSTOMER_PRODUCTS_ALL.INSTALL_SITE_USE_ID
CS_ESTIMATE_DETAILS	HZ_PARTY_SITES	CS_ESTIMATE_DETAILS.INVOICE_TO_ORG_ID
CS_ESTIMATE_DETAILS	HZ_PARTY_SITES	CS_ESTIMATE_DETAILS.SHIP_TO_ORG_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.BILL_TO_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.SHIP_TO_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INSTALL_SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.SITE_ID
CS_INCIDENTS_ALL_B	HZ_PARTY_SITES	CS_INCIDENTS_ALL_B.CUSTOMER_SITE_ID
CS_LINE_INST_DETAILS	HZ_PARTY_SITES	CS_LINE_INST_DETAILS.INSTALLED_AT_PARTY_SITE_ID
CS_SYSTEMS_ALL_B	HZ_PARTY_SITES	CS_SYSTEMS_ALL_B.SHIP_TO_SITE_USE_ID
CS_SYSTEMS_ALL_B	HZ_PARTY_SITES	CS_SYSTEMS_ALL_B.INSTALL_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_PARTY_SITES	CS_SYSTEM_AUDIT.OLD_SHIP_TO_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_PARTY_SITES	CS_SYSTEM_AUDIT.CURR_SHIP_TO_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_PARTY_SITES	CS_SYSTEM_AUDIT.OLD_INSTALL_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_PARTY_SITES	CS_SYSTEM_AUDIT.CURR_INSTALL_SITE_USE_ID
JTA_SYNC_CONTACT_MAPPING	HZ_PARTY_SITES	JTA_SYNC_CONTACT_MAPPING.HOME_PARTY_SITE_ID
HZ_CONTACT_POINTS	HZ_PARTY_SITES	HZ_CONTACT_POINTS.OWNER_TABLE_ID
HZ_CONTACT_RESTRICTIONS	HZ_PARTY_SITES	HZ_CONTACT_RESTRICTIONS.SUBJECT_ID
HZ_CUST_ACCT_SITES_ALL	HZ_PARTY_SITES	HZ_CUST_ACCT_SITES_ALL.PARTY_SITE_ID
HZ_DQM_SYNC_INTERFACE	HZ_PARTY_SITES	HZ_DQM_SYNC_INTERFACE.PARTY_SITE_ID
HZ_ORG_CONTACTS	HZ_PARTY_SITES	HZ_ORG_CONTACTS.PARTY_SITE_ID
%	HZ_PARTY_SITES
HZ_PARTY_SITES_EXT_B	HZ_PARTY_SITES	HZ_PARTY_SITES_EXT_B.PARTY_SITE_ID
HZ_PARTY_SITES_EXT_TL	HZ_PARTY_SITES	HZ_PARTY_SITES_EXT_TL.PARTY_SITE_ID
WSH_CARRIER_SITES	HZ_PARTY_SITES	WSH_CARRIER_SITES.CARRIER_SITE_ID
%	HZ_PARTY_SITES
HZ_PARTY_SITE_USES	HZ_PARTY_SITES	HZ_PARTY_SITE_USES.PARTY_SITE_ID
HZ_STAGED_CONTACT_POINTS	HZ_PARTY_SITES	HZ_STAGED_CONTACT_POINTS.PARTY_SITE_ID
IBE_ORD_ONECLICK_ALL	HZ_PARTY_SITES	IBE_ORD_ONECLICK_ALL.BILL_TO_PTY_SITE_ID
IBE_ORD_ONECLICK	HZ_PARTY_SITES	IBE_ORD_ONECLICK.BILL_TO_PTY_SITE_ID
IBE_ORD_ONECLICK	HZ_PARTY_SITES	IBE_ORD_ONECLICK.SHIP_TO_PTY_SITE_ID
IBE_ORD_ONECLICK_ALL	HZ_PARTY_SITES	IBE_ORD_ONECLICK_ALL.SHIP_TO_PTY_SITE_ID
IGS_AD_ADDR_INT_ALL	HZ_PARTY_SITES	IGS_AD_ADDR_INT_ALL.DUP_PARTY_SITE_ID
IGS_AD_IMP_NEAR_MTCH_ALL	HZ_PARTY_SITES	IGS_AD_IMP_NEAR_MTCH_ALL.PARTY_SITE_ID
IGS_PE_HZ_PTY_SITES	HZ_PARTY_SITES	IGS_PE_HZ_PTY_SITES.PARTY_SITE_ID
JAI_AP_ETDS_REQUESTS	HZ_PARTY_SITES	JAI_AP_ETDS_REQUESTS.TAX_AUTHORITY_SITE_ID
JAI_AP_ETDS_T	HZ_PARTY_SITES	JAI_AP_ETDS_T.BASE_VENDOR_SITE_ID
JAI_AP_TDS_F16_HDRS_ALL	HZ_PARTY_SITES	JAI_AP_TDS_F16_HDRS_ALL.VENDOR_SITE_ID
JAI_AP_TDS_PAYMENTS	HZ_PARTY_SITES	JAI_AP_TDS_PAYMENTS.VENDOR_SITE_ID
JAI_AP_TDS_PAYMENTS	HZ_PARTY_SITES	JAI_AP_TDS_PAYMENTS.TAX_AUTHORITY_SITE_ID
JAI_AP_TDS_THHOLD_TRXS	HZ_PARTY_SITES	JAI_AP_TDS_THHOLD_TRXS.TDS_AUTHORITY_VENDOR_SITE_ID
JAI_AP_TDS_THHOLD_TRXS	HZ_PARTY_SITES	JAI_AP_TDS_THHOLD_TRXS.VENDOR_SITE_ID
JAI_AP_TDS_VENDOR_HDRS	HZ_PARTY_SITES	JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID
JAI_AR_ETCS_T	HZ_PARTY_SITES	JAI_AR_ETCS_T.PARTY_SITE_ID
JAI_AR_SUP_CHANGES_ALL	HZ_PARTY_SITES	JAI_AR_SUP_CHANGES_ALL.SITE_USE_ID
JAI_AR_SUP_HDRS_ALL	HZ_PARTY_SITES	JAI_AR_SUP_HDRS_ALL.CUSTOMER_SITE
JAI_AR_SUP_INV_T	HZ_PARTY_SITES	JAI_AR_SUP_INV_T.CUSTOMER_SITE
JAI_AR_TRX_SUP_INV_T	HZ_PARTY_SITES	JAI_AR_TRX_SUP_INV_T.CUSTOMER_SITE
JAI_CMN_BOE_HDRS	HZ_PARTY_SITES	JAI_CMN_BOE_HDRS.VENDOR_SITE_ID
JAI_CMN_CUS_ADDRESSES	HZ_PARTY_SITES	JAI_CMN_CUS_ADDRESSES.ADDRESS_ID
JAI_CMN_MTAX_HDRS_ALL	HZ_PARTY_SITES	JAI_CMN_MTAX_HDRS_ALL.SUPPLIER_SITE_ID
JAI_CMN_MTAX_HDRS_ALL	HZ_PARTY_SITES	JAI_CMN_MTAX_HDRS_ALL.CUSTOMER_SITE_ID
JAI_CMN_OM_AR_AR3_FORMS	HZ_PARTY_SITES	JAI_CMN_OM_AR_AR3_FORMS.CUSTOMER_SITE_ID
JAI_CMN_RG_23AC_II_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23AC_II_TRXS.VENDOR_SITE_ID
JAI_CMN_RG_23AC_I_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23AC_I_TRXS.CUSTOMER_SITE_ID
JAI_CMN_RG_23AC_I_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23AC_I_TRXS.VENDOR_SITE_ID
JAI_CMN_RG_23D_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23D_TRXS.SHIP_TO_SITE_ID
JAI_CMN_RG_23D_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23D_TRXS.VENDOR_SITE_ID
JAI_CMN_RG_23D_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_23D_TRXS.BILL_TO_SITE_ID
JAI_CMN_RG_I_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_I_TRXS.CUSTOMER_SITE_ID
JAI_CMN_RG_I_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_I_TRXS.VENDOR_SITE_ID
JAI_CMN_RG_PLA_HDRS	HZ_PARTY_SITES	JAI_CMN_RG_PLA_HDRS.VENDOR_SITE_ID
JAI_CMN_RG_PLA_TRXS	HZ_PARTY_SITES	JAI_CMN_RG_PLA_TRXS.VENDOR_SITE_ID
JAI_CMN_STFORM_HDRS_ALL	HZ_PARTY_SITES	JAI_CMN_STFORM_HDRS_ALL.PARTY_SITE_ID
JAI_CMN_TAXES_ALL	HZ_PARTY_SITES	JAI_CMN_TAXES_ALL.VENDOR_SITE_ID
JAI_CMN_VENDOR_SITES	HZ_PARTY_SITES	JAI_CMN_VENDOR_SITES.VENDOR_SITE_ID
JAI_FBT_SETTLEMENT	HZ_PARTY_SITES	JAI_FBT_SETTLEMENT.INV_SUPPLIER_SITE_ID
JAI_PO_OSP_HDRS	HZ_PARTY_SITES	JAI_PO_OSP_HDRS.VENDOR_SITE_ID
JAI_PO_REP_PRRG_T	HZ_PARTY_SITES	JAI_PO_REP_PRRG_T.VENDOR_SITE_ID
JAI_RCV_CENVAT_CLAIMS	HZ_PARTY_SITES	JAI_RCV_CENVAT_CLAIMS.VENDOR_SITE_ID
JAI_RCV_HEADERS	HZ_PARTY_SITES	JAI_RCV_HEADERS.VENDOR_SITE_ID
JAI_RCV_HEADERS	HZ_PARTY_SITES	JAI_RCV_HEADERS.CUSTOMER_SITE_ID
JAI_RCV_LINE_TAXES	HZ_PARTY_SITES	JAI_RCV_LINE_TAXES.VENDOR_SITE_ID
JAI_RCV_RGM_LINES	HZ_PARTY_SITES	JAI_RCV_RGM_LINES.VENDOR_SITE_ID
JAI_RCV_RTV_BATCH_GRPS	HZ_PARTY_SITES	JAI_RCV_RTV_BATCH_GRPS.VENDOR_SITE_ID
JAI_RCV_TP_INVOICES	HZ_PARTY_SITES	JAI_RCV_TP_INVOICES.VENDOR_SITE_ID
JAI_RGM_CERTIFICATES	HZ_PARTY_SITES	JAI_RGM_CERTIFICATES.PARTY_SITE_ID
JAI_RGM_INVOICE_GEN_T	HZ_PARTY_SITES	JAI_RGM_INVOICE_GEN_T.PARTY_SITE_ID
JAI_RGM_MANUAL_TRXS	HZ_PARTY_SITES	JAI_RGM_MANUAL_TRXS.PARTY_SITE_ID
JAI_RGM_PARTIES	HZ_PARTY_SITES	JAI_RGM_PARTIES.AUTHORITY_SITE_ID
JAI_RGM_REFS_ALL	HZ_PARTY_SITES	JAI_RGM_REFS_ALL.PARTY_SITE_ID
JAI_RGM_SETTLEMENTS	HZ_PARTY_SITES	JAI_RGM_SETTLEMENTS.TAX_AUTHORITY_SITE_ID
JAI_RGM_TRX_REFS	HZ_PARTY_SITES	JAI_RGM_TRX_REFS.PARTY_SITE_ID
JTF_RS_RESOURCE_EXTNS	HZ_PARTY_SITES	JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID
JTF_RS_RESOURCE_EXTN_AUD	HZ_PARTY_SITES	JTF_RS_RESOURCE_EXTN_AUD.OLD_SUPPORT_SITE_ID
JTF_RS_RESOURCE_EXTN_AUD	HZ_PARTY_SITES	JTF_RS_RESOURCE_EXTN_AUD.NEW_SUPPORT_SITE_ID
JTF_TASKS_B	HZ_PARTY_SITES	JTF_TASKS_B.ADDRESS_ID
JTF_TASK_AUDITS_B	HZ_PARTY_SITES	JTF_TASK_AUDITS_B.OLD_ADDRESS_ID
JTF_TASK_AUDITS_B	HZ_PARTY_SITES	JTF_TASK_AUDITS_B.NEW_ADDRESS_ID
JTF_TASKS_B	HZ_PARTY_SITES	JTF_TASKS_B.ADDRESS_ID
MTL_CLIENT_PARAMETERS	HZ_PARTY_SITES	MTL_CLIENT_PARAMETERS.TRADING_PARTNER_SITE_ID
OE_HEADERS_IFACE_ALL	HZ_PARTY_SITES	OE_HEADERS_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.DELIVER_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.END_CUSTOMER_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.INVOICE_TO_PARTY_SITE_ID
OE_LINES_IFACE_ALL	HZ_PARTY_SITES	OE_LINES_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
OKL_INS_POLICIES_ALL_B	HZ_PARTY_SITES	OKL_INS_POLICIES_ALL_B.AGENCY_SITE_ID
OKL_INS_POLICIES_ALL_B	HZ_PARTY_SITES	OKL_INS_POLICIES_ALL_B.AGENT_SITE_ID
OKL_INS_POLICIES_B	HZ_PARTY_SITES	OKL_INS_POLICIES_B.AGENCY_SITE_ID
OKL_INS_POLICIES_B	HZ_PARTY_SITES	OKL_INS_POLICIES_B.AGENT_SITE_ID
OKL_TAX_SOURCES	HZ_PARTY_SITES	OKL_TAX_SOURCES.SHIP_TO_PARTY_SITE_ID
OKL_TAX_SOURCES	HZ_PARTY_SITES	OKL_TAX_SOURCES.BILL_TO_PARTY_SITE_ID
OKL_TAX_SOURCES_T	HZ_PARTY_SITES	OKL_TAX_SOURCES_T.SHIP_TO_PARTY_SITE_ID
OKL_TAX_SOURCES_T	HZ_PARTY_SITES	OKL_TAX_SOURCES_T.BILL_TO_PARTY_SITE_ID
PA_PROJECT_REQUESTS	HZ_PARTY_SITES	PA_PROJECT_REQUESTS.CUST_PARTY_SITE_ID
POS_ACCT_ADDR_REL	HZ_PARTY_SITES	POS_ACCT_ADDR_REL.ADDRESS_ID
POS_ACNT_ADDR_REQ	HZ_PARTY_SITES	POS_ACNT_ADDR_REQ.PARTY_SITE_ID
POS_ACNT_PAY_PREF	HZ_PARTY_SITES	POS_ACNT_PAY_PREF.PARTY_SITE_ID
POS_ADDRESS_NOTES	HZ_PARTY_SITES	POS_ADDRESS_NOTES.PARTY_SITE_ID
POS_ADDRESS_REQUESTS	HZ_PARTY_SITES	POS_ADDRESS_REQUESTS.PARTY_SITE_ID
POS_CONT_ADDR_REQUESTS	HZ_PARTY_SITES	POS_CONT_ADDR_REQUESTS.PARTY_SITE_ID
ZX_PARTY_TAX_PROFILE	HZ_PARTY_SITES	ZX_PARTY_TAX_PROFILE.PARTY_ID