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