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.

[Home] [Help]

View: AMS_PERSON_EMP_HIST_V

Product:	AMS - Marketing
Description:	Person's employment information
Implementation/DBA Data:	APPS.AMS_PERSON_EMP_HIST_V

View Text

SELECT HEH.EMPLOYMENT_HISTORY_ID
, HEH.PARTY_ID
, HEH.BEGIN_DATE
, HEH.END_DATE
, HEH.EMPLOYED_AS_TITLE
, HEH.EMPLOYED_BY_DIVISION_NAME
, HEH.EMPLOYED_BY_NAME_COMPANY
, HEH.SUPERVISOR_NAME
, HEH.BRANCH
, HEH.MILITARY_RANK
, HEH.SERVED
, HEH.STATION
, HEH.RESPONSIBILITY
FROM HZ_EMPLOYMENT_HISTORY HEH
, HZ_PARTIES HP
WHERE HEH.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'

Columns

Name
EMPLOYMENT_HISTORY_ID
PARTY_ID
BEGIN_DATE
END_DATE
EMPLOYED_AS_TITLE
EMPLOYED_BY_DIVISION_NAME
EMPLOYED_BY_NAME_COMPANY
SUPERVISOR_NAME
BRANCH
MILITARY_RANK
SERVED
STATION
RESPONSIBILITY