My Oracle Support Banner

How to Retrieve the List of Active Customer Site Numbers Associated with a Given Operating Unit for a Party Number (Registry ID) using SQL Script ? (Doc ID 2786035.1)

Last updated on AUGUST 16, 2023

Applies to:

Oracle Receivables - Version 12 and later
Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.


How to retrieve the list of active customer site numbers associated with a given operating unit for a Party Number (Registry ID) using SQL Script ?

Business Requirement:

Customer Name: ABCD Customer
Registry ID : 59995
ORG_ID = 204

Responsibility: Receivables Manager
Navigation: Customers > Create/Maintain Customers
1.Query the Registry ID
2.Click on Details icon in Customer Account region
3. Need to get the below shown list of customer site numbers for the above mentioned customer using SQL Script:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.