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


TABLE: GMP.RH_EXPT_MST

Object Details
Object Name: RH_EXPT_MST
Object Type: TABLE
Owner: GMP
FND Design Data: TableGMP.RH_EXPT_MST
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RH_EXPT_MST_I1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSCHEDULE_ID
ColumnEXPORT_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (22) Yes
RUN_STATUS NUMBER (5) Yes
RUN_BY VARCHAR2 (4) Yes
EXPORT_ID NUMBER (10) Yes
QUEUE_NO NUMBER
Yes
BATCH_DATE DATE
Yes
ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT SCHEDULE_ID
,      RUN_STATUS
,      RUN_BY
,      EXPORT_ID
,      QUEUE_NO
,      BATCH_DATE
,      ACTUAL_END_DATE
,      ACTUAL_START_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GMP.RH_EXPT_MST;

Dependencies

[top of page]

GMP.RH_EXPT_MST does not reference any database object

GMP.RH_EXPT_MST is referenced by following:

SchemaAPPS
SynonymRH_EXPT_MST