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


VIEW: APPS.FND_FORM_VL

Object Details
Object Name: FND_FORM_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_FORM_VL
Subobject Name:
Status: VALID

View Type

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


FND_FORM_VL is a view that joins the translated, language specific
values from FND_FORM_TL with the non-displayed data from
FND_FORM to form complete form entities. Oracle Application
Object Library uses this view to display information in languages
installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
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
USER_FORM_NAME VARCHAR2 (80) Yes Form title
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT ROW_ID
,      APPLICATION_ID
,      FORM_ID
,      FORM_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AUDIT_ENABLED_FLAG
,      USER_FORM_NAME
,      DESCRIPTION
FROM APPS.FND_FORM_VL;

Dependencies

[top of page]

APPS.FND_FORM_VL references the following:

SchemaAPPS
SynonymFND_FORM
SynonymFND_FORM_TL
APPS.FND_FORM_VL is referenced by following:

SchemaAPPS
Package BodyFND_ATTACHMENT_UTIL_PKG - show dependent code
ViewHR_ADI_LOV_FORM_NAME
Package BodyHR_ATTACHMENTS_LOADER - show dependent code
ViewHR_NAVIGATION_UNITS_V
Package BodyPAY_CUST_RESTRICT_PKG - show dependent code