VIEW: APPS.IGS_AD_EMP_DTL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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