eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_EMPLOYMENTS

Source

View Text - Preformatted


SELECT HEH1.PARTY_ID, HZP.PARTY_NUMBER, HEH1.BEGIN_DATE, HEH1.END_DATE, HEH1.SUPERVISOR_NAME, HEH1.EMPLOYED_AS_TITLE, HEH1.EMPLOYED_BY_NAME_COMPANY, HEH1.EMPLOYED_BY_DIVISION_NAME, HEH1.BRANCH, HEH1.MILITARY_RANK, HEH1.SERVED, HEH1.STATION, '_LA:HEH1.EMPLOYMENT_TYPE_CODE:AR_LOOKUPS:HZ_EMPLOYMENT_TYPE:MEANING', HEH1.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT, '_LA:HEH1.TENURE_CODE:AR_LOOKUPS:HZ_TENURE_CODE:MEANING' , HED.OCCUPATIONAL_TITLE_CODE, POT.OCCUPATIONAL_TITLE, HEH1.WEEKLY_WORK_HOURS, HEH1.COMMENTS, HEH1.REASON_FOR_LEAVING, HZP1.PARTY_NUMBER EMPLOYED_BY_PARTY_NUMBER, HEH1.EMPLOYED_BY_PARTY_ID, HED.HZ_EMP_DTL_ID, HEH1.EMPLOYMENT_HISTORY_ID, HEH1.CREATION_DATE, HEH1.CREATED_BY, HEH1.LAST_UPDATED_BY, HEH1.LAST_UPDATE_DATE FROM IGS_AD_HZ_EMP_DTL HED, HZ_PARTIES HZP, IGS_PS_DIC_OCC_TITLS POT, HZ_EMPLOYMENT_HISTORY HEH1, HZ_PARTIES HZP1 WHERE HEH1.EMPLOYMENT_HISTORY_ID=HED.EMPLOYMENT_HISTORY_ID AND HED.OCCUPATIONAL_TITLE_CODE=POT.OCCUPATIONAL_TITLE_CODE(+) AND HZP.PARTY_ID=HEH1.PARTY_ID AND HEH1.EMPLOYED_BY_PARTY_ID = HZP1.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT HEH1.PARTY_ID
, HZP.PARTY_NUMBER
, HEH1.BEGIN_DATE
, HEH1.END_DATE
, HEH1.SUPERVISOR_NAME
, HEH1.EMPLOYED_AS_TITLE
, HEH1.EMPLOYED_BY_NAME_COMPANY
, HEH1.EMPLOYED_BY_DIVISION_NAME
, HEH1.BRANCH
, HEH1.MILITARY_RANK
, HEH1.SERVED
, HEH1.STATION
, '_LA:HEH1.EMPLOYMENT_TYPE_CODE:AR_LOOKUPS:HZ_EMPLOYMENT_TYPE:MEANING'
, HEH1.FRACTION_OF_TENURE FRACTION_OF_EMPLOYMENT
, '_LA:HEH1.TENURE_CODE:AR_LOOKUPS:HZ_TENURE_CODE:MEANING'
, HED.OCCUPATIONAL_TITLE_CODE
, POT.OCCUPATIONAL_TITLE
, HEH1.WEEKLY_WORK_HOURS
, HEH1.COMMENTS
, HEH1.REASON_FOR_LEAVING
, HZP1.PARTY_NUMBER EMPLOYED_BY_PARTY_NUMBER
, HEH1.EMPLOYED_BY_PARTY_ID
, HED.HZ_EMP_DTL_ID
, HEH1.EMPLOYMENT_HISTORY_ID
, HEH1.CREATION_DATE
, HEH1.CREATED_BY
, HEH1.LAST_UPDATED_BY
, HEH1.LAST_UPDATE_DATE
FROM IGS_AD_HZ_EMP_DTL HED
, HZ_PARTIES HZP
, IGS_PS_DIC_OCC_TITLS POT
, HZ_EMPLOYMENT_HISTORY HEH1
, HZ_PARTIES HZP1
WHERE HEH1.EMPLOYMENT_HISTORY_ID=HED.EMPLOYMENT_HISTORY_ID
AND HED.OCCUPATIONAL_TITLE_CODE=POT.OCCUPATIONAL_TITLE_CODE(+)
AND HZP.PARTY_ID=HEH1.PARTY_ID
AND HEH1.EMPLOYED_BY_PARTY_ID = HZP1.PARTY_ID (+) WITH READ ONLY