[Home] [Help] [Dependency Information]
Object Name: | FND_ATTACHMENT_BLK_ENTITIES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_ATTACHMENT_BLK_ENTITIES |
Subobject Name: | |
Status: | VALID |
FND_ATTACHMENT_BLK_ENTITIES stores information
regarding which attachments can be viewed,
modified or deleted from a specific window region.
It includes data that defines how to display
attachments to an entity (DISPLAY_METHOD, where
"M" shows attachments in the main window and
"R" shows attachments in the related window)
and a flag that indicates whether or not the
attachment toolbar icon should be set when
attachments exist for an entity
(INCLUDE_IN_INDICATOR_FLAG).
Each row also contains an indicator of whether
the view on which the window region is
based includes either a column or special code
to determine whether or not attachments exist
for the entity. (INDICATOR_IN_VIEW_FLAG, where Y
indicates a column or special code exists in the window region
to resolve the existence of attachments and N indicates that
no special column or code exists and standard attachment
functionality is used.)
There are also values that specify whether or not attachments
to the entity can be queried, inserted, updated or deleted
from the window region. These privileges can be allowed always,
never, or only if a condition is true or false.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_ATTACHMENT_BLK_ENTITIES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
ATTACHMENT_BLK_ENTITY_ID
ZD_EDITION_NAME |
FND_ATTACHMENT_BLK_ENTITIES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
ATTACHMENT_BLK_ID
DATA_OBJECT_CODE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTACHMENT_BLK_ENTITY_ID | NUMBER | Yes | Attachment region entity identifier | |
ATTACHMENT_BLK_ID | NUMBER | Yes | Attachment region identifier | |
DISPLAY_METHOD | VARCHAR2 | (1) | Yes | Indicator of how to display attachments to this entity |
INCLUDE_IN_INDICATOR_FLAG | VARCHAR2 | (1) | Yes | Indicator of whether or not the attachment toolbar is set |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PK1_FIELD | VARCHAR2 | (61) | Part of the entity's primary key | |
PK2_FIELD | VARCHAR2 | (61) | Part of the entity's primary key | |
PK3_FIELD | VARCHAR2 | (61) | Part of the entity's primary key | |
PK4_FIELD | VARCHAR2 | (61) | Part of the entity's primary key | |
PK5_FIELD | VARCHAR2 | (61) | Part of the entity's primary key | |
SQL_STATEMENT | VARCHAR2 | (2000) | SQL statement fragment that should be added when querying attachments to this entity | |
DATA_OBJECT_CODE | VARCHAR2 | (30) | Yes | Developer key for FND_DOCUMENT_ENTITIES |
INDICATOR_IN_VIEW_FLAG | VARCHAR2 | (1) | Yes | Indicator of whether or not the view on which the window region is based includes either a column or special code to determine whether or not attachments exist for the entity |
QUERY_PERMISSION_TYPE | VARCHAR2 | (1) | Yes | Indicates if attachment to this entity can be queried from the window region |
INSERT_PERMISSION_TYPE | VARCHAR2 | (1) | Yes | Indicates if attachment to this entity can be inserted: only one entity in a region can allow inserts |
UPDATE_PERMISSION_TYPE | VARCHAR2 | (1) | Yes | Indicates if attachment to this entity can be updated |
DELETE_PERMISSION_TYPE | VARCHAR2 | (1) | Yes | Indicates if attachment to this entity can be deleted |
CONDITION_FIELD | VARCHAR2 | (61) | Field whose value should be evaluated using the condition operator and condition value(s) | |
CONDITION_OPERATOR | NUMBER | Condition that should be used for evaluation (=,<>,>=,<=,<,>,NOT NULL, NULL, BETWEEN, OUTSIDE) | ||
CONDITION_VALUE1 | VARCHAR2 | (100) | Value that contents of CONDITION_FIELD should be evaluated against using condition operator | |
CONDITION_VALUE2 | VARCHAR2 | (100) | Secondary value that contents of CONDITION_FIELD should be evaluated against when CONDITION_OPERATOR is BETWEEN or OUTSIDE | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ATTACHMENT_BLK_ENTITY_ID
, ATTACHMENT_BLK_ID
, DISPLAY_METHOD
, INCLUDE_IN_INDICATOR_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PK1_FIELD
, PK2_FIELD
, PK3_FIELD
, PK4_FIELD
, PK5_FIELD
, SQL_STATEMENT
, DATA_OBJECT_CODE
, INDICATOR_IN_VIEW_FLAG
, QUERY_PERMISSION_TYPE
, INSERT_PERMISSION_TYPE
, UPDATE_PERMISSION_TYPE
, DELETE_PERMISSION_TYPE
, CONDITION_FIELD
, CONDITION_OPERATOR
, CONDITION_VALUE1
, CONDITION_VALUE2
, ZD_EDITION_NAME
FROM APPLSYS.FND_ATTACHMENT_BLK_ENTITIES;
APPLSYS.FND_ATTACHMENT_BLK_ENTITIES does not reference any database object
APPLSYS.FND_ATTACHMENT_BLK_ENTITIES is referenced by following:
|
|
|