FA: SCM: OM: SQL Query To Identify Shipment Number And Fulfill Line Number For Split Sales Orders?
(Doc ID 2659731.1)
Last updated on NOVEMBER 29, 2023
Applies to:
Oracle Fusion Order Management Cloud Service - Version 11.13.20.01.0 and laterInformation in this document applies to any platform.
Goal
How to Identify the Sales Order, Line Number, Fulfill Line Number and Shipment Number for split sales orders through query?
For e.g. Sales Order #SO1 with one Single Line 1 - Quantity 100. And It was split into 4 lines and 3 shipments created for 3 lines (1.1, 1.2 and 1.3) and fourth lines back ordered.
In this scenario, all 3 shipments have same source number 1. So, how to identify which shipment is for which line number?
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 |