Pass comments from Planning to Purchasing
Hi,
We have a requirement to pass additional notes from planned order to purchase requisitions and work orders. So we plan to use comments field from planned order and link it to notes to buyer in purchase requisitions.
I am able to identify the tables for storing the comments and the custom hook in ASCP that would help us in updating post release from planning. But we are stuck now how to identify the purchase requisition record that is inserted into p_requisitions_interface_all. The msc_po_requisitions_interface table does not have any record to store the notes to buyer. So we will have to identify the corresponding record in the table po_requisitions_interface_all to update the notes to buyer field.