Developer implemented the solution below:
1. Paste the following for the LOV Partial SQL:
from ame_approval_groups apg,
(select approval_group_id,
user_approval_group_name,
description
from ame_approval_groups_tl
where language = userenv('LANG')) apgtl,
(select distinct approval_group_id, transaction_type_id
from ame_approval_group_config agc
,ame_calling_apps aca
where agc.application_id = aca.application_id
and sysdate between aca.start_date and nvl(aca.end_date,sysdate)
and sysdate between agc.start_date and nvl(agc.end_date,sysdate)) tmp
where sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate)
and apg.is_static = 'N'
and apg.approval_group_id = apgtl.approval_group_id (+)
and (apg.approval_group_id in
(select approval_group_id
from ame_approval_group_config agc
,ame_calling_apps aca
where agc.application_id = aca.application_id
and sysdate between aca.start_date and nvl(aca.end_date,sysdate)
and sysdate between agc.start_date and nvl(agc.end_date,sysdate)))
2. And add the parameter for TRANSACTION_TYPE_ID as below (see the image attached).
3. Restart the oracle agent and use the same window to do a fetch and Test archive.