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 MARCH 04, 2022
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 ?
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