FND Design Data [Home] [Help]

Table: HZ_PARTY_SITES

Product: AR - Receivables
Description: Links party to physical locations
Implementation/DBA Data: TableAR.HZ_PARTY_SITES
Primary Key: HZ_PARTY_SITES_PK
  1. ColumnPARTY_SITE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HZ_PARTY_SITES FK Joins to TableHZ_PARTIES HZ_PARTY_SITES.PARTY_ID
HZ_PARTY_SITES FK Joins to TableHZ_LOCATIONS HZ_PARTY_SITES.LOCATION_ID
TableAP_INVOICE_PAYMENTS_ALL FK Joins to HZ_PARTY_SITES AP_INVOICE_PAYMENTS_ALL.INVOICING_PARTY_SITE_ID
TableASO_QUOTE_HEADERS_ALL FK Joins to HZ_PARTY_SITES ASO_QUOTE_HEADERS_ALL.INVOICE_TO_PARTY_SITE_ID
TableASO_QUOTE_HEADERS_ALL FK Joins to HZ_PARTY_SITES ASO_QUOTE_HEADERS_ALL.SOLD_TO_PARTY_SITE_ID
TableASO_QUOTE_LINES_ALL FK Joins to HZ_PARTY_SITES ASO_QUOTE_LINES_ALL.INVOICE_TO_PARTY_SITE_ID
TableASO_SHIPMENTS FK Joins to HZ_PARTY_SITES ASO_SHIPMENTS.SHIP_TO_PARTY_SITE_ID
TableAS_ACCESSES_ALL_ALL FK Joins to HZ_PARTY_SITES AS_ACCESSES_ALL_ALL.ADDRESS_ID
TableAS_ACCESSES_ALL_ALL FK Joins to HZ_PARTY_SITES AS_ACCESSES_ALL_ALL.PARTNER_ADDRESS_ID
TableAS_CHANGED_ACCOUNTS_ALL FK Joins to HZ_PARTY_SITES AS_CHANGED_ACCOUNTS_ALL.ADDRESS_ID
TableAS_CURRENT_ENVIRONMENT FK Joins to HZ_PARTY_SITES AS_CURRENT_ENVIRONMENT.ADDRESS_ID
TableAS_INTERESTS_ALL FK Joins to HZ_PARTY_SITES AS_INTERESTS_ALL.ADDRESS_ID
TableAS_LEADS_ALL FK Joins to HZ_PARTY_SITES AS_LEADS_ALL.ADDRESS_ID
TableAS_LEAD_CONTACTS_ALL FK Joins to HZ_PARTY_SITES AS_LEAD_CONTACTS_ALL.ADDRESS_ID
TableAS_REF_ACT_LOCATIONS FK Joins to HZ_PARTY_SITES AS_REF_ACT_LOCATIONS.PARTY_SITE_ID
TableAS_REF_SITES FK Joins to HZ_PARTY_SITES AS_REF_SITES.PARTY_SITE_ID
TableAS_SALES_CREDITS_DENORM FK Joins to HZ_PARTY_SITES AS_SALES_CREDITS_DENORM.PARTNER_ADDRESS_ID
TableAS_SALES_CREDITS_DENORM FK Joins to HZ_PARTY_SITES AS_SALES_CREDITS_DENORM.ADDRESS_ID
TableAS_SALES_CREDITS FK Joins to HZ_PARTY_SITES AS_SALES_CREDITS.PARTNER_ADDRESS_ID
TableAS_SALES_LEADS FK Joins to HZ_PARTY_SITES AS_SALES_LEADS.ADDRESS_ID
TableAS_SALES_LEADS FK Joins to HZ_PARTY_SITES AS_SALES_LEADS.ADDRESS_ID
TableAS_SALES_LEAD_CONTACTS FK Joins to HZ_PARTY_SITES AS_SALES_LEAD_CONTACTS.ADDRESS_ID
TableAS_SALES_QUOTAS FK Joins to HZ_PARTY_SITES AS_SALES_QUOTAS.PARTNER_ADDRESS_ID
TableAS_TERR_RESOURCES_TMP FK Joins to HZ_PARTY_SITES AS_TERR_RESOURCES_TMP.PARTY_SITE_ID
TableJTA_SYNC_CONTACT_MAPPING FK Joins to HZ_PARTY_SITES JTA_SYNC_CONTACT_MAPPING.BUSINESS_PARTY_SITE_ID
TableCSI_ITEM_INSTANCES FK Joins to HZ_PARTY_SITES CSI_ITEM_INSTANCES.LOCATION_ID
TableCSI_SYSTEMS_B FK Joins to HZ_PARTY_SITES CSI_SYSTEMS_B.INSTALL_SITE_USE_ID
TableCSI_T_TXN_SYSTEMS FK Joins to HZ_PARTY_SITES CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID
TableCS_CP_AUDIT FK Joins to HZ_PARTY_SITES CS_CP_AUDIT.CURRENT_INSTALL_SITE_USE_ID
TableCS_CP_AUDIT FK Joins to HZ_PARTY_SITES CS_CP_AUDIT.OLD_INSTALL_SITE_USE_ID
TableCS_CP_AUDIT FK Joins to HZ_PARTY_SITES CS_CP_AUDIT.CURRENT_SHIP_TO_SITE_USE_ID
TableCS_CP_AUDIT FK Joins to HZ_PARTY_SITES CS_CP_AUDIT.OLD_SHIP_TO_SITE_USE_ID
TableCS_CUSTOMER_PRODUCTS_ALL FK Joins to HZ_PARTY_SITES CS_CUSTOMER_PRODUCTS_ALL.SHIP_TO_SITE_USE_ID
TableCS_CUSTOMER_PRODUCTS_ALL FK Joins to HZ_PARTY_SITES CS_CUSTOMER_PRODUCTS_ALL.INSTALL_SITE_USE_ID
TableCS_ESTIMATE_DETAILS FK Joins to HZ_PARTY_SITES CS_ESTIMATE_DETAILS.INVOICE_TO_ORG_ID
TableCS_ESTIMATE_DETAILS FK Joins to HZ_PARTY_SITES CS_ESTIMATE_DETAILS.SHIP_TO_ORG_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.BILL_TO_SITE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.SHIP_TO_SITE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.INSTALL_SITE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.SITE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_PARTY_SITES CS_INCIDENTS_ALL_B.CUSTOMER_SITE_ID
TableCS_LINE_INST_DETAILS FK Joins to HZ_PARTY_SITES CS_LINE_INST_DETAILS.INSTALLED_AT_PARTY_SITE_ID
TableCS_SYSTEMS_ALL_B FK Joins to HZ_PARTY_SITES CS_SYSTEMS_ALL_B.SHIP_TO_SITE_USE_ID
TableCS_SYSTEMS_ALL_B FK Joins to HZ_PARTY_SITES CS_SYSTEMS_ALL_B.INSTALL_SITE_USE_ID
TableCS_SYSTEM_AUDIT FK Joins to HZ_PARTY_SITES CS_SYSTEM_AUDIT.OLD_SHIP_TO_SITE_USE_ID
TableCS_SYSTEM_AUDIT FK Joins to HZ_PARTY_SITES CS_SYSTEM_AUDIT.CURR_SHIP_TO_SITE_USE_ID
TableCS_SYSTEM_AUDIT FK Joins to HZ_PARTY_SITES CS_SYSTEM_AUDIT.OLD_INSTALL_SITE_USE_ID
TableCS_SYSTEM_AUDIT FK Joins to HZ_PARTY_SITES CS_SYSTEM_AUDIT.CURR_INSTALL_SITE_USE_ID
TableJTA_SYNC_CONTACT_MAPPING FK Joins to HZ_PARTY_SITES JTA_SYNC_CONTACT_MAPPING.HOME_PARTY_SITE_ID
TableHZ_CONTACT_POINTS FK Joins to HZ_PARTY_SITES HZ_CONTACT_POINTS.OWNER_TABLE_ID
TableHZ_CONTACT_RESTRICTIONS FK Joins to HZ_PARTY_SITES HZ_CONTACT_RESTRICTIONS.SUBJECT_ID
TableHZ_CUST_ACCT_SITES_ALL FK Joins to HZ_PARTY_SITES HZ_CUST_ACCT_SITES_ALL.PARTY_SITE_ID
TableHZ_DQM_SYNC_INTERFACE FK Joins to HZ_PARTY_SITES HZ_DQM_SYNC_INTERFACE.PARTY_SITE_ID
TableHZ_ORG_CONTACTS FK Joins to HZ_PARTY_SITES HZ_ORG_CONTACTS.PARTY_SITE_ID
Table% FK Joins to HZ_PARTY_SITES
TableHZ_PARTY_SITES_EXT_B FK Joins to HZ_PARTY_SITES HZ_PARTY_SITES_EXT_B.PARTY_SITE_ID
TableHZ_PARTY_SITES_EXT_TL FK Joins to HZ_PARTY_SITES HZ_PARTY_SITES_EXT_TL.PARTY_SITE_ID
TableWSH_CARRIER_SITES FK Joins to HZ_PARTY_SITES WSH_CARRIER_SITES.CARRIER_SITE_ID
Table% FK Joins to HZ_PARTY_SITES
TableHZ_PARTY_SITE_USES FK Joins to HZ_PARTY_SITES HZ_PARTY_SITE_USES.PARTY_SITE_ID
TableHZ_STAGED_CONTACT_POINTS FK Joins to HZ_PARTY_SITES HZ_STAGED_CONTACT_POINTS.PARTY_SITE_ID
TableIBE_ORD_ONECLICK_ALL FK Joins to HZ_PARTY_SITES IBE_ORD_ONECLICK_ALL.BILL_TO_PTY_SITE_ID
TableIBE_ORD_ONECLICK FK Joins to HZ_PARTY_SITES IBE_ORD_ONECLICK.BILL_TO_PTY_SITE_ID
TableIBE_ORD_ONECLICK FK Joins to HZ_PARTY_SITES IBE_ORD_ONECLICK.SHIP_TO_PTY_SITE_ID
TableIBE_ORD_ONECLICK_ALL FK Joins to HZ_PARTY_SITES IBE_ORD_ONECLICK_ALL.SHIP_TO_PTY_SITE_ID
TableIGS_AD_ADDR_INT_ALL FK Joins to HZ_PARTY_SITES IGS_AD_ADDR_INT_ALL.DUP_PARTY_SITE_ID
TableIGS_AD_IMP_NEAR_MTCH_ALL FK Joins to HZ_PARTY_SITES IGS_AD_IMP_NEAR_MTCH_ALL.PARTY_SITE_ID
TableIGS_PE_HZ_PTY_SITES FK Joins to HZ_PARTY_SITES IGS_PE_HZ_PTY_SITES.PARTY_SITE_ID
TableJAI_AP_ETDS_REQUESTS FK Joins to HZ_PARTY_SITES JAI_AP_ETDS_REQUESTS.TAX_AUTHORITY_SITE_ID
TableJAI_AP_ETDS_T FK Joins to HZ_PARTY_SITES JAI_AP_ETDS_T.BASE_VENDOR_SITE_ID
TableJAI_AP_TDS_F16_HDRS_ALL FK Joins to HZ_PARTY_SITES JAI_AP_TDS_F16_HDRS_ALL.VENDOR_SITE_ID
TableJAI_AP_TDS_PAYMENTS FK Joins to HZ_PARTY_SITES JAI_AP_TDS_PAYMENTS.VENDOR_SITE_ID
TableJAI_AP_TDS_PAYMENTS FK Joins to HZ_PARTY_SITES JAI_AP_TDS_PAYMENTS.TAX_AUTHORITY_SITE_ID
TableJAI_AP_TDS_THHOLD_TRXS FK Joins to HZ_PARTY_SITES JAI_AP_TDS_THHOLD_TRXS.TDS_AUTHORITY_VENDOR_SITE_ID
TableJAI_AP_TDS_THHOLD_TRXS FK Joins to HZ_PARTY_SITES JAI_AP_TDS_THHOLD_TRXS.VENDOR_SITE_ID
TableJAI_AP_TDS_VENDOR_HDRS FK Joins to HZ_PARTY_SITES JAI_AP_TDS_VENDOR_HDRS.VENDOR_SITE_ID
TableJAI_AR_ETCS_T FK Joins to HZ_PARTY_SITES JAI_AR_ETCS_T.PARTY_SITE_ID
TableJAI_AR_SUP_CHANGES_ALL FK Joins to HZ_PARTY_SITES JAI_AR_SUP_CHANGES_ALL.SITE_USE_ID
TableJAI_AR_SUP_HDRS_ALL FK Joins to HZ_PARTY_SITES JAI_AR_SUP_HDRS_ALL.CUSTOMER_SITE
TableJAI_AR_SUP_INV_T FK Joins to HZ_PARTY_SITES JAI_AR_SUP_INV_T.CUSTOMER_SITE
TableJAI_AR_TRX_SUP_INV_T FK Joins to HZ_PARTY_SITES JAI_AR_TRX_SUP_INV_T.CUSTOMER_SITE
TableJAI_CMN_BOE_HDRS FK Joins to HZ_PARTY_SITES JAI_CMN_BOE_HDRS.VENDOR_SITE_ID
TableJAI_CMN_CUS_ADDRESSES FK Joins to HZ_PARTY_SITES JAI_CMN_CUS_ADDRESSES.ADDRESS_ID
TableJAI_CMN_MTAX_HDRS_ALL FK Joins to HZ_PARTY_SITES JAI_CMN_MTAX_HDRS_ALL.SUPPLIER_SITE_ID
TableJAI_CMN_MTAX_HDRS_ALL FK Joins to HZ_PARTY_SITES JAI_CMN_MTAX_HDRS_ALL.CUSTOMER_SITE_ID
TableJAI_CMN_OM_AR_AR3_FORMS FK Joins to HZ_PARTY_SITES JAI_CMN_OM_AR_AR3_FORMS.CUSTOMER_SITE_ID
TableJAI_CMN_RG_23AC_II_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23AC_II_TRXS.VENDOR_SITE_ID
TableJAI_CMN_RG_23AC_I_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23AC_I_TRXS.CUSTOMER_SITE_ID
TableJAI_CMN_RG_23AC_I_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23AC_I_TRXS.VENDOR_SITE_ID
TableJAI_CMN_RG_23D_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23D_TRXS.SHIP_TO_SITE_ID
TableJAI_CMN_RG_23D_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23D_TRXS.VENDOR_SITE_ID
TableJAI_CMN_RG_23D_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_23D_TRXS.BILL_TO_SITE_ID
TableJAI_CMN_RG_I_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_I_TRXS.CUSTOMER_SITE_ID
TableJAI_CMN_RG_I_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_I_TRXS.VENDOR_SITE_ID
TableJAI_CMN_RG_PLA_HDRS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_PLA_HDRS.VENDOR_SITE_ID
TableJAI_CMN_RG_PLA_TRXS FK Joins to HZ_PARTY_SITES JAI_CMN_RG_PLA_TRXS.VENDOR_SITE_ID
TableJAI_CMN_STFORM_HDRS_ALL FK Joins to HZ_PARTY_SITES JAI_CMN_STFORM_HDRS_ALL.PARTY_SITE_ID
TableJAI_CMN_TAXES_ALL FK Joins to HZ_PARTY_SITES JAI_CMN_TAXES_ALL.VENDOR_SITE_ID
TableJAI_CMN_VENDOR_SITES FK Joins to HZ_PARTY_SITES JAI_CMN_VENDOR_SITES.VENDOR_SITE_ID
TableJAI_FBT_SETTLEMENT FK Joins to HZ_PARTY_SITES JAI_FBT_SETTLEMENT.INV_SUPPLIER_SITE_ID
TableJAI_PO_OSP_HDRS FK Joins to HZ_PARTY_SITES JAI_PO_OSP_HDRS.VENDOR_SITE_ID
TableJAI_PO_REP_PRRG_T FK Joins to HZ_PARTY_SITES JAI_PO_REP_PRRG_T.VENDOR_SITE_ID
TableJAI_RCV_CENVAT_CLAIMS FK Joins to HZ_PARTY_SITES JAI_RCV_CENVAT_CLAIMS.VENDOR_SITE_ID
TableJAI_RCV_HEADERS FK Joins to HZ_PARTY_SITES JAI_RCV_HEADERS.VENDOR_SITE_ID
TableJAI_RCV_HEADERS FK Joins to HZ_PARTY_SITES JAI_RCV_HEADERS.CUSTOMER_SITE_ID
TableJAI_RCV_LINE_TAXES FK Joins to HZ_PARTY_SITES JAI_RCV_LINE_TAXES.VENDOR_SITE_ID
TableJAI_RCV_RGM_LINES FK Joins to HZ_PARTY_SITES JAI_RCV_RGM_LINES.VENDOR_SITE_ID
TableJAI_RCV_RTV_BATCH_GRPS FK Joins to HZ_PARTY_SITES JAI_RCV_RTV_BATCH_GRPS.VENDOR_SITE_ID
TableJAI_RCV_TP_INVOICES FK Joins to HZ_PARTY_SITES JAI_RCV_TP_INVOICES.VENDOR_SITE_ID
TableJAI_RGM_CERTIFICATES FK Joins to HZ_PARTY_SITES JAI_RGM_CERTIFICATES.PARTY_SITE_ID
TableJAI_RGM_INVOICE_GEN_T FK Joins to HZ_PARTY_SITES JAI_RGM_INVOICE_GEN_T.PARTY_SITE_ID
TableJAI_RGM_MANUAL_TRXS FK Joins to HZ_PARTY_SITES JAI_RGM_MANUAL_TRXS.PARTY_SITE_ID
TableJAI_RGM_PARTIES FK Joins to HZ_PARTY_SITES JAI_RGM_PARTIES.AUTHORITY_SITE_ID
TableJAI_RGM_REFS_ALL FK Joins to HZ_PARTY_SITES JAI_RGM_REFS_ALL.PARTY_SITE_ID
TableJAI_RGM_SETTLEMENTS FK Joins to HZ_PARTY_SITES JAI_RGM_SETTLEMENTS.TAX_AUTHORITY_SITE_ID
TableJAI_RGM_TRX_REFS FK Joins to HZ_PARTY_SITES JAI_RGM_TRX_REFS.PARTY_SITE_ID
TableJTF_RS_RESOURCE_EXTNS FK Joins to HZ_PARTY_SITES JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID
TableJTF_RS_RESOURCE_EXTN_AUD FK Joins to HZ_PARTY_SITES JTF_RS_RESOURCE_EXTN_AUD.OLD_SUPPORT_SITE_ID
TableJTF_RS_RESOURCE_EXTN_AUD FK Joins to HZ_PARTY_SITES JTF_RS_RESOURCE_EXTN_AUD.NEW_SUPPORT_SITE_ID
TableJTF_TASKS_B FK Joins to HZ_PARTY_SITES JTF_TASKS_B.ADDRESS_ID
TableJTF_TASK_AUDITS_B FK Joins to HZ_PARTY_SITES JTF_TASK_AUDITS_B.OLD_ADDRESS_ID
TableJTF_TASK_AUDITS_B FK Joins to HZ_PARTY_SITES JTF_TASK_AUDITS_B.NEW_ADDRESS_ID
TableJTF_TASKS_B FK Joins to HZ_PARTY_SITES JTF_TASKS_B.ADDRESS_ID
TableMTL_CLIENT_PARAMETERS FK Joins to HZ_PARTY_SITES MTL_CLIENT_PARAMETERS.TRADING_PARTNER_SITE_ID
TableOE_HEADERS_IFACE_ALL FK Joins to HZ_PARTY_SITES OE_HEADERS_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_PARTY_SITES OE_LINES_IFACE_ALL.DELIVER_TO_PARTY_SITE_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_PARTY_SITES OE_LINES_IFACE_ALL.END_CUSTOMER_PARTY_SITE_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_PARTY_SITES OE_LINES_IFACE_ALL.INVOICE_TO_PARTY_SITE_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_PARTY_SITES OE_LINES_IFACE_ALL.SHIP_TO_PARTY_SITE_ID
TableOKL_INS_POLICIES_ALL_B FK Joins to HZ_PARTY_SITES OKL_INS_POLICIES_ALL_B.AGENCY_SITE_ID
TableOKL_INS_POLICIES_ALL_B FK Joins to HZ_PARTY_SITES OKL_INS_POLICIES_ALL_B.AGENT_SITE_ID
TableOKL_INS_POLICIES_B FK Joins to HZ_PARTY_SITES OKL_INS_POLICIES_B.AGENCY_SITE_ID
TableOKL_INS_POLICIES_B FK Joins to HZ_PARTY_SITES OKL_INS_POLICIES_B.AGENT_SITE_ID
TableOKL_TAX_SOURCES FK Joins to HZ_PARTY_SITES OKL_TAX_SOURCES.SHIP_TO_PARTY_SITE_ID
TableOKL_TAX_SOURCES FK Joins to HZ_PARTY_SITES OKL_TAX_SOURCES.BILL_TO_PARTY_SITE_ID
TableOKL_TAX_SOURCES_T FK Joins to HZ_PARTY_SITES OKL_TAX_SOURCES_T.SHIP_TO_PARTY_SITE_ID
TableOKL_TAX_SOURCES_T FK Joins to HZ_PARTY_SITES OKL_TAX_SOURCES_T.BILL_TO_PARTY_SITE_ID
TablePA_PROJECT_REQUESTS FK Joins to HZ_PARTY_SITES PA_PROJECT_REQUESTS.CUST_PARTY_SITE_ID
TablePOS_ACCT_ADDR_REL FK Joins to HZ_PARTY_SITES POS_ACCT_ADDR_REL.ADDRESS_ID
TablePOS_ACNT_ADDR_REQ FK Joins to HZ_PARTY_SITES POS_ACNT_ADDR_REQ.PARTY_SITE_ID
TablePOS_ACNT_PAY_PREF FK Joins to HZ_PARTY_SITES POS_ACNT_PAY_PREF.PARTY_SITE_ID
TablePOS_ADDRESS_NOTES FK Joins to HZ_PARTY_SITES POS_ADDRESS_NOTES.PARTY_SITE_ID
TablePOS_ADDRESS_REQUESTS FK Joins to HZ_PARTY_SITES POS_ADDRESS_REQUESTS.PARTY_SITE_ID
TablePOS_CONT_ADDR_REQUESTS FK Joins to HZ_PARTY_SITES POS_CONT_ADDR_REQUESTS.PARTY_SITE_ID
TableZX_PARTY_TAX_PROFILE FK Joins to HZ_PARTY_SITES ZX_PARTY_TAX_PROFILE.PARTY_ID