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