Community,
We are using APP10. in current Lobby, for shop order planning alert, we can only see very simple data, i.e. data from planning alert window. We would like to build a consolidated data source to display all the info, e.g. project ID, shop order no, component no, quantity short, required date, earliest planning date, especially, what the supply info would be, e.g. purchase requisition, purchase order, status, lead time, and etc…
i think the difficult part is the supply info, there is no one to one pegged order info available (inventory order). in window Inventory Availability Planning this window, usually the supply order(purchase requisition/purchase order) due date would be the same as the shop order component required date.
does anyone has this SQL statement already, mind to share it with me?
Thank you.