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_CUST_ACCT_SITES_ALL

Product:	AR - Receivables
Description:	Stores all customer account sites across all operating units
Implementation/DBA Data:	AR.HZ_CUST_ACCT_SITES_ALL

Primary Key: HZ_CUST_ACCT_SITES_PK

CUST_ACCT_SITE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
HZ_CUST_ACCT_SITES_ALL	HZ_CUST_ACCOUNTS	HZ_CUST_ACCT_SITES_ALL.CUST_ACCOUNT_ID
HZ_CUST_ACCT_SITES_ALL	HZ_PARTY_SITES	HZ_CUST_ACCT_SITES_ALL.PARTY_SITE_ID
HZ_CUST_ACCT_SITES_ALL	RA_TERRITORIES	HZ_CUST_ACCT_SITES_ALL.TERRITORY_ID
AR_CMGT_CREDIT_REQUESTS	HZ_CUST_ACCT_SITES_ALL	AR_CMGT_CREDIT_REQUESTS.CUST_ACCT_SITE_ID
AR_CORRESPONDENCES_ALL	HZ_CUST_ACCT_SITES_ALL	AR_CORRESPONDENCES_ALL.REMIT_TO_ADDRESS_ID
AR_STATEMENTS_HISTORY_ALL	HZ_CUST_ACCT_SITES_ALL	AR_STATEMENTS_HISTORY_ALL.SEND_TO_ADDRESS_ID
AR_STATEMENT_HEADERS	HZ_CUST_ACCT_SITES_ALL	AR_STATEMENT_HEADERS.SEND_TO_ADDRESS_ID
AR_TAX_EXTRACT_SUB_ITF	HZ_CUST_ACCT_SITES_ALL	AR_TAX_EXTRACT_SUB_ITF.SHIPPING_TP_ADDRESS_ID
AR_TAX_EXTRACT_SUB_ITF	HZ_CUST_ACCT_SITES_ALL	AR_TAX_EXTRACT_SUB_ITF.BILLING_TP_ADDRESS_ID
CS_CP_AUDIT	HZ_CUST_ACCT_SITES_ALL	CS_CP_AUDIT.CURRENT_BILL_TO_SITE_USE_ID
CS_CP_AUDIT	HZ_CUST_ACCT_SITES_ALL	CS_CP_AUDIT.OLD_BILL_TO_SITE_USE_ID
CS_CUSTOMER_PRODUCTS_ALL	HZ_CUST_ACCT_SITES_ALL	CS_CUSTOMER_PRODUCTS_ALL.BILL_TO_SITE_USE_ID
CS_SYSTEMS_ALL_B	HZ_CUST_ACCT_SITES_ALL	CS_SYSTEMS_ALL_B.BILL_TO_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_CUST_ACCT_SITES_ALL	CS_SYSTEM_AUDIT.OLD_BILL_TO_SITE_USE_ID
CS_SYSTEM_AUDIT	HZ_CUST_ACCT_SITES_ALL	CS_SYSTEM_AUDIT.CURR_BILL_TO_SITE_USE_ID
HZ_CUST_ACCOUNT_ROLES	HZ_CUST_ACCT_SITES_ALL	HZ_CUST_ACCOUNT_ROLES.CUST_ACCT_SITE_ID
HZ_CUST_CONTACT_POINTS	HZ_CUST_ACCT_SITES_ALL	HZ_CUST_CONTACT_POINTS.CUST_ACCOUNT_SITE_ID
%	HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL	HZ_CUST_ACCT_SITES_ALL	HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID
JL_ZZ_AR_TX_CUS_CLS_ALL	HZ_CUST_ACCT_SITES_ALL	JL_ZZ_AR_TX_CUS_CLS_ALL.ADDRESS_ID
JL_ZZ_AR_TX_EXC_CUS_ALL	HZ_CUST_ACCT_SITES_ALL	JL_ZZ_AR_TX_EXC_CUS_ALL.ADDRESS_ID
LNS_LOAN_HEADERS_ALL	HZ_CUST_ACCT_SITES_ALL	LNS_LOAN_HEADERS_ALL.BILL_TO_ACCT_SITE_ID
LNS_PARTICIPANTS	HZ_CUST_ACCT_SITES_ALL	LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID
OE_HEADERS_IFACE_ALL	HZ_CUST_ACCT_SITES_ALL	OE_HEADERS_IFACE_ALL.SHIP_TO_CUSTOMER_ID
OE_HEADER_ACKS	HZ_CUST_ACCT_SITES_ALL	OE_HEADER_ACKS.SHIP_TO_ADDRESS_ID
OE_HEADER_ACKS	HZ_CUST_ACCT_SITES_ALL	OE_HEADER_ACKS.SOLD_TO_ADDRESS_ID
OE_HEADER_ACKS	HZ_CUST_ACCT_SITES_ALL	OE_HEADER_ACKS.INVOICE_ADDRESS_ID
OE_LINE_ACKS	HZ_CUST_ACCT_SITES_ALL	OE_LINE_ACKS.SHIP_TO_ADDRESS_ID
OZF_CUST_PROD_CONT_ALL	HZ_CUST_ACCT_SITES_ALL	OZF_CUST_PROD_CONT_ALL.CUST_ACCT_SITE_ID
OZF_CUST_TRD_PRFLS_ALL	HZ_CUST_ACCT_SITES_ALL	OZF_CUST_TRD_PRFLS_ALL.CUST_ACCT_SITE_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS	HZ_CUST_ACCT_SITES_ALL	PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	HZ_CUST_ACCT_SITES_ALL	PA_PROJECT_CUSTOMERS.BILL_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	HZ_CUST_ACCT_SITES_ALL	PA_PROJECT_CUSTOMERS.SHIP_TO_ADDRESS_ID
PA_TASKS	HZ_CUST_ACCT_SITES_ALL	PA_TASKS.ADDRESS_ID
IGS_FI_P_CUST_ACCT	HZ_CUST_ACCT_SITES_ALL	IGS_FI_P_CUST_ACCT.CUST_ACCT_SITE_ID
RA_CUSTOMER_MERGES	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_MERGES.CUSTOMER_ADDRESS_ID
RA_CUSTOMER_MERGES	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_MERGES.DUPLICATE_ADDRESS_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_TRX_ALL.BILL_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_TRX_ALL.SHIP_TO_ADDRESS_ID
RA_CUSTOMER_TRX_LINES_ALL	HZ_CUST_ACCT_SITES_ALL	RA_CUSTOMER_TRX_LINES_ALL.SHIP_TO_ADDRESS_ID
RA_INTERFACE_LINES_ALL	HZ_CUST_ACCT_SITES_ALL	RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_BILL_ADDRESS_ID
RA_INTERFACE_LINES_ALL	HZ_CUST_ACCT_SITES_ALL	RA_INTERFACE_LINES_ALL.ORIG_SYSTEM_SHIP_ADDRESS_ID
RA_REMIT_TOS_ALL	HZ_CUST_ACCT_SITES_ALL	RA_REMIT_TOS_ALL.ADDRESS_ID
RA_REMIT_TOS_ALL	HZ_CUST_ACCT_SITES_ALL	RA_REMIT_TOS_ALL.ADDRESS_ID
ZX_LINES_DET_FACTORS	HZ_CUST_ACCT_SITES_ALL	ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID
ZX_LINES_DET_FACTORS	HZ_CUST_ACCT_SITES_ALL	ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID