If the use case is to take the NRDM and load it back the ORDERITEM table, you cannot just say "From" the children, you have to take the entire structure and unnest it. In fact, that is not really a limitation, we need the parent SALES_ORDER_NUMBER information anyway.
