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

TABLE: DOM.DOM_ATTACHMENT_ENTITIES

Object Details
Object Name: DOM_ATTACHMENT_ENTITIES
Object Type: TABLE
Owner: DOM
FND Design Data: TableDOM.DOM_ATTACHMENT_ENTITIES
Subobject Name:
Status: VALID


This table stores the security and where-used related apis/sqls for the business entity.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DOM_ATTACHMENT_ENTITIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_NAME
Columns
Name Datatype Length Mandatory Comments
ENTITY_NAME VARCHAR2 (30) Yes Business entity Identifier
GET_ROLE_NAMES_SQL VARCHAR2 (2000)
Query that returns the roles associated to the business entity
GET_USERS_PLSQL_API VARCHAR2 (255)
Additional security API for users
GET_ROLE_USERS_PLSQL_API VARCHAR2 (255)
Additional security API for user roles
GET_ATTACH_ACCESS_PLSQL_API VARCHAR2 (255)
API that returns the access on the given attachment for this user.
GET_INSTANCE_NAME_SQL VARCHAR2 (2000)
Business Entity Instance name
INSTANCE_DETAIL_PAGE_URL VARCHAR2 (2000)
Business Entity detail page URL
INSTANCE_WHEREUSED_PAGE_URL VARCHAR2 (2000)
Business Entity where-used page URL
GET_INSTANCE_DESCRIPTION_SQL VARCHAR2 (2000)
Query that returns the description of the associated business entity
Query Text

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


SELECT ENTITY_NAME
,      GET_ROLE_NAMES_SQL
,      GET_USERS_PLSQL_API
,      GET_ROLE_USERS_PLSQL_API
,      GET_ATTACH_ACCESS_PLSQL_API
,      GET_INSTANCE_NAME_SQL
,      INSTANCE_DETAIL_PAGE_URL
,      INSTANCE_WHEREUSED_PAGE_URL
,      GET_INSTANCE_DESCRIPTION_SQL
FROM DOM.DOM_ATTACHMENT_ENTITIES;

Dependencies

[top of page]

DOM.DOM_ATTACHMENT_ENTITIES does not reference any database object

DOM.DOM_ATTACHMENT_ENTITIES is referenced by following:

SchemaAPPS
SynonymDOM_ATTACHMENT_ENTITIES