View: EDR_SECURE_ELEMENTS_V

Product:	EDR - E-Records
Description:	Indexed XML elements defined to be used in creating security rules
Implementation/DBA Data:	APPS.EDR_SECURE_ELEMENTS_V

View Text

SELECT A.ELEMENT_ID
, A.XML_ELEMENT
, A.DTD_ROOT_ELEMENT
, A.APPLICATION_ID
, A.INDEX_SECTION_NAME
, A.INDEX_TAG
, A.DISPLAY_NAME
, A.DESCRIPTION
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.LAST_UPDATE_DATE
FROM EDR_IDX_XML_ELEMENT_VL A
, EDR_IDX_XML_ELEMENT_USAGES B
WHERE A.STATUS = 'I'
AND B.ELEMENT_ID = A.ELEMENT_ID
AND B.ELEMENT_USAGE = 'S'

Columns