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')
0