FND Design Data [Home] [Help]

Table: HZ_CUST_SITE_USES_ALL

Product: AR - Receivables
Description: Stores business purposes assigned to customer account sites.
Implementation/DBA Data: TableAR.HZ_CUST_SITE_USES_ALL
Primary Key: HZ_CUST_SITE_USES_ALL_PK
  1. ColumnSITE_USE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HZ_CUST_SITE_USES_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID
HZ_CUST_SITE_USES_ALL FK Joins to TableRA_TERRITORIES HZ_CUST_SITE_USES_ALL.TERRITORY_ID
HZ_CUST_SITE_USES_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES HZ_CUST_SITE_USES_ALL.CONTACT_ID
TableAP_BANK_ACCOUNT_USES_ALL FK Joins to HZ_CUST_SITE_USES_ALL AP_BANK_ACCOUNT_USES_ALL.CUSTOMER_SITE_USE_ID
TableAR_AUTOREC_EXCEPTIONS FK Joins to HZ_CUST_SITE_USES_ALL AR_AUTOREC_EXCEPTIONS.PAYING_SITE_USE_ID
TableAR_BR_TRX_BATCH_RPT FK Joins to HZ_CUST_SITE_USES_ALL AR_BR_TRX_BATCH_RPT.DRAWEE_SITE_USE_ID
TableAR_CASH_RECEIPTS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
TableAR_CASH_RECEIPTS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CASH_RECEIPTS_ALL.PREV_CUSTOMER_SITE_USE_ID
TableAR_CMGT_CASE_FOLDERS FK Joins to HZ_CUST_SITE_USES_ALL AR_CMGT_CASE_FOLDERS.SITE_USE_ID
TableAR_CMGT_CREDIT_REQUESTS FK Joins to HZ_CUST_SITE_USES_ALL AR_CMGT_CREDIT_REQUESTS.SITE_USE_ID
TableAR_CONS_INV_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CONS_INV_ALL.SITE_USE_ID
TableAR_CORRESPONDENCES_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CORRESPONDENCES_ALL.SITE_USE_ID
TableAR_CORRESPONDENCES_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CORRESPONDENCES_ALL.SITE_USE_ID
TableAR_CREDIT_HISTORIES FK Joins to HZ_CUST_SITE_USES_ALL AR_CREDIT_HISTORIES.SITE_USE_ID
TableAR_CREDIT_HISTORIES FK Joins to HZ_CUST_SITE_USES_ALL AR_CREDIT_HISTORIES.SITE_USE_ID
TableAR_CUSTOMER_ALT_NAMES FK Joins to HZ_CUST_SITE_USES_ALL AR_CUSTOMER_ALT_NAMES.SITE_USE_ID
TableAR_CUSTOMER_CALLS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CUSTOMER_CALLS_ALL.SITE_USE_ID
TableAR_CUSTOMER_CALL_TOPICS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_CUSTOMER_CALL_TOPICS_ALL.SITE_USE_ID
TableAR_DISTRIBUTIONS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_DISTRIBUTIONS_ALL.THIRD_PARTY_SUB_ID
TableAR_INTERIM_CASH_RECEIPTS_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID
TableAR_PAYMENTS_INTERFACE_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_PAYMENTS_INTERFACE_ALL.CUSTOMER_SITE_USE_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID
TableAR_RAMC_AUDIT_TRAIL FK Joins to HZ_CUST_SITE_USES_ALL AR_RAMC_AUDIT_TRAIL.BILL_TO_SITE_USE_ID
TableAR_SELECTION_CRITERIA FK Joins to HZ_CUST_SITE_USES_ALL AR_SELECTION_CRITERIA.SITE_USE_ID
TableAR_STATEMENTS_HISTORY_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_STATEMENTS_HISTORY_ALL.SITE_USE_ID
TableAR_STATEMENT_HEADERS FK Joins to HZ_CUST_SITE_USES_ALL AR_STATEMENT_HEADERS.SITE_USE_ID
TableAR_STATEMENT_LINE_CLUSTERS FK Joins to HZ_CUST_SITE_USES_ALL AR_STATEMENT_LINE_CLUSTERS.SITE_USE_ID
TableAR_TA_CR_AGEN_INF_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_CR_AGEN_INF_ALL.CUSTOMER_SITE_USE_ID
TableAR_TA_CUST_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_CUST_INT_ALL.SITE_USE_ID
TableAR_TA_DEDN_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_DEDN_INT_ALL.CUSTOMER_SITE_USE_ID
TableAR_TA_DEDN_RELATE_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_DEDN_RELATE_ALL.CUSTOMER_SITE_USE_ID
TableAR_TA_PAYMNT_HIST_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_PAYMNT_HIST_ALL.BILL_TO_SITE_USE_ID
TableAR_TA_PROM_CUST_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_PROM_CUST_ALL.SITE_USE_ID
TableAR_TA_PROM_CUST_MAP FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_PROM_CUST_MAP.SITE_USE_ID
TableAR_TA_RISK_COMENT_ALL FK Joins to HZ_CUST_SITE_USES_ALL AR_TA_RISK_COMENT_ALL.CUSTOMER_SITE_USE_ID
TableAR_TRANSACTIONS_REP_ITF FK Joins to HZ_CUST_SITE_USES_ALL AR_TRANSACTIONS_REP_ITF.SHIP_TO_SITE_USE_ID
TableAR_TRANSACTIONS_REP_ITF FK Joins to HZ_CUST_SITE_USES_ALL AR_TRANSACTIONS_REP_ITF.BILL_TO_SITE_USE_ID
TableAR_TRX_BAL_SUMMARY FK Joins to HZ_CUST_SITE_USES_ALL AR_TRX_BAL_SUMMARY.SITE_USE_ID
TableAR_TRX_SUMMARY FK Joins to HZ_CUST_SITE_USES_ALL AR_TRX_SUMMARY.SITE_USE_ID
TableAR_TRX_SUMMARY_HIST FK Joins to HZ_CUST_SITE_USES_ALL AR_TRX_SUMMARY_HIST.SITE_USE_ID
TableCSI_IP_ACCOUNTS FK Joins to HZ_CUST_SITE_USES_ALL CSI_IP_ACCOUNTS.BILL_TO_ADDRESS
TableCSI_IP_ACCOUNTS FK Joins to HZ_CUST_SITE_USES_ALL CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS
TableCSI_SYSTEMS_B FK Joins to HZ_CUST_SITE_USES_ALL CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID
TableCSI_SYSTEMS_B FK Joins to HZ_CUST_SITE_USES_ALL CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID
TableCSI_T_TXN_SYSTEMS FK Joins to HZ_CUST_SITE_USES_ALL CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID
TableCSI_T_TXN_SYSTEMS FK Joins to HZ_CUST_SITE_USES_ALL CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_CUST_SITE_USES_ALL CS_INCIDENTS_ALL_B.SHIP_TO_SITE_USE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_CUST_SITE_USES_ALL CS_INCIDENTS_ALL_B.INSTALL_SITE_USE_ID
TableCS_INCIDENTS_ALL_B FK Joins to HZ_CUST_SITE_USES_ALL CS_INCIDENTS_ALL_B.BILL_TO_SITE_USE_ID
TableHZ_BILLING_PREFERENCES FK Joins to HZ_CUST_SITE_USES_ALL HZ_BILLING_PREFERENCES.SITE_USE_ID
TableHZ_CUSTOMER_PROFILES FK Joins to HZ_CUST_SITE_USES_ALL HZ_CUSTOMER_PROFILES.SITE_USE_ID
TableHZ_CUST_PROFILE_AMTS FK Joins to HZ_CUST_SITE_USES_ALL HZ_CUST_PROFILE_AMTS.SITE_USE_ID
TablePN_SPACE_ASSIGN_CUST_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID
TablePN_PAYMENT_ITEMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
TablePN_PAYMENT_TERMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
TableHZ_SUSPENSION_ACTIVITY FK Joins to HZ_CUST_SITE_USES_ALL HZ_SUSPENSION_ACTIVITY.SITE_USE_ID
TableIBY_EXTERNAL_PAYERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID
TableJAI_AR_TDS_CERTIFICATES FK Joins to HZ_CUST_SITE_USES_ALL JAI_AR_TDS_CERTIFICATES.SITE_USE_ID
TableJAI_AR_TRX_INS_HDRS_T FK Joins to HZ_CUST_SITE_USES_ALL JAI_AR_TRX_INS_HDRS_T.BILL_TO_SITE_USE_ID
TableJAI_AR_TRX_INS_HDRS_T FK Joins to HZ_CUST_SITE_USES_ALL JAI_AR_TRX_INS_HDRS_T.SHIP_TO_SITE_USE_ID
TableJAI_OM_OE_GEN_TAXINV_T FK Joins to HZ_CUST_SITE_USES_ALL JAI_OM_OE_GEN_TAXINV_T.SHIP_TO_SITE_USE_ID
TableJL_BR_AR_OCCURRENCE_DOCS_ALL FK Joins to HZ_CUST_SITE_USES_ALL JL_BR_AR_OCCURRENCE_DOCS_ALL.SITE_USE_ID
TableJL_BR_AR_PAY_SCHED_AUX FK Joins to HZ_CUST_SITE_USES_ALL JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_SITE_USE_ID
TableOE_BLANKET_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_BLANKET_HEADERS_ALL.SOLD_TO_SITE_USE_ID
TableOE_BLANKET_HEADERS_HIST FK Joins to HZ_CUST_SITE_USES_ALL OE_BLANKET_HEADERS_HIST.SOLD_TO_SITE_USE_ID
TableOE_HEADERS_IFACE_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_HEADERS_IFACE_ALL.SOLD_TO_SITE_USE_ID
TableOE_HEADERS_IFACE_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_HEADERS_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
TableOE_HEADER_ACKS FK Joins to HZ_CUST_SITE_USES_ALL OE_HEADER_ACKS.END_CUSTOMER_SITE_USE_ID
TableOE_HEADER_ACKS FK Joins to HZ_CUST_SITE_USES_ALL OE_HEADER_ACKS.SOLD_TO_SITE_USE_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_LINES_IFACE_ALL.END_CUSTOMER_SITE_USE_ID
TableOE_LINE_ACKS FK Joins to HZ_CUST_SITE_USES_ALL OE_LINE_ACKS.END_CUSTOMER_SITE_USE_ID
TableOE_ORDER_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_ORDER_HEADERS_ALL.END_CUSTOMER_SITE_USE_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_SITE_USES_ALL OE_ORDER_HEADER_HISTORY.SOLD_TO_SITE_USE_ID
TableOE_ORDER_HEADER_HISTORY FK Joins to HZ_CUST_SITE_USES_ALL OE_ORDER_HEADER_HISTORY.END_CUSTOMER_SITE_USE_ID
TableOE_ORDER_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL OE_ORDER_LINES_ALL.END_CUSTOMER_SITE_USE_ID
TableOE_ORDER_LINES_HISTORY FK Joins to HZ_CUST_SITE_USES_ALL OE_ORDER_LINES_HISTORY.END_CUSTOMER_SITE_USE_ID
TableOKL_TAX_SOURCES FK Joins to HZ_CUST_SITE_USES_ALL OKL_TAX_SOURCES.BILL_TO_CUST_ACCT_SITE_USE_ID
TableOKL_TAX_SOURCES FK Joins to HZ_CUST_SITE_USES_ALL OKL_TAX_SOURCES.SHIP_TO_CUST_ACCT_SITE_USE_ID
TableOKL_TAX_SOURCES_T FK Joins to HZ_CUST_SITE_USES_ALL OKL_TAX_SOURCES_T.BILL_TO_CUST_ACCT_SITE_USE_ID
TableOKL_TAX_SOURCES_T FK Joins to HZ_CUST_SITE_USES_ALL OKL_TAX_SOURCES_T.SHIP_TO_CUST_ACCT_SITE_USE_ID
TableOKL_TRX_EXTENSION_B FK Joins to HZ_CUST_SITE_USES_ALL OKL_TRX_EXTENSION_B.CUST_SITE_USE_ID
TableOZF_CHARGEBACK_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_HEADERS_ALL.BILL_TO_SITE_USE_ID
TableOZF_CHARGEBACK_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_HEADERS_ALL.SHIP_TO_SITE_USE_ID
TableOZF_CHARGEBACK_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_INT_ALL.BILL_TO_SITE_USE_ID
TableOZF_CHARGEBACK_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_INT_ALL.SHIP_TO_SITE_USE_ID
TableOZF_CHARGEBACK_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_LINES_ALL.BILL_TO_SITE_USE_ID
TableOZF_CHARGEBACK_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CHARGEBACK_LINES_ALL.SHIP_TO_SITE_USE_ID
TableOZF_CLAIMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CLAIMS_ALL.CUST_BILLTO_ACCT_SITE_ID
TableOZF_CLAIMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CLAIMS_ALL.CUST_SHIPTO_ACCT_SITE_ID
TableOZF_CLAIMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CLAIMS_ALL.RELATED_SITE_USE_ID
TableOZF_CLAIM_THRESHOLD_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CLAIM_THRESHOLD_ALL.SITE_USE_ID
TableOZF_CUST_TRD_PRFLS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_CUST_TRD_PRFLS_ALL.SITE_USE_ID
TableOZF_RESALE_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_HEADERS_ALL.BILL_TO_SITE_USE_ID
TableOZF_RESALE_HEADERS_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_HEADERS_ALL.SHIP_TO_SITE_USE_ID
TableOZF_RESALE_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_LINES_ALL.BILL_TO_SITE_USE_ID
TableOZF_RESALE_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_LINES_ALL.SHIP_TO_SITE_USE_ID
TableOZF_RESALE_LINES_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_LINES_INT_ALL.BILL_TO_SITE_USE_ID
TableOZF_RESALE_LINES_INT_ALL FK Joins to HZ_CUST_SITE_USES_ALL OZF_RESALE_LINES_INT_ALL.SHIP_TO_SITE_USE_ID
TableIGS_FI_P_CUST_ACCT FK Joins to HZ_CUST_SITE_USES_ALL IGS_FI_P_CUST_ACCT.SITE_USE_ID
TablePN_PAYMENT_ITEMS_EFC FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_EFC.CUSTOMER_SITE_USE_ID
TablePN_PAYMENT_ITEMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
TablePN_PAYMENT_ITEMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUST_SHIP_SITE_ID
TablePN_PAYMENT_TERMS_EFC FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_EFC.CUSTOMER_SITE_USE_ID
TablePN_PAYMENT_TERMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
TablePN_PAYMENT_TERMS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUST_SHIP_SITE_ID
TablePN_REC_AGREEMENTS_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_REC_AGREEMENTS_ALL.CUST_SITE_ID
TablePN_SPACE_ASSIGN_CUST_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_SPACE_ASSIGN_CUST_ALL.SITE_USE_ID
TablePN_TENANCIES_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID
TablePN_TENANCIES_HISTORY FK Joins to HZ_CUST_SITE_USES_ALL PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID
TablePN_TERM_TEMPLATES_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_TERM_TEMPLATES_ALL.CUSTOMER_SITE_USE_ID
TablePN_TERM_TEMPLATES_ALL FK Joins to HZ_CUST_SITE_USES_ALL PN_TERM_TEMPLATES_ALL.CUST_SHIP_SITE_ID
TableRA_CUSTOMER_MERGES FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID
TableRA_CUSTOMER_MERGES FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_MERGES.DUPLICATE_SITE_ID
TableRA_CUSTOMER_MERGES FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.SHIP_TO_SITE_USE_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.SOLD_TO_SITE_USE_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_SITE_USE_ID
TableRA_CUST_RECEIPT_METHODS FK Joins to HZ_CUST_SITE_USES_ALL RA_CUST_RECEIPT_METHODS.SITE_USE_ID
TableRA_INTERFACE_LINES_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_INTERFACE_LINES_ALL.PAYING_SITE_USE_ID
TableRA_TAX_EXEMPTIONS_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_TAX_EXEMPTIONS_ALL.SITE_USE_ID
TableRA_TAX_EXEMPTIONS_ALL FK Joins to HZ_CUST_SITE_USES_ALL RA_TAX_EXEMPTIONS_ALL.SITE_USE_ID
TableXDP_ORDER_LINE_ITEMS FK Joins to HZ_CUST_SITE_USES_ALL XDP_ORDER_LINE_ITEMS.SITE_USE_ID
TableZX_LINES_DET_FACTORS FK Joins to HZ_CUST_SITE_USES_ALL ZX_LINES_DET_FACTORS.SHIP_TO_CUST_ACCT_SITE_USE_ID
TableZX_LINES_DET_FACTORS FK Joins to HZ_CUST_SITE_USES_ALL ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID