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

TABLE: APPLSYS.FND_FORM

Object Details
Object Name: FND_FORM
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_FORM
Subobject Name:
Status: VALID


FND_FORM stores information about your registered application
forms. Each row includes names (the actual SQL*Forms form
name, and the EasyForm form title) and a
description of the form. Each row also includes a flag that
indicates whether this form is included in the AuditTrail audit
set. You need one row for each form in each application. Oracle
Application Object Library uses this information for the Regression
Tester, on-line Help, EasyForm, Zoom, AuditTrail and other
purposes.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_FORM_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnFORM_ID
FND_FORM_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFORM_NAME
ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
FORM_ID NUMBER
Yes Form identifier
FORM_NAME VARCHAR2 (30) Yes Form name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
AUDIT_ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate if this form is included in the AuditTrial audit set
Query Text

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


SELECT APPLICATION_ID
,      FORM_ID
,      FORM_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AUDIT_ENABLED_FLAG
FROM APPLSYS.FND_FORM;

Dependencies

[top of page]

APPLSYS.FND_FORM does not reference any database object

APPLSYS.FND_FORM is referenced by following:

SchemaAPPS
SynonymFND_FORM