VIEW: APPS.EDR_XMLMAP_ELEMENTS_V

Source

View Text - Preformatted

SELECT b.root_element, a.map_code, d.attribute_name xml_element from ecx_mappings a, ecx_objects b, ecx_object_levels c, ecx_object_attributes d WHERE b.object_type = 'DTD' and c.object_id = b.object_id and d.objectlevel_id = c.objectlevel_id and d.attribute_type = 1 and d.PARENT_ATTRIBUTE_ID <> 0 and a.map_id = b.map_id and a.map_id = c.map_id and a.map_id = d.map_id

View Text - HTML Formatted

SELECT B.ROOT_ELEMENT
, A.MAP_CODE
, D.ATTRIBUTE_NAME XML_ELEMENT
FROM ECX_MAPPINGS A
, ECX_OBJECTS B
, ECX_OBJECT_LEVELS C
, ECX_OBJECT_ATTRIBUTES D
WHERE B.OBJECT_TYPE = 'DTD'
AND C.OBJECT_ID = B.OBJECT_ID
AND D.OBJECTLEVEL_ID = C.OBJECTLEVEL_ID
AND D.ATTRIBUTE_TYPE = 1
AND D.PARENT_ATTRIBUTE_ID <> 0
AND A.MAP_ID = B.MAP_ID
AND A.MAP_ID = C.MAP_ID
AND A.MAP_ID = D.MAP_ID