⬡
Fusion Query Tool
Features
Pricing
FAQ
TR
⬇ Download
Sign In
⚡ v1.0.3 — Now Available
The SQL Client
Oracle Fusion Developers
Deserve
|
⬇ Download Free Trial
Explore Features →
0
Installation steps
1-Click
Query results
100%
On-premise secure
sql_worksheet.sql — Fusion Query Tool Pro
1
-- Oracle Fusion HCM Query
2
SELECT
3
ppnf.
FULL_NAME
,
4
per.
EMPLOYEE_NUMBER
,
5
asg.
ASSIGNMENT_STATUS_TYPE
6
FROM
7
PER_PERSON_NAMES_F
ppnf
8
JOIN
PER_ALL_PEOPLE_F
per
9
ON
ppnf.PERSON_ID = per.PERSON_ID
10
WHERE
ROWNUM <=
100
FULL_NAME
EMPLOYEE_NUMBER
STATUS
Ahmed Al-Rashid
EMP-00142
ACTIVE
Sarah Connor
EMP-00143
ACTIVE
John Doe
EMP-00144
INACTIVE
✓ 100 rows returned in 0.42s
Oracle Fusion Cloud · prod
›