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]

VIEW: APPS.FII_ALL_NATURAL_ACCOUNTS_V

Object Details

Object Name:	FII_ALL_NATURAL_ACCOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_ALL_NATURAL_ACCOUNTS_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

List of all natural accounts from the master value set.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STRUCT_CODE	VARCHAR2	(30)	Yes	Key flexfield structure code
FLEX_VALUE	VARCHAR2	(150)	Yes	Flexfield segment value
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT STRUCT_CODE
,      FLEX_VALUE
,      DESCRIPTION
FROM APPS.FII_ALL_NATURAL_ACCOUNTS_V;

Dependencies

[top of page]

APPS.FII_ALL_NATURAL_ACCOUNTS_V references the following:

APPS: FII_SLG_ASSIGNMENTS; FII_SOURCE_LEDGER_GROUPS; FND_FLEX_VALUES; FND_FLEX_VALUES_TL; FND_ID_FLEX_SEGMENTS; FND_ID_FLEX_STRUCTURES; FND_SEGMENT_ATTRIBUTE_VALUES

APPS.FII_ALL_NATURAL_ACCOUNTS_V is not referenced by any database object