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

TABLE: DOM.DOM_FOLDER_FILE_MEMBERSHIPS

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


Stores the folder and file memberships


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REPOSITORY_ID NUMBER

Repository identifier
REPOSITORY_ITEM_ID NUMBER (15) Yes Repository item id
REPOSITORY_ITEM_TYPE VARCHAR2 (15)
Type of the item
ENTITY_NAME VARCHAR2 (30) Yes Entity name
PK1_VALUE VARCHAR2 (255) Yes Primary key of the entity
PK2_VALUE VARCHAR2 (255)
Primary key of the entity
PK3_VALUE VARCHAR2 (255)
Primary key of the entity
PK4_VALUE VARCHAR2 (255)
Primary key of the entity
PK5_VALUE VARCHAR2 (255)
Primary key of the entity
PARTY_TYPE VARCHAR2 (15)
Party type
PARTY_ID NUMBER (15)
Party identifier
EBS_ROLE VARCHAR2 (30)
EBS Role
OFO_ROLE VARCHAR2 (30)
OFO role
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_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard WHO column
Query Text

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


SELECT REPOSITORY_ID
,      REPOSITORY_ITEM_ID
,      REPOSITORY_ITEM_TYPE
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PARTY_TYPE
,      PARTY_ID
,      EBS_ROLE
,      OFO_ROLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM DOM.DOM_FOLDER_FILE_MEMBERSHIPS;

Dependencies

[top of page]

DOM.DOM_FOLDER_FILE_MEMBERSHIPS does not reference any database object

DOM.DOM_FOLDER_FILE_MEMBERSHIPS is referenced by following:

SchemaAPPS
SynonymDOM_FOLDER_FILE_MEMBERSHIPS