I want to write a SQL query to fetch the MRP view demand. I already have the sql query to fetch the demands for an item from the Supply/Demand form but it fetched demands for items which either have a work order or planned order attached to them. If an item does not have an identifier(WO or PO) attached to it, how do i identify the demand for the item?
The MRP view in Oracle workbench does show demands for items which do not have any identifier. How do i catch those demands? Can anyone help me with the SQL for the same?