• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to find customer number, site number, party number from invoice

by admin

In this post we will see the difference between the below terminologies:

1. Customer Account Number
2. Location Number (located under Business Purposes tab of the customer site in the Site Details section)
3. Site Number
4. Registry ID

1. Customer Account Number

A party can have multiple customer accounts, and each of those customer accounts should have a customer number. So Customer Account Number is the customer number. Every time you enter a customer account, a row is inserted into the hz_cust_accounts table.

2. Location Number

Location Number is the number assigned to the site business usage (i.e. bill-to, ship-to, etc…). Therefore, you’ll see Location Number under Business Purposes tab of the customer site in the Site Details section. Location Number is stored in hz_cust_site_uses_all table.

3. Site Number

Site Number is the number assigned to a customer address. Therefore, you’ll see the site number in the Address section. Site Number is stored in HZ_PARTY_SITES table.

4. Registry ID

Registry ID is the party (organization) number. Every time you enter a party, a row is inserted into hz_parties table. In 11i Customers Standard form, you see Organization Number and Customer Number. Organization Number is the party number and Customer Number is the Customer Account Number.

To find customer number, site number, party number from invoice:

select rcta.trx_number,
cust_acct.account_number customer_number,
party_site.party_site_number site_number,
hp.party_number
FROM ra_customer_trx_all rcta,
hz_cust_accounts cust_acct,
hz_party_sites party_site,
hz_cust_acct_sites_all acct_site,
hz_cust_site_uses_all site_uses,
hz_parties hp
where  rcta.bill_to_customer_id = cust_acct.cust_account_id
AND rcta.bill_to_customer_id = acct_site.cust_account_id
AND rcta.bill_to_site_use_id = site_uses.site_use_id
AND cust_acct.cust_account_id = acct_site.cust_account_id
AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
AND site_uses.site_use_code = 'BILL_TO'
AND party_site.party_site_id = acct_site.party_site_id
AND hp.party_id = cust_acct.party_id
AND hp.party_id = party_site.party_id
and rcta.trx_number='11111111'

Filed Under: Oracle Apps

Some more articles you might also be interested in …

  1. PeopleSoft “Authorization Error – Contact your security administrator “
  2. How To Download Single Context Using FNDLOAD For Descriptive Flexfield
  3. How to check Oracle Apps/EBS version
  4. Difference between Create Accounting – Cost Management and Create Accounting – Receiving
  5. How to reset your forgotten Primavera P6 user password using database query
  6. How to read all modules assigned to user from Primavera P6 EPPM database
  7. FNDLOAD Commands to Download Different Seed Data Types
  8. How to Reset a Primavera P6 Application User Password
  9. FNDLOAD program Examples
  10. Parameters Of Different Configuration Files To Download And Upload Seed Data Types

You May Also Like

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright