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

VIEW: APPS.AMW_FINANCIAL_ITEMS_V

Object Details
Object Name: AMW_FINANCIAL_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_FINANCIAL_ITEMS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


A View on top of Oracle Financial Statement Generator Views to get All Row (Financial Items) Definitions


[View Source]

Columns
Name Datatype Length Mandatory Comments
FINANCIAL_STATEMENT_ID NUMBER (15) Yes Financial Statement ID (Row Set Id from FSG)
FINANCIAL_ITEM_ID NUMBER
Yes Financial Item ID (Row Id from FSG)
NAME VARCHAR2 (30)
Financial Item Name (Row Name from FSG)
DESCRIPTION VARCHAR2 (240)
Statement Description (Row Desc. from FSG)
DISPLAY_FLAG VARCHAR2 (1)
Whether thir Row is defined as a display row in Oracle Financial Statement Generator
PARENT_FINANCIAL_ITEM_ID VARCHAR2 (0)
Parent Financial Item
Query Text

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


SELECT FINANCIAL_STATEMENT_ID
,      FINANCIAL_ITEM_ID
,      NAME
,      DESCRIPTION
,      DISPLAY_FLAG
,      PARENT_FINANCIAL_ITEM_ID
FROM APPS.AMW_FINANCIAL_ITEMS_V;

Dependencies

[top of page]

APPS.AMW_FINANCIAL_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATA_SECURITY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewRG_REPORT_AXES_V
ViewRG_REPORT_AXIS_SETS_V
APPS.AMW_FINANCIAL_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyAMW_IMPORT_STMNTS_ACCS_PKG - show dependent code