Skip to content

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

VIEW: APPS.FRM_DIRECTORY_VL

Object Details
Object Name: FRM_DIRECTORY_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFRM.FRM_DIRECTORY_VL
Subobject Name:
Status: VALID

View Type

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


FRM_DIRECTORY_VL is a standard translation view over the FRM_DIRECTORY entity.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Entity Identifier across all applications
DIRECTORY_ID NUMBER (15) Yes Entity Identifier across all applications
PARENT_ID NUMBER (15)
The next higher level in the Report Manager directory structure, null if the entry is the root directory.
SEQUENCE_NUMBER NUMBER (15) Yes The order of the directory within the parent directory.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Applications Standard column for a stateless environment.
USER_NAME VARCHAR2 (240)
User tanslatable column for this table.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
END_DATE DATE

End Date for directory entity
ARCHIVED_FLAG VARCHAR2 (1)
Flag to determine archive status for entity
Query Text

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


SELECT ROW_ID
,      DIRECTORY_ID
,      PARENT_ID
,      SEQUENCE_NUMBER
,      OBJECT_VERSION_NUMBER
,      USER_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      END_DATE
,      ARCHIVED_FLAG
FROM APPS.FRM_DIRECTORY_VL;

Dependencies

[top of page]

APPS.FRM_DIRECTORY_VL references the following:

SchemaAPPS
SynonymFRM_DIRECTORY_B
SynonymFRM_DIRECTORY_TL
APPS.FRM_DIRECTORY_VL is referenced by following:

SchemaAPPS
Package BodyFRM_REPOSITORY_MAINTENANCE - show dependent code
Package BodyFRM_SECURITY_PKG - show dependent code