[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.FND_ATTACHMENT_BLK_ENTITIES_VL is not referenced by any database object
|
|
|