VIEW: APPS.PER_RECRUITMENT_ACTIVITIES_V

Source

View Text - Preformatted

SELECT RCA.ROWID ROW_ID , RCA.RECRUITMENT_ACTIVITY_ID , RCA.BUSINESS_GROUP_ID , RCA.AUTHORISING_PERSON_ID , PP1.FULL_NAME AUTH_PERSON_NAME , NVL(PP1.EMPLOYEE_NUMBER, PP1.NPW_NUMBER) AUTH_NUMBER , RCA.RUN_BY_ORGANIZATION_ID , HOUTL.NAME ORG_RUN_BY_NAME , HL.MEANING D_TYPE , RCA.INTERNAL_CONTACT_PERSON_ID , PP2.FULL_NAME INT_CONTACT_NAME , NVL(PP2.EMPLOYEE_NUMBER, PP2.NPW_NUMBER) INT_CONT_NUM , RCA.PARENT_RECRUITMENT_ACTIVITY_ID , RCA1.NAME PARENT_REC_NAME , HL2.MEANING D_PARENT_REC_TYPE , RCA1.TYPE C_PARENT_REC_TYPE_CODE , RCA.CURRENCY_CODE , RCA.DATE_START , RCA.NAME , RCA.ACTUAL_COST , HR_CHKFMT.CHANGEFORMAT( RCA.ACTUAL_COST, 'M', RCA.CURRENCY_CODE) D_ACTUAL_COST , RCA.COMMENTS , RCA.CONTACT_TELEPHONE_NUMBER , RCA.DATE_CLOSING , RCA.DATE_END , RCA.EXTERNAL_CONTACT , RCA.PLANNED_COST , HR_CHKFMT.CHANGEFORMAT( RCA.PLANNED_COST, 'M', RCA.CURRENCY_CODE) D_PLANNED_COST , RCA.TYPE , RCA.REQUEST_ID , RCA.PROGRAM_APPLICATION_ID , RCA.PROGRAM_ID , RCA.PROGRAM_UPDATE_DATE , RCA.ATTRIBUTE_CATEGORY , RCA.ATTRIBUTE1 , RCA.ATTRIBUTE2 , RCA.ATTRIBUTE3 , RCA.ATTRIBUTE4 , RCA.ATTRIBUTE5 , RCA.ATTRIBUTE6 , RCA.ATTRIBUTE7 , RCA.ATTRIBUTE8 , RCA.ATTRIBUTE9 , RCA.ATTRIBUTE10 , RCA.ATTRIBUTE11 , RCA.ATTRIBUTE12 , RCA.ATTRIBUTE13 , RCA.ATTRIBUTE14 , RCA.ATTRIBUTE15 , RCA.ATTRIBUTE16 , RCA.ATTRIBUTE17 , RCA.ATTRIBUTE18 , RCA.ATTRIBUTE19 , RCA.ATTRIBUTE20 , RCA.LAST_UPDATE_DATE , RCA.LAST_UPDATED_BY , RCA.LAST_UPDATE_LOGIN , RCA.CREATED_BY , RCA.CREATION_DATE FROM PER_RECRUITMENT_ACTIVITIES RCA , PER_ALL_PEOPLE_F PP1 , PER_ALL_PEOPLE_F PP2 , HR_ALL_ORGANIZATION_UNITS HOU , HR_ALL_ORGANIZATION_UNITS_TL HOUTL , PER_RECRUITMENT_ACTIVITIES RCA1 , HR_LOOKUPS HL , HR_LOOKUPS HL2 WHERE RCA.AUTHORISING_PERSON_ID = PP1.PERSON_ID(+) AND RCA.INTERNAL_CONTACT_PERSON_ID = PP2.PERSON_ID(+) AND RCA.TYPE = HL.LOOKUP_CODE(+) AND HL.LOOKUP_TYPE(+) = 'REC_TYPE' AND RCA1.TYPE = HL2.LOOKUP_CODE(+) AND HL2.LOOKUP_TYPE(+) = 'REC_TYPE' AND RCA.RUN_BY_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+) AND RCA.PARENT_RECRUITMENT_ACTIVITY_ID = RCA1.RECRUITMENT_ACTIVITY_ID(+) AND (PP1.PERSON_ID IS NULL OR (PP1.EFFECTIVE_START_DATE <= RCA.DATE_START AND PP1.EFFECTIVE_END_DATE >= RCA.DATE_START)) AND (PP2.PERSON_ID IS NULL OR (PP2.EFFECTIVE_START_DATE <= RCA.DATE_START AND PP2.EFFECTIVE_END_DATE >= RCA.DATE_START)) AND HOU.organization_id = HOUTL.organization_id (+) AND decode (HOUTL.organization_id, null, '1',HOUTL.language) = decode(HOUTL.organization_id, null, '1',userenv('LANG'))

View Text - HTML Formatted

SELECT RCA.ROWID ROW_ID
, RCA.RECRUITMENT_ACTIVITY_ID
, RCA.BUSINESS_GROUP_ID
, RCA.AUTHORISING_PERSON_ID
, PP1.FULL_NAME AUTH_PERSON_NAME
, NVL(PP1.EMPLOYEE_NUMBER
, PP1.NPW_NUMBER) AUTH_NUMBER
, RCA.RUN_BY_ORGANIZATION_ID
, HOUTL.NAME ORG_RUN_BY_NAME
, HL.MEANING D_TYPE
, RCA.INTERNAL_CONTACT_PERSON_ID
, PP2.FULL_NAME INT_CONTACT_NAME
, NVL(PP2.EMPLOYEE_NUMBER
, PP2.NPW_NUMBER) INT_CONT_NUM
, RCA.PARENT_RECRUITMENT_ACTIVITY_ID
, RCA1.NAME PARENT_REC_NAME
, HL2.MEANING D_PARENT_REC_TYPE
, RCA1.TYPE C_PARENT_REC_TYPE_CODE
, RCA.CURRENCY_CODE
, RCA.DATE_START
, RCA.NAME
, RCA.ACTUAL_COST
, HR_CHKFMT.CHANGEFORMAT( RCA.ACTUAL_COST
, 'M'
, RCA.CURRENCY_CODE) D_ACTUAL_COST
, RCA.COMMENTS
, RCA.CONTACT_TELEPHONE_NUMBER
, RCA.DATE_CLOSING
, RCA.DATE_END
, RCA.EXTERNAL_CONTACT
, RCA.PLANNED_COST
, HR_CHKFMT.CHANGEFORMAT( RCA.PLANNED_COST
, 'M'
, RCA.CURRENCY_CODE) D_PLANNED_COST
, RCA.TYPE
, RCA.REQUEST_ID
, RCA.PROGRAM_APPLICATION_ID
, RCA.PROGRAM_ID
, RCA.PROGRAM_UPDATE_DATE
, RCA.ATTRIBUTE_CATEGORY
, RCA.ATTRIBUTE1
, RCA.ATTRIBUTE2
, RCA.ATTRIBUTE3
, RCA.ATTRIBUTE4
, RCA.ATTRIBUTE5
, RCA.ATTRIBUTE6
, RCA.ATTRIBUTE7
, RCA.ATTRIBUTE8
, RCA.ATTRIBUTE9
, RCA.ATTRIBUTE10
, RCA.ATTRIBUTE11
, RCA.ATTRIBUTE12
, RCA.ATTRIBUTE13
, RCA.ATTRIBUTE14
, RCA.ATTRIBUTE15
, RCA.ATTRIBUTE16
, RCA.ATTRIBUTE17
, RCA.ATTRIBUTE18
, RCA.ATTRIBUTE19
, RCA.ATTRIBUTE20
, RCA.LAST_UPDATE_DATE
, RCA.LAST_UPDATED_BY
, RCA.LAST_UPDATE_LOGIN
, RCA.CREATED_BY
, RCA.CREATION_DATE
FROM PER_RECRUITMENT_ACTIVITIES RCA
, PER_ALL_PEOPLE_F PP1
, PER_ALL_PEOPLE_F PP2
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, PER_RECRUITMENT_ACTIVITIES RCA1
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
WHERE RCA.AUTHORISING_PERSON_ID = PP1.PERSON_ID(+)
AND RCA.INTERNAL_CONTACT_PERSON_ID = PP2.PERSON_ID(+)
AND RCA.TYPE = HL.LOOKUP_CODE(+)
AND HL.LOOKUP_TYPE(+) = 'REC_TYPE'
AND RCA1.TYPE = HL2.LOOKUP_CODE(+)
AND HL2.LOOKUP_TYPE(+) = 'REC_TYPE'
AND RCA.RUN_BY_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND RCA.PARENT_RECRUITMENT_ACTIVITY_ID = RCA1.RECRUITMENT_ACTIVITY_ID(+)
AND (PP1.PERSON_ID IS NULL OR (PP1.EFFECTIVE_START_DATE <= RCA.DATE_START
AND PP1.EFFECTIVE_END_DATE >= RCA.DATE_START))
AND (PP2.PERSON_ID IS NULL OR (PP2.EFFECTIVE_START_DATE <= RCA.DATE_START
AND PP2.EFFECTIVE_END_DATE >= RCA.DATE_START))
AND HOU.ORGANIZATION_ID = HOUTL.ORGANIZATION_ID (+)
AND DECODE (HOUTL.ORGANIZATION_ID
, NULL
, '1'
, HOUTL.LANGUAGE) = DECODE(HOUTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))