Get Started with Redwood for Oracle Cloud HCM Begin Now
SQL Join of HCM and UDT tables together
Summary
SQL Join of HCM and UDT tables togetherContent
Hello:
How can i create a SQL join of HCM and UDT tables together in a BIP report?
Can i and do i have to use this package statement?
select FF_USER_TABLES_PKG.GET_TABLE_VALUE_ENT(1, SYSDATE, 'XXHR_UDT', 'COLUMN1', ROW_VALUE) from dual
I need to join 'Person Number to retrieve 'Legal Employer/lCompany' where both Employee and Company are UDT column values.
For instance to join
SELECT *
FROM UDT u,
PER_ALL_PEOPLE_F papf
WHERE papf.person_id = UDT.Row_Value ? - OR- WHERE papf.person_id = UDT.'Column Name'?
Tagged:
0