HRMS - Applicant Detail: Detail (2)

➜ Back to Library
Description
Categories: Discoverer
This workbook reports on the detail of your applicants
Owner: SYSADMIN (Jonathan Smith)
Identifier: HRIPRAPD
Run HRMS - Applicant Detail: Detail (2) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.APPLICANT_NUMBER, HRFG_APPLICANT_DETAILS.APPLICANT_PERSON_TYPE, HRFG_APPLICANT_DETAILS.APPLICANT_TYPE, HRFG_APPLICANT_DETAILS.APPLICATION_COMMENTS, HRFG_APPLICANT_DETAILS.APPLICATION_END_DATE, HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE, HRFG_APPLICANT_DETAILS.APPLICATION_STATUS, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_APPLICANT_DETAILS.CURRENT_EMPLOYER, HRFG_APPLICANT_DETAILS.EMPLOYEE_PERSON_TYPE, HRFG_APPLICANT_DETAILS.GRADE_NAME, HRFG_APPLICANT_DETAILS.JOB_NAME, HRFG_APPLICANT_DETAILS.JOB_POST_SOURCE_NAME, HRFG_APPLICANT_DETAILS.LOCATION_NAME, HRFG_APPLICANT_DETAILS.ORGANIZATION_NAME, HRFG_APPLICANT_DETAILS.PEOPLE_GROUP, HRFG_APPLICANT_DETAILS.POSITION_NAME, HRFG_APPLICANT_DETAILS.PROJECTED_HIRE_DATE, HRFG_APPLICANT_DETAILS.RECRUITER_NAME, HRFG_APPLICANT_DETAILS.RECRUITMENT_ACTIVITY_NAME, HRFG_APPLICANT_DETAILS.REFERRING_EMPLOYEE_NAME, HRFG_APPLICANT_DETAILS.SOURCE_TYPE, HRFG_APPLICANT_DETAILS.USER_CONCAT_PERSON_TYPE, HRFG_APPLICANT_DETAILS.VACANCY_NAME
FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS WHERE 1=1 AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND (:effective_date BETWEEN HRFG_APPLICANT_DETAILS.RECORD_START_DATE AND HRFG_APPLICANT_DETAILS.RECORD_END_DATE )
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
HRMS - Applicant Detail: Detail PO Purchase Price Variance PER Full Person Details PO Item Summary Listing PO Substitute Receipts PO Requisitions on Cancelled Order PO Item Detail Listing PO Requisition Activity Register PO RFQ Action Required
Blitz Report™

Blitz Report™ provides multiple benefits: