This content has been marked as final. Show 4 replies
There is a column WF_ITEM_KEY in PO_REQUISITIONS_HEADERS_ALL table. I think you can get the reference to the Requition under approval by querying based on the workflow item key.
Thanks for the reply sumit, but the item_key in requisition headers table is related to requisition approval workflow and the issue of concern here is requisition account generator workflow, the item key that requisition account generator workflow is using is no way related to the requisition, it looks like its a generic sequence number,
Let me know if i am wrong,
we acheived this by customizing POR_CUSTOM_PKG and the account generator package.
Thanks all for your time.
We have exactly the same scenario where in we need to have a link between the account generator workflow attributes and the Requisition Header/Line details. Could you please give us some more information on how did achieved this by customizing the POR_CUSTOM_PKG and the account generator package? Sample code is Much Appreciated.
You can reply to this thread or mail us in firstname.lastname@example.org & email@example.com