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: XNP.XNP_MSG_STRUCTURES

Object Details

Object Name:	XNP_MSG_STRUCTURES
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_MSG_STRUCTURES
Subobject Name:
Status:	VALID

XNP_MSG_STRUCTURES contains the structural relationship or hierarchy of all elements in the Extensible Markup Language (XML) message. XML is a markup language for documents containing structured information. The information in this table is used to generate the SEND(), PUBLISH(), VALIDATE(), PROCESS() and DEFAULT_PROCESS() procedures. The information in this table can also be used to generate the Document Type Definition (DTD). DTD is a series of definitions for element types, attributes, entities and notations.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_MSG_STRUCTURES_U1	NORMAL	UNIQUE	APPS_TS_SEED	STRUCTURE_ID
XNP_MSG_STRUCTURES_U2	NORMAL	UNIQUE	APPS_TS_SEED	MSG_CODE CHILD_ELEMENT_ID PARENT_ELEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STRUCTURE_ID	NUMBER		Yes	Message structure identifier
PARENT_ELEMENT_ID	NUMBER		Yes	Parent element identifier for the element
CHILD_ELEMENT_ID	NUMBER		Yes	Child element identifier
MSG_CODE	VARCHAR2	(20)	Yes	Message that owns this structure
SEQUENCE_IN_PARENT	NUMBER			Sequence where the child element should occur in the parent element
CARDINALITY	VARCHAR2	(20)		Indicates the cardinality of the element in the message
DATA_SOURCE	VARCHAR2	(1996)		Data source for the message element. The actual SQL statement or the name of the procedure to be executed in order to retrieve data for this message element
DATA_SOURCE_TYPE	VARCHAR2	(10)		Data source type for the message element. Data Source could be SQL Statement or a Procedure.
DATA_SOURCE_REFERENCE	VARCHAR2	(1996)		Defines the reference for the message element for which a SQL string is defined as the data source, with the aliases in the SELECT list
ELEMENT_POSITION	NUMBER			Position of the element in the record layout of the FILE
ELEMENT_ALIGNMENT	VARCHAR2	(10)		Alignment of element - This column will not be used in the current release and is not supported
PADDING	VARCHAR2	(10)		Padding of value - This column will not be used in the current release and is not supported
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT STRUCTURE_ID
,      PARENT_ELEMENT_ID
,      CHILD_ELEMENT_ID
,      MSG_CODE
,      SEQUENCE_IN_PARENT
,      CARDINALITY
,      DATA_SOURCE
,      DATA_SOURCE_TYPE
,      DATA_SOURCE_REFERENCE
,      ELEMENT_POSITION
,      ELEMENT_ALIGNMENT
,      PADDING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_MSG_STRUCTURES;

Dependencies

[top of page]

XNP.XNP_MSG_STRUCTURES does not reference any database object

XNP.XNP_MSG_STRUCTURES is referenced by following:

APPS: XNP_MSG_STRUCTURES