This content has been marked as final. Show 3 replies
Hi,1 person found this helpful
PO_ACTION_HISTORY contains history for both requisitions and standard POs. If you want to show POs history, just restrict by object_type_code = 'PO' and link object_id with po_headers_all.po_header_id. If you want to show requisition history, restrict by object_type_code = 'REQUISITION' and link object_id with po_requisition_headers_all.requisition_header_id.
Hope it helps.
i needed to display both action history of po and pr simultaneously in a single report not just one.
i got it done ! phew!!
thanks for the repsonse
Came across your thread and I am also looking bring the both histories on the same table, do you still have the information on how you achieved this?