VIEW: APPS.HRI_MD_REC_APL_SRC_V

Source

View Text - Preformatted

SELECT 1 apl_indicator ,CASE WHEN (apa.hire_date IS NOT NULL) THEN 1 ELSE 0 END emp_indicator ,NVL(apa.job_source_type_code,'NA_EDW') job_source_type ,NVL(apa.job_source_name,'NA_EDW') job_source_name ,apa.application_date apl_or_hire_date ,apa.application_id application_id ,apa.assignment_id assignment_id ,nvl(apa.grade_id,-1) grade_id ,nvl(apa.job_id,-1) job_id ,nvl(apa.location_id,-1) location_id ,nvl(vac.manager_id,-1) manager_id ,apa.organization_id organization_id ,nvl(apa.people_group_id,-1) people_group_id ,apa.person_id person_id ,nvl(apa.posting_content_id,-1) posting_content_id ,nvl(apa.recruiter_id,-1) recruiter_id ,nvl(apa.supervisor_id,-1) supervisor_id ,nvl(apa.vacancy_id,-1) vacancy_id ,nvl(apa.vendor_id,-1) vendor_id FROM hri_mb_apl_activity_v apa ,per_all_vacancies vac WHERE vac.vacancy_id (+) = apa.vacancy_id WITH READ ONLY

View Text - HTML Formatted

SELECT 1 APL_INDICATOR
, CASE WHEN (APA.HIRE_DATE IS NOT NULL) THEN 1 ELSE 0 END EMP_INDICATOR
, NVL(APA.JOB_SOURCE_TYPE_CODE
, 'NA_EDW') JOB_SOURCE_TYPE
, NVL(APA.JOB_SOURCE_NAME
, 'NA_EDW') JOB_SOURCE_NAME
, APA.APPLICATION_DATE APL_OR_HIRE_DATE
, APA.APPLICATION_ID APPLICATION_ID
, APA.ASSIGNMENT_ID ASSIGNMENT_ID
, NVL(APA.GRADE_ID
, -1) GRADE_ID
, NVL(APA.JOB_ID
, -1) JOB_ID
, NVL(APA.LOCATION_ID
, -1) LOCATION_ID
, NVL(VAC.MANAGER_ID
, -1) MANAGER_ID
, APA.ORGANIZATION_ID ORGANIZATION_ID
, NVL(APA.PEOPLE_GROUP_ID
, -1) PEOPLE_GROUP_ID
, APA.PERSON_ID PERSON_ID
, NVL(APA.POSTING_CONTENT_ID
, -1) POSTING_CONTENT_ID
, NVL(APA.RECRUITER_ID
, -1) RECRUITER_ID
, NVL(APA.SUPERVISOR_ID
, -1) SUPERVISOR_ID
, NVL(APA.VACANCY_ID
, -1) VACANCY_ID
, NVL(APA.VENDOR_ID
, -1) VENDOR_ID
FROM HRI_MB_APL_ACTIVITY_V APA
, PER_ALL_VACANCIES VAC
WHERE VAC.VACANCY_ID (+) = APA.VACANCY_ID WITH READ ONLY