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

VIEW: GMP.RH_MORD_IMP#

Object Details
Object Name: RH_MORD_IMP#
Object Type: VIEW
Owner: GMP
Subobject Name:
Status: VALID

[View Source]

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# references the following:

SchemaGMP
TableRH_MORD_IMP
GMP.RH_MORD_IMP# is referenced by following:

SchemaAPPS
SynonymRH_MORD_IMP