Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Need Help In Creating Table Type Value Set
Summary
Need Help In Creating Table Type Value SetContent
Hi Experts,
Wondering whether a Table Type Value Set be created with below base SQL:
select sum(TO_NUMBER(nvl(apecd1.value,0)))
from anc_per_acrl_entry_dtls apecd1,anc_absence_plans_f_tl aapft1,per_all_people_f papf1
where apecd1.pl_id = aapft1.absence_plan_id
and apecd1.person_id = papf1.person_id
and aapft1.language = 'US'
and trunc(sysdate) between aapft1.effective_start_date and aapft1.effective_end_date
and trunc(sysdate) between papf1.effective_start_date and papf1.effective_end_date
and TO_DATE(apecd1.procd_date,'YYYY-MM-DD') > TO_DATE('2020-04-01','YYYY-MM-DD')
Tagged:
1