DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.GHR_MULTI_IA_REMARKS

Object Details
Object Name: GHR_MULTI_IA_REMARKS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


This table is used for store remarks of Multiple Intervenig actions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
IA_REMARKS_ID NUMBER (15) Yes Ia Remarks ID
IA_PROCESS_ID NUMBER (15) Yes IA Process Id
REMARK_ID NUMBER (15) Yes Remark Id
DESCRIPTION VARCHAR2 (2000)
Description
REMARK_CODE_INFORMATION1 VARCHAR2 (2000)
Remark Code Info1
REMARK_CODE_INFORMATION2 VARCHAR2 (150)
Remark Code Info2
REMARK_CODE_INFORMATION3 VARCHAR2 (150)
Remark Code Info3
REMARK_CODE_INFORMATION4 VARCHAR2 (150)
Remark Code Info4
REMARK_CODE_INFORMATION5 VARCHAR2 (150)
Remark Code Info5
REMARK_CODE_INFORMATION_CAT VARCHAR2 (30)
Remark Code Info Cat
CREATED_BY NUMBER (15) Yes Created by
CREATION_DATE DATE
Yes Created Date
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Update By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT IA_REMARKS_ID
,      IA_PROCESS_ID
,      REMARK_ID
,      DESCRIPTION
,      REMARK_CODE_INFORMATION1
,      REMARK_CODE_INFORMATION2
,      REMARK_CODE_INFORMATION3
,      REMARK_CODE_INFORMATION4
,      REMARK_CODE_INFORMATION5
,      REMARK_CODE_INFORMATION_CAT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HR.GHR_MULTI_IA_REMARKS;

Dependencies

[top of page]

HR.GHR_MULTI_IA_REMARKS does not reference any database object

HR.GHR_MULTI_IA_REMARKS is referenced by following:

SchemaHR
ViewGHR_MULTI_IA_REMARKS#