HRMS - Applicant Detail: Detail (1)

➜ Back to Library
Description
Categories: Discoverer
This workbook reports on the detail of your applicants
Owner: SYSADMIN (Jonathan Smith)
Identifier: HRIPRAPD

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 
HRFG_APPLICANT_DETAILS.VACANCY_NAME = :vacancy_name
 LOV
Source Type 
HRFG_APPLICANT_DETAILS.SOURCE_TYPE = :source_type
 LOV
Job Name 
HRFG_APPLICANT_DETAILS.JOB_NAME = :job_name
 LOV
Organization Name 
HRFG_APPLICANT_DETAILS.ORGANIZATION_NAME = :organization_name
 LOV
Location Name 
HRFG_APPLICANT_DETAILS.LOCATION_NAME = :location_name
 LOV
Grade Name 
HRFG_APPLICANT_DETAILS.GRADE_NAME = :grade_name
 LOV
Position Name 
HRFG_APPLICANT_DETAILS.POSITION_NAME = :position_name
 LOV
Applicant Name 
HRFG_APPLICANT_DETAILS.APPLICANT_NAME = :applicant_name
 LOV
Business Group Name 
HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME = :business_group_name
 LOV
Effective Date 
 
 Date
Download
 
Related Blitz Reports
DBA Blocking Sessions DBA AWR SQL Performance Summary DBA SGA Blocking Session Summary DBA AWR Blocking Session Summary DBA AWR Active Session History DBA SGA Active Session History DBA SGA SQL Performance Summary DBA SGA+PGA Memory Configuration FND Concurrent Requests 11i
Blitz Report™

Blitz Report™ provides multiple benefits: