Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
(Move to ...)
Home
▼
Thursday, October 28, 2021
Query to list Job Names in Oracle APPS
SELECT name job_name
,TO_CHAR (date_from, 'DD-MON-RRRR') date_from
FROM per_jobs_vl
WHERE TRUNC (creation_date) BETWEEN TO_DATE ('01-JAN-2020', 'DD-MON-YYYY')
AND TO_DATE ('31-DEC-2021', 'DD-MON-YYYY')
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment