Product: | AR - Receivables |
---|---|
Description: | Stores all customer account sites across all operating units |
Implementation/DBA Data: | AR.HZ_CUST_ACCT_SITES_ALL |
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_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 |
|
|
|