HRMS - Applicant Detail: Address (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: Address (2) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT HRFG_ADDRESSES.ADDRESS_LINE1, HRFG_ADDRESSES.ADDRESS_LINE2, HRFG_ADDRESSES.ADDRESS_LINE3, HRFG_ADDRESSES.ADDRESS_STYLE, HRFG_ADDRESSES.ADDRESS_TYPE, HRFG_ADDRESSES.ADDR_COMMENTS, HRFG_ADDRESSES.ADDR_DATE_FROM, HRFG_ADDRESSES.ADDR_DATE_TO, HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_ADDRESSES.CITY, HRFG_ADDRESSES.POSTAL_CODE, HRFG_ADDRESSES.PRIMARY_FLAG, HRFG_ADDRESSES.REGION_1, HRFG_ADDRESSES.REGION_2
FROM HRFG_ADDRESSES HRFG_ADDRESSES, HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS WHERE 1=1 AND ((HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_ADDRESSES.PERSON_ID ) ) AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL  ) AND (:effective_date BETWEEN HRFG_ADDRESSES.ADDR_DATE_FROM AND NVL(HRFG_ADDRESSES.ADDR_DATE_TO,'31-DEC-4712') ) AND (:effective_date BETWEEN HRFG_APPLICANT_DETAILS.RECORD_START_DATE AND HRFG_APPLICANT_DETAILS.RECORD_END_DATE )    
ORDER BY HRFG_APPLICANT_DETAILS.APPLICANT_NAME ASC
Parameter Name SQL text Validation
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: Address (13) HRMS - Applicant Detail: Address (12) HRMS - Applicant Detail: Address (4) HRMS - Applicant Detail: Address (14) HRMS - Applicant Detail: Address (9) HRMS - Applicant Detail: Address (8) HRMS - Applicant Detail: Address (1) HRMS - Applicant Detail: Address HRMS - Applicant Detail: Address (5)
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™