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
|