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 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.

Goal

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

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

Solution

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
Goal
Solution


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