Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
SUM in Table Valueset
Team,
We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful.
SELECT SUM(peevf.screen_entry_value)
FROM pay_element_entries_f peef,
pay_element_types_tl petl,
per_all_people_f papf,
pay_input_values_f pivf,
pay_element_entry_values_f peevf
WHERE 1=1
AND peef.element_type_id = petl.element_type_id
AND papf.person_id=peef.person_id
AND peevf.input_value_id = pivf.input_value_id
AND peevf.element_entry_id = peef.element_entry_id
AND petl.element_name IN ('Sick Leave Ent Result', 'Regular Pay', 'Shift Earnings')
Tagged:
0