VIEW: APPS.EDR_SECURE_ELEMENTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'