HRMS - Applicant Detail: Detail (1)
Description
Categories: Discoverer
This workbook reports on the detail of your applicants
Owner: SYSADMIN (Jonathan Smith)
Identifier: HRIPRAPD
Owner: SYSADMIN (Jonathan Smith)
Identifier: HRIPRAPD
Run
HRMS - Applicant Detail: Detail (1) and other Oracle EBS reports with Blitz Report™ on our demo environment
select distinct c.username "user", c.osuser , c.sid, c.serial#, b.spid "unix_pid", c.machine, c.program "program", a.blocks * e.block_size/1024/1024 mb_temp_used , a.tablespace, d.sql_text from gv$sort_usage a, gv$process b, gv$session c, gv$sqlarea d, dba_tablespaces e where c.saddr=a.session_addr and b.addr=c.paddr and c.sql_address=d.address(+) and a.tablespace = e.tablespace_name order by mb_temp_used desc |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Vacancy Name |
|
LOV | |
| Source Type |
|
LOV | |
| Job Name |
|
LOV | |
| Organization Name |
|
LOV | |
| Location Name |
|
LOV | |
| Grade Name |
|
LOV | |
| Position Name |
|
LOV | |
| Applicant Name |
|
LOV | |
| Business Group Name |
|
LOV | |
| Effective Date |
|
Date |
