View: IGS_AD_EMP_DTL

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_AD_EMP_DTL

View Text

SELECT EH.ROWID ROW_ID
, EH.EMPLOYMENT_HISTORY_ID
, EH.PARTY_ID PERSON_ID
, EH.BEGIN_DATE START_DT
, EH.END_DATE END_DT
, EH.SUPERVISOR_NAME CONTACT
, L1.MEANING TYPE_OF_EMPLOYMENT
, EH.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT
, L2.MEANING TENURE_OF_EMPLOYMENT
, EH.EMPLOYED_AS_TITLE POSITION
, AHED.OCCUPATIONAL_TITLE_CODE
, DOT.OCCUPATIONAL_TITLE
, EH.WEEKLY_WORK_HOURS
, EH.COMMENTS
, EH.EMPLOYED_BY_NAME_COMPANY EMPLOYER
, EH.EMPLOYED_BY_DIVISION_NAME
, EH.BRANCH
, EH.MILITARY_RANK
, EH.SERVED
, EH.STATION
, EH.CREATED_BY
, EH.CREATION_DATE
, EH.LAST_UPDATED_BY
, EH.LAST_UPDATE_DATE
, EH.LAST_UPDATE_LOGIN
, EH.REQUEST_ID
, EH.PROGRAM_APPLICATION_ID
, EH.PROGRAM_ID
, EH.PROGRAM_UPDATE_DATE
, EH.OBJECT_VERSION_NUMBER
, EH.EMPLOYED_BY_PARTY_ID
, HZ.PARTY_NUMBER EMPLOYED_BY_PARTY_NUMBER
, HZ.PARTY_NAME EMPLOYED_BY_PARTY_NAME
, EH.EMPLOYMENT_TYPE_CODE TYPE_OF_EMPLOYMENT_CODE
, EH.TENURE_CODE TENURE_OF_EMPLOYMENT_CODE
, EH.REASON_FOR_LEAVING REASON_FOR_LEAVING
FROM HZ_EMPLOYMENT_HISTORY EH
, IGS_AD_HZ_EMP_DTL AHED
, IGS_PS_DIC_OCC_TITLS DOT
, HZ_PARTIES HZ
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
WHERE EH.EMPLOYMENT_HISTORY_ID = AHED.EMPLOYMENT_HISTORY_ID (+)
AND AHED.OCCUPATIONAL_TITLE_CODE = DOT.OCCUPATIONAL_TITLE_CODE(+)
AND EH.EMPLOYED_BY_PARTY_ID = HZ.PARTY_ID (+)
AND L1.LOOKUP_CODE(+) = EH.EMPLOYMENT_TYPE_CODE
AND L1.LOOKUP_TYPE(+) = 'HZ_EMPLOYMENT_TYPE'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0
AND L2.LOOKUP_CODE(+) = EH.TENURE_CODE
AND L2.LOOKUP_TYPE(+) = 'HZ_TENURE_CODE'
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID(+) = 222
AND L2.SECURITY_GROUP_ID(+) = 0

Columns