[Home] [Help]
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
Name |
ELEMENT_ID |
XML_ELEMENT |
DTD_ROOT_ELEMENT |
APPLICATION_ID |
INDEX_SECTION_NAME |
INDEX_TAG |
DISPLAY_NAME |
DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |