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: GHR_PA_REMARKS_V

Product:	GHR - US Federal Human Resources
Description:	GHR_PA_REMARKS_V is a view based on GHR_PA_REMARKS for use bythe form.
Implementation/DBA Data:	APPS.GHR_PA_REMARKS_V

View Text

SELECT PRE.ROWID ROW_ID
, PRE.PA_REMARK_ID
, PRE.PA_REQUEST_ID
, PRE.REMARK_ID
, REM.CODE REMARK_CODE
, PRE.DESCRIPTION
, PRE.OBJECT_VERSION_NUMBER
, PRE.LAST_UPDATE_DATE
, PRE.LAST_UPDATED_BY
, PRE.LAST_UPDATE_LOGIN
, PRE.CREATED_BY
, PRE.CREATION_DATE
, REM.CODE REMARK_CODE_INFORMATION_CAT
, PRE.REMARK_CODE_INFORMATION1
, PRE.REMARK_CODE_INFORMATION2
, PRE.REMARK_CODE_INFORMATION3
, PRE.REMARK_CODE_INFORMATION4
, PRE.REMARK_CODE_INFORMATION5
FROM GHR_REMARKS REM
, GHR_PA_REMARKS PRE
WHERE PRE.REMARK_ID = REM.REMARK_ID

Columns

Name
ROW_ID
PA_REMARK_ID
PA_REQUEST_ID
REMARK_ID
REMARK_CODE
DESCRIPTION
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
REMARK_CODE_INFORMATION_CAT
REMARK_CODE_INFORMATION1
REMARK_CODE_INFORMATION2
REMARK_CODE_INFORMATION3
REMARK_CODE_INFORMATION4
REMARK_CODE_INFORMATION5