How to do sorting and conversion in Oracle?
I have a business requirement where 1 container wil come with about 40 boxes. Each box can have 10/12 subassembly. Each subassembly may contain only 2 components/ 3 components. We need to receive Part A , but store it as Part B and Part C. How to achieve this in Oracle? As we are not actually doing any manufacturing , do not want to go through the WIP job process. Please advice.