[Home] [Help] [Dependency Information]
Object Name: | M4U_DMD_DOCUMENTS |
---|---|
Object Type: | TABLE |
Owner: | CLN |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
CLN.M4U_DMD_DOCUMENTS does not reference any database object
CLN.M4U_DMD_DOCUMENTS is referenced by following:
|
|
|