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]

VIEW: APPS.FND_ATTACHMENT_BLK_ENTITIES_VL

Object Details

Object Name:	FND_ATTACHMENT_BLK_ENTITIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_ATTACHMENT_BLK_ENTITIES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FND_ATTACHMENT_BLK_ENTITIES_VL is a view that joins
the document entity information in the current language
from FND_DOCUMENT_ENTITIES with data from
FND_ATTACHMENT_BLK ENTITIES and FND_ATTACHMENT_BLOCKS.
Each row includes a value 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).
Also, an indicator shows whether
the view on which the forms block is based includes
either a column or special code to determine whether or
not attachments exist for the entity. There is also a value
that specifies whether or not attachments to the entity can
be queried from the form block. You can always query,
never query, or query if a condition is true
or false.
Release 10SC only.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
ATTACHMENT_BLK_ENTITY_ID	NUMBER		Yes	Attachment block entity identifier
ATTACHMENT_BLK_ID	NUMBER		Yes	Attachment block identifier
DATA_OBJECT_CODE	VARCHAR2	(30)	Yes	Developer key for FND_DOCUMENT_ENTITIES
USER_ENTITY_NAME	VARCHAR2	(240)	Yes	Username from the entity
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
INDICATOR_IN_VIEW_FLAG	VARCHAR2	(1)	Yes	Indicator of whether or not the view on which the form block 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 form block
INSERT_PERMISSION_TYPE	VARCHAR2	(1)	Yes	Indicates if attachment to this entity can be inserted: only one entity in a block 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
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
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
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
SQL_STATEMENT	VARCHAR2	(2000)		SQL statement fragment that should be added when querying attachments to this entity

Query Text

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


SELECT ROW_ID
,      ATTACHMENT_BLK_ENTITY_ID
,      ATTACHMENT_BLK_ID
,      DATA_OBJECT_CODE
,      USER_ENTITY_NAME
,      DISPLAY_METHOD
,      INCLUDE_IN_INDICATOR_FLAG
,      INDICATOR_IN_VIEW_FLAG
,      QUERY_PERMISSION_TYPE
,      INSERT_PERMISSION_TYPE
,      UPDATE_PERMISSION_TYPE
,      DELETE_PERMISSION_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PK1_FIELD
,      PK2_FIELD
,      PK3_FIELD
,      PK4_FIELD
,      PK5_FIELD
,      CONDITION_FIELD
,      CONDITION_OPERATOR
,      CONDITION_VALUE1
,      CONDITION_VALUE2
,      SQL_STATEMENT
FROM APPS.FND_ATTACHMENT_BLK_ENTITIES_VL;

Dependencies

[top of page]

APPS.FND_ATTACHMENT_BLK_ENTITIES_VL references the following:

APPS: FND_ATTACHMENT_BLK_ENTITIES; FND_DOCUMENT_ENTITIES_VL

APPS.FND_ATTACHMENT_BLK_ENTITIES_VL is not referenced by any database object