HRMS - Applicant Detail: Phone
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: Phone and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT HRFG_APPLICANT_DETAILS.APPLICANT_NAME, HRFG_APPLICANT_DETAILS.BUSINESS_GROUP_NAME, HRFG_PHONES.PHONE_NUMBER, HRFG_PHONES.PHONE_TYPE FROM HRFG_APPLICANT_DETAILS HRFG_APPLICANT_DETAILS, HRFG_PHONES HRFG_PHONES WHERE 1=1 AND ((HRFG_APPLICANT_DETAILS.PERSON_ID = HRFG_PHONES.PERSON_ID ) ) AND (HRFG_APPLICANT_DETAILS.APPLICATION_START_DATE IS NOT NULL ) AND (:effective_date BETWEEN HRFG_PHONES.DATE_FROM AND NVL(HRFG_PHONES.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 |
|
LOV | |
Business Group Name |
|
LOV | |
Effective Date |
|
Date |
Blitz Report™