DBA Data[Home] [Help]

VIEW: WMS.WMS_MSG_COMPONENTS#

Source

View Text - Preformatted

select TEMPLATE_ID TEMPLATE_ID, COMPONENT_ID COMPONENT_ID, SEQUENCE_ID SEQUENCE_ID, COMPONENT COMPONENT, COMPONENT_LENGTH COMPONENT_LENGTH, LEFT_OR_RIGHT_PADDED LEFT_OR_RIGHT_PADDED, PADDING_CHARACTER PADDING_CHARACTER, START_COMPONENT_DELIMITER START_COMPONENT_DELIMITER, END_COMPONENT_DELIMITER END_COMPONENT_DELIMITER, XML_TAG_NAME XML_TAG_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "WMS"."WMS_MSG_COMPONENTS"
View Text - HTML Formatted

SELECT TEMPLATE_ID TEMPLATE_ID
, COMPONENT_ID COMPONENT_ID
, SEQUENCE_ID SEQUENCE_ID
, COMPONENT COMPONENT
, COMPONENT_LENGTH COMPONENT_LENGTH
, LEFT_OR_RIGHT_PADDED LEFT_OR_RIGHT_PADDED
, PADDING_CHARACTER PADDING_CHARACTER
, START_COMPONENT_DELIMITER START_COMPONENT_DELIMITER
, END_COMPONENT_DELIMITER END_COMPONENT_DELIMITER
, XML_TAG_NAME XML_TAG_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "WMS"."WMS_MSG_COMPONENTS"