You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL?

Summary:

What is the key column for joining FND_BPM_TASK_B and PO_HEADERS_ARCHIVE_ALL?

Content (please ensure you mask any confidential information):

Hi Experts,

I found the piece of info from CCC that the PR's Comment History can be retrieved from tables of:
FUSION.FND_BPM_TASK_B T, FUSION.POR_REQUISITION_HEADERS_ALL PRH, FUSION.FND_BPM_TASK_COMMENT TA
The full SQL is:

SELECT DISTINCT PRH.REQUISITION_NUMBER, PRH.DESCRIPTION,PRH.DOCUMENT_STATUS,
TA.COMMENT_BY, TA.COMMENT_TEXT, TA.COMMENT_DATE,
T.STATUS_CODE,T.OUTCOME_CODE, T.INITIATED_BY, T.INITIATED_DATE, T.COMPLETED_BY, T.TASK_NUMBER

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!