How do we get the assignee details/pending approver details for ERP Transactions?
Summary:
How do we get the assignee details/pending approver details for ERP Transactions?
Content (required):
Hi Team,
How do we get the assignee details/pending approver details for ERP Transactions?
Below query works for HCM transactions but not for ERP ones-
SELECT
(select distinct papf.person_number from per_all_people_f papf where 1=1
and papf.person_id = hth.subject_id) person_number,
htce.console_txn_status,
htce.transaction_id,
wft.assignees
FROM hrc_txn_header hth,
hrc_txn_console_entry htce,
fa_fusion_soainfra.wftask wft
WHERE 1=1
and htce.console_txn_status not in ('ORA_HRC_TXN_DRAFT','ORA_HRC_TXN_COMPLETED')
2