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

SQL Query for timecard approval to BPM workflow

Objective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost

Issue : I am unable to find a link between HWM_TM_REC and Workflow tables to get approval details.

Can you please help with the link between OTL and Workflow tables to get Approval Details of Imported Timecards.

Original SQL———————————

select peia.*
from PJC_EXP_ITEMS_ALL PEIA,

HWM_TM_REC REC

WHERE
rec.tm_rec_id = PEIA.original_line_number
AND PEIA.transaction_source_id in
(SELECT TRANSACTION_SOURCE_ID
FROM fusion.PJF_TXN_SOURCES_TL
WHERE user_transaction_source = 'Oracle Fusion Time and Labor')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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