Oracle Apps Fusion Blog(Forms, Reports, Oracle Application Technical, SQL, PL/SQL, OAF)
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
APEX$TASK_PK
APEX$TASK_PK is a substitution string holding the primary key value of the system of records
FNDLOAD to Download and Upload XML Publisher Data Template (.xml) Report
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
Query to get OM Order Types in Oracle Apps
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
SQL Query To Get Invoice Validation And Accounting Status For The Given Check Number (Doc ID 2975480.1)
SELECT aca.check_number ,aia.invoice_id ,aia.invoice_num ,aia.invoice_amount ,distribution_line_number ,aida.accrual_p...
No comments:
Post a Comment