DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.EDR_SECURE_ELEMENTS_V

Object Details
Object Name: EDR_SECURE_ELEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEDR.EDR_SECURE_ELEMENTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Indexed XML elements defined to be used in creating security rules


[View Source]

Columns
Name Datatype Length Mandatory Comments
ELEMENT_ID NUMBER
Yes Primary key of the indexed xml element
XML_ELEMENT VARCHAR2 (30) Yes XML Element name for indexed xml element
DTD_ROOT_ELEMENT VARCHAR2 (30)
Root element of the DTD specific for the indexed xml element
APPLICATION_ID NUMBER
Yes Application ID of the application owning the indexed xml element
INDEX_SECTION_NAME VARCHAR2 (30) Yes Index section name for indexed xml element
INDEX_TAG VARCHAR2 (64) Yes XML tag used in indexing
DISPLAY_NAME VARCHAR2 (100) Yes User display name of indexed xml element
DESCRIPTION VARCHAR2 (100)
Description of indexed xml element
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.EDR_SECURE_ELEMENTS_V;

Dependencies

[top of page]

APPS.EDR_SECURE_ELEMENTS_V references the following:

SchemaAPPS
SynonymEDR_IDX_XML_ELEMENT_USAGES
ViewEDR_IDX_XML_ELEMENT_VL
APPS.EDR_SECURE_ELEMENTS_V is referenced by following:

SchemaAPPS
Package BodyEDR_POLICY_FUNCTION_PKG - show dependent code