View: EDR_XMLMAP_ELEMENTS_V

Product:	EDR - E-Records
Description:	View containing X-ref of XML element and dtd root elements
Implementation/DBA Data:	APPS.EDR_XMLMAP_ELEMENTS_V

View Text

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

Columns