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

VIEW: CLN.M4U_DMD_DOCUMENTS#

Object Details
Object Name: M4U_DMD_DOCUMENTS#
Object Type: VIEW
Owner: CLN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MSG_ID VARCHAR2 (30)
DOC_ID VARCHAR2 (30)
REF_DOC_ID VARCHAR2 (30)
ORIG_DOC_ID VARCHAR2 (80)
TYPE VARCHAR2 (30)
ACTION VARCHAR2 (30)
DOC_TIMESTAMP DATE

DOC_STATUS VARCHAR2 (30)
FUNCTIONAL_STATUS VARCHAR2 (30)
PROCESSING_MESSAGE VARCHAR2 (2000)
TOP_GTIN VARCHAR2 (30)
INFO_PROVIDER_GLN VARCHAR2 (30)
DATA_RECEPIENT_GLN VARCHAR2 (30)
TARGET_MARKET_COUNTRY VARCHAR2 (30)
TARGET_MARKET_SUB_DIV VARCHAR2 (30)
PARAMETER1 VARCHAR2 (50)
PARAMETER2 VARCHAR2 (50)
PARAMETER3 VARCHAR2 (50)
PARAMETER4 VARCHAR2 (50)
PARAMETER5 VARCHAR2 (50)
LPARAMETER1 VARCHAR2 (400)
LPARAMETER2 VARCHAR2 (400)
LPARAMETER3 VARCHAR2 (400)
LPARAMETER4 VARCHAR2 (400)
LPARAMETER5 VARCHAR2 (400)
RETRY_COUNT NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT MSG_ID
,      DOC_ID
,      REF_DOC_ID
,      ORIG_DOC_ID
,      TYPE
,      ACTION
,      DOC_TIMESTAMP
,      DOC_STATUS
,      FUNCTIONAL_STATUS
,      PROCESSING_MESSAGE
,      TOP_GTIN
,      INFO_PROVIDER_GLN
,      DATA_RECEPIENT_GLN
,      TARGET_MARKET_COUNTRY
,      TARGET_MARKET_SUB_DIV
,      PARAMETER1
,      PARAMETER2
,      PARAMETER3
,      PARAMETER4
,      PARAMETER5
,      LPARAMETER1
,      LPARAMETER2
,      LPARAMETER3
,      LPARAMETER4
,      LPARAMETER5
,      RETRY_COUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM CLN.M4U_DMD_DOCUMENTS#;

Dependencies

[top of page]

CLN.M4U_DMD_DOCUMENTS# references the following:

SchemaCLN
TableM4U_DMD_DOCUMENTS
CLN.M4U_DMD_DOCUMENTS# is referenced by following:

SchemaAPPS
SynonymM4U_DMD_DOCUMENTS