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

TABLE: GMP.RH_MORD_IMP

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

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RH_MORD_IMPI1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnIMPORT_ID
ColumnACTION_TYPE
ColumnORGN_CODE
Columns
Name Datatype Length Mandatory Comments
IMPORT_ID NUMBER (10) Yes
BATCH_ID NUMBER (10) Yes
LINE_NO NUMBER (10) Yes
PROCESS_ID NUMBER (10) Yes
DOC_TYPE VARCHAR2 (4) Yes
BATCH_NO VARCHAR2 (32) Yes
ORGN_CODE VARCHAR2 (4) Yes
OLD_ROUTING_NO VARCHAR2 (32) Yes
OLD_ROUTING_VERS NUMBER (5) Yes
ROUTING_NO VARCHAR2 (32) Yes
ROUTING_VERS NUMBER (10) Yes
EFF_ID NUMBER (10) Yes
OLD_EFF_ID NUMBER (10) Yes
OLD_PLAN_QTY NUMBER (21) Yes
PLAN_QTY NUMBER (21) Yes
OLD_PST DATE
Yes
PST DATE
Yes
OLD_PET DATE
Yes
PET DATE
Yes
NEW_DOC_TYPE VARCHAR2 (4) Yes
NEW_DOC_ID NUMBER (10) Yes
ACTION_TYPE NUMBER (10) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

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


SELECT IMPORT_ID
,      BATCH_ID
,      LINE_NO
,      PROCESS_ID
,      DOC_TYPE
,      BATCH_NO
,      ORGN_CODE
,      OLD_ROUTING_NO
,      OLD_ROUTING_VERS
,      ROUTING_NO
,      ROUTING_VERS
,      EFF_ID
,      OLD_EFF_ID
,      OLD_PLAN_QTY
,      PLAN_QTY
,      OLD_PST
,      PST
,      OLD_PET
,      PET
,      NEW_DOC_TYPE
,      NEW_DOC_ID
,      ACTION_TYPE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
FROM GMP.RH_MORD_IMP;

Dependencies

[top of page]

GMP.RH_MORD_IMP does not reference any database object

GMP.RH_MORD_IMP is referenced by following:

SchemaGMP
ViewRH_MORD_IMP#