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


TABLE: GMP.RH_IMPT_MST

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

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RH_IMPT_MST_I1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSCHEDULE_ID
ColumnIMPORT_ID
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Yes
SCHEDULE_ID NUMBER (22) Yes
ACTUAL_END_DATE DATE

ACTUAL_START_DATE DATE

QUEUE_NO NUMBER
Yes
RUN_STATUS NUMBER (5) Yes
RUN_BY VARCHAR2 (4) Yes
BATCH_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
Query Text

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


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

Dependencies

[top of page]

GMP.RH_IMPT_MST does not reference any database object

GMP.RH_IMPT_MST is referenced by following:

SchemaAPPS
SynonymRH_IMPT_MST