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_BLOCKS

Object Details

Object Name:	FND_ATTACHMENT_BLOCKS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_ATTACHMENT_BLOCKS
Subobject Name:
Status:	VALID

FND_ATTACHMENT_BLOCKS stores information about
those window regions for which the attachment feature is
enabled. Each row contains a flag that indicates
attachments invoked in a region should be either
query-only or able to be modified according to the
privileges associated with the
FND_ATTACHMENT_BLK_ENTITY record (QUERY_FLAG).
There is also a value to define the method of security used
for the document (SECURITY_TYPE, where 1=Organization,
2=Set of Books, 3=Business unit, 4=None).

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_ATTACHMENT_BLOCKS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ATTACHMENT_BLK_ID
FND_ATTACHMENT_BLOCKS_U2	NORMAL	UNIQUE	APPS_TS_SEED	ATTACHMENT_FUNCTION_ID BLOCK_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ATTACHMENT_BLK_ID	NUMBER		Yes	Attachment region identifier
ATTACHMENT_FUNCTION_ID	NUMBER		Yes	Attachment function identifier
BLOCK_NAME	VARCHAR2	(30)	Yes	Name of the window region
QUERY_FLAG	VARCHAR2	(1)	Yes	Flag regarding attachments invoked from the region (see table description)
SECURITY_TYPE	NUMBER		Yes	Method of security used for the document
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
ORG_CONTEXT_FIELD	VARCHAR2	(61)		Form field which holds the ORGANIZATION_ID when running in the context of organization security
SET_OF_BOOKS_CONTEXT_FIELD	VARCHAR2	(61)		Form field which holds the SET_OF_BOOKS_ID when running in the context of set of books security
BUSINESS_UNIT_CONTEXT_FIELD	VARCHAR2	(61)		Form field which holds the BUSINESS_UNIT_ID when running in the context of business unit security
CONTEXT1_FIELD	VARCHAR2	(61)		Form field which holds the data that should be used for the first context portion of the attachment form title
CONTEXT2_FIELD	VARCHAR2	(61)		Form field which holds the data that should be used for the second context portion of the attachment form title
CONTEXT3_FIELD	VARCHAR2	(61)		Form field which holds the data that should be used for the third context portion of the attachment form title

Query Text

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


SELECT ATTACHMENT_BLK_ID
,      ATTACHMENT_FUNCTION_ID
,      BLOCK_NAME
,      QUERY_FLAG
,      SECURITY_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_CONTEXT_FIELD
,      SET_OF_BOOKS_CONTEXT_FIELD
,      BUSINESS_UNIT_CONTEXT_FIELD
,      CONTEXT1_FIELD
,      CONTEXT2_FIELD
,      CONTEXT3_FIELD
FROM APPLSYS.FND_ATTACHMENT_BLOCKS;

Dependencies

[top of page]

APPLSYS.FND_ATTACHMENT_BLOCKS does not reference any database object

APPLSYS.FND_ATTACHMENT_BLOCKS is referenced by following:

APPS: FND_ATTACHMENT_BLOCKS