eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_ATTACHMENT_BLK_ENTITIES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_ATTACHMENT_BLK_ENTITIES_U1	NORMAL	UNIQUE	APPS_TS_SEED	ATTACHMENT_BLK_ENTITY_ID
FND_ATTACHMENT_BLK_ENTITIES_U2	NORMAL	UNIQUE	APPS_TS_SEED	ATTACHMENT_BLK_ID DATA_OBJECT_CODE

Columns

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

Query Text

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
FROM APPLSYS.FND_ATTACHMENT_BLK_ENTITIES;

Dependencies

[top of page]

APPLSYS.FND_ATTACHMENT_BLK_ENTITIES does not reference any database object

APPLSYS.FND_ATTACHMENT_BLK_ENTITIES is referenced by following:

APPS: FND_ATTACHMENT_BLK_ENTITIES