I need a query to pull some information for Purchase Order and work order if any associated with it. I know how to pull the PO order and related PO information but not sure how to connect with work orders which are in EAM. Is it possible?
EAM will create a requisition in reference to the work order, subsequently the requisition will be converted to PO.
You may join the work order tables with requisition lines table through WIP_ENTITY_ID and WIP_LINE_ID columns and then join the requisition distribution table and PO distribution table through requisition distribution id to establish the full cycle.