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: RA_ADDRESSES_ALL

Product:	AR - Receivables
Description:	Customer address information
Implementation/DBA Data:	AR.RA_ADDRESSES_ALL

Primary Key: RA_ADDRESSES_PK

ADDRESS_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
RA_ADDRESSES_ALL	RA_CUSTOMERS	RA_ADDRESSES_ALL.CUSTOMER_ID
RA_ADDRESSES_ALL	RA_TERRITORIES	RA_ADDRESSES_ALL.TERRITORY_ID
RA_ADDRESSES_ALL	AR_LOCATION_COMBINATIONS	RA_ADDRESSES_ALL.LOCATION_ID
AS_ACCESSES_ALL_ALL	RA_ADDRESSES_ALL	AS_ACCESSES_ALL_ALL.ADDRESS_ID
AS_COLLATERAL_REQ_ALL	RA_ADDRESSES_ALL	AS_COLLATERAL_REQ_ALL.ADDRESS_ID
AS_EVENT_ENROLLMENTS_ALL	RA_ADDRESSES_ALL	AS_EVENT_ENROLLMENTS_ALL.ADDRESS_ID
AS_INTERESTS_ALL	RA_ADDRESSES_ALL	AS_INTERESTS_ALL.ADDRESS_ID
AS_LEADS_ALL	RA_ADDRESSES_ALL	AS_LEADS_ALL.ADDRESS_ID
AS_LIST_ENTRIES	RA_ADDRESSES_ALL	AS_LIST_ENTRIES.ADDRESS_ID
AS_SALESFORCE	RA_ADDRESSES_ALL	AS_SALESFORCE.PARTNER_ADDRESS_ID
AS_TERRITORY_VALUES_ALL	RA_ADDRESSES_ALL	AS_TERRITORY_VALUES_ALL.ADDRESS_ID
MTL_CI_INTERFACE	RA_ADDRESSES_ALL	MTL_CI_INTERFACE.ADDRESS_ID
MTL_CI_XREFS_INTERFACE	RA_ADDRESSES_ALL	MTL_CI_XREFS_INTERFACE.ADDRESS_ID
MTL_CUSTOMER_ITEMS	RA_ADDRESSES_ALL	MTL_CUSTOMER_ITEMS.ADDRESS_ID
MTL_INTERCOMPANY_PARAMETERS	RA_ADDRESSES_ALL	MTL_INTERCOMPANY_PARAMETERS.ADDRESS_ID
PA_DRAFT_INVOICES_ALL	RA_ADDRESSES_ALL	PA_DRAFT_INVOICES_ALL.BILL_TO_ADDRESS_ID
PA_DRAFT_INVOICES_ALL	RA_ADDRESSES_ALL	PA_DRAFT_INVOICES_ALL.SHIP_TO_ADDRESS_ID
PA_DRAFT_INVOICE_ITEMS	RA_ADDRESSES_ALL	PA_DRAFT_INVOICE_ITEMS.SHIP_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	RA_ADDRESSES_ALL	PA_PROJECT_CUSTOMERS.BILL_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	RA_ADDRESSES_ALL	PA_PROJECT_CUSTOMERS.SHIP_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	RA_ADDRESSES_ALL	PA_PROJECT_CUSTOMERS.BILL_TO_ADDRESS_ID
PA_PROJECT_CUSTOMERS	RA_ADDRESSES_ALL	PA_PROJECT_CUSTOMERS.SHIP_TO_ADDRESS_ID
PA_TASKS	RA_ADDRESSES_ALL	PA_TASKS.ADDRESS_ID
PO_LOCATION_ASSOCIATIONS	RA_ADDRESSES_ALL	PO_LOCATION_ASSOCIATIONS.ADDRESS_ID
%	RA_ADDRESSES_ALL
%	RA_ADDRESSES_ALL
RA_CUSTOMER_TRX_ALL	RA_ADDRESSES_ALL	RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_PHONES	RA_ADDRESSES_ALL	RA_PHONES.ADDRESS_ID
RA_SITE_USES_ALL	RA_ADDRESSES_ALL	RA_SITE_USES_ALL.ADDRESS_ID
SO_HEADERS_INTERFACE_ALL	RA_ADDRESSES_ALL	SO_HEADERS_INTERFACE_ALL.SHIP_ADDRESS_ID
SO_HEADERS_INTERFACE_ALL	RA_ADDRESSES_ALL	SO_HEADERS_INTERFACE_ALL.INVOICE_ADDRESS_ID