Request for Logic Used in msc_get_name.demand_order_number_new and supply_order_number_new API
Summary:
please share the SQL query utilized in the API referenced below? We have a requirement to understand the logic implemented within this API, as we need to replicate the same logic and develop an equivalent SQL query using standard Oracle tables.
API:
msc_get_name.demand_order_number_new
msc_get_name.supply_order_number_new
Your assistance in providing this information would be greatly appreciated.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):