[Home] [Help] [Dependency Information]
Object Name: | XNP_MSG_ELEMENTS |
---|---|
Object Type: | TABLE |
Owner: | XNP |
FND Design Data: | XNP.XNP_MSG_ELEMENTS |
Subobject Name: | |
Status: | VALID |
XNP_MSG_ELEMENTS stores a lookup of all elements in the message. A message is a collection of elements or attributes
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XNP_MSG_ELEMENTS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | MSG_ELEMENT_ID |
XNP_MSG_ELEMENTS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
NAME
MSG_CODE |
XNP_MSG_ELEMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MSG_CODE
PARAMETER_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSG_ELEMENT_ID | NUMBER | Yes | Message element identifier | |
MSG_CODE | VARCHAR2 | (20) | Yes | The message to which the element belongs |
NAME | VARCHAR2 | (40) | Yes | Name of the element |
MANDATORY_FLAG | VARCHAR2 | (1) | Yes | Flag to Indicate whether the element is mandatory or optional |
PARAMETER_FLAG | VARCHAR2 | (1) | Yes | Indicates if the element is a parameter in the generated procedure |
ELEMENT_DATATYPE | VARCHAR2 | (80) | Data type of the message element | |
ELEMENT_DEFAULT_VALUE | VARCHAR2 | (80) | Default values for message element parameters | |
DATA_LENGTH | NUMBER | Maximum allowed length for the data | ||
PARAMETER_SEQUENCE | NUMBER | Sequence in which parameters will appear in all the generated procedures | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT MSG_ELEMENT_ID
, MSG_CODE
, NAME
, MANDATORY_FLAG
, PARAMETER_FLAG
, ELEMENT_DATATYPE
, ELEMENT_DEFAULT_VALUE
, DATA_LENGTH
, PARAMETER_SEQUENCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_MSG_ELEMENTS;
XNP.XNP_MSG_ELEMENTS does not reference any database object
XNP.XNP_MSG_ELEMENTS is referenced by following:
|
|
|