eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CLN.M4U_DMD_DOCUMENTS

Object Details

Object Name:	M4U_DMD_DOCUMENTS
Object Type:	TABLE
Owner:	CLN
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
M4U_DMD_DOCUMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_ID
M4U_DMD_DOCUMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORIG_DOC_ID
M4U_DMD_DOCUMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MSG_ID
M4U_DMD_DOCUMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REF_DOC_ID

Columns

Name	Datatype	Length
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 does not reference any database object

CLN.M4U_DMD_DOCUMENTS is referenced by following:

APPS: M4U_DMD_DOCUMENTS