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_FUNCTIONS

Object Details

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

FND_ATTACHMENT_FUNCTIONS stores information about
those forms and form functions for which the attachment
feature is enabled.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_ATTACHMENT_FUNCTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	ATTACHMENT_FUNCTION_ID ZD_EDITION_NAME
FND_ATTACHMENT_FUNCTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FUNCTION_NAME APPLICATION_ID
FND_ATTACHMENT_FUNCTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	APPLICATION_ID FUNCTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTACHMENT_FUNCTION_ID	NUMBER		Yes	Attachment function identifier
FUNCTION_TYPE	VARCHAR2	(1)	Yes	Function type
FUNCTION_ID	NUMBER		Yes	Foreign key to either FND_FORM_FUNCTIONS of FND_FORM, depending on the value of FUNCTION_TYPE
FUNCTION_NAME	VARCHAR2	(30)	Yes	Developer name for the function
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
APPLICATION_ID	NUMBER			Application identifier
SESSION_CONTEXT_FIELD	VARCHAR2	(61)		Form field that holds the data that should be used as session context in the attachment form title
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether or not attachment functionality is enabled for the form or form function
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ATTACHMENT_FUNCTION_ID
,      FUNCTION_TYPE
,      FUNCTION_ID
,      FUNCTION_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      SESSION_CONTEXT_FIELD
,      ENABLED_FLAG
,      ZD_EDITION_NAME
FROM APPLSYS.FND_ATTACHMENT_FUNCTIONS;

Dependencies

[top of page]

APPLSYS.FND_ATTACHMENT_FUNCTIONS does not reference any database object

APPLSYS.FND_ATTACHMENT_FUNCTIONS is referenced by following:

APPLSYS: FND_ATTACHMENT_FUNCTIONS#