Home » Applications » Oracle Fusion Apps & E-Business Suite » Diff between CUST_ACCT_SITE_ID,CUST_ACCOUNT_ID,PARTY_SITE_ID in HZ_CUST_ACCT_SITES_ALL
Diff between CUST_ACCT_SITE_ID,CUST_ACCOUNT_ID,PARTY_SITE_ID in HZ_CUST_ACCT_SITES_ALL [message #174590] Mon, 29 May 2006 23:45 Go to next message
yram
Messages: 75
Registered: February 2001
Member
Hi

Pls do explain me the difference between the following

1. CUST_ACCT_SITE_ID
2. CUST_ACCOUNT_ID
3. PARTY_SITE_ID

in hz_cust_acct_sites_all table.

Regards
Vairamuthu
Re: Diff between CUST_ACCT_SITE_ID,CUST_ACCOUNT_ID,PARTY_SITE_ID in HZ_CUST_ACCT_SITES_ALL [message #174592 is a reply to message #174590] Tue, 30 May 2006 00:19 Go to previous message
sheshukl
Messages: 13
Registered: February 2006
Location: Pune
Junior Member
HZ_CUST_ACCT_SITES_ALL stores information about customer sites.
One customer account can have multiple sites. The address is
maintained in HZ_LOCATIONS.CUST_ACCT_SITE_ID IS THE PRIMARY KEY OF THE TABLE CUST_ACCOUNT_ID IS THE CUSTOMER IDENTIFIER
PARTY_SITE_ID IS THE PARTY SITE IDENTIFIER.
Previous Topic: Oracle 11.0.3 to Oracle 11.5.10.
Next Topic: AZN menus
Goto Forum:
  


Current Time: Sun May 19 04:16:28 CDT 2024