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.AMW_FIN_STMNT_KEY_ACCT_V

Object Details

Object Name:	AMW_FIN_STMNT_KEY_ACCT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMW.AMW_FIN_STMNT_KEY_ACCT_V
Subobject Name:
Status:	VALID

View Type

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

Stores a List of Natural/Key Accounts and how it form the hierarchy within a Financial Statement in Oracle ICM

[View Source]

Columns

Name	Datatype	Length	Comments
STATEMENT_GROUP_ID	NUMBER		A Set Id Which Groups all the Statement that are imported in the same import run
FINANCIAL_STATEMENT_ID	NUMBER		The Statement to Which the Account is Associate
NAME	VARCHAR2	(240)	Natural/Key Account Name
OBJECT_TYPE	VARCHAR2	(19)	Type of the Record as this stores multiple Reocords like Statements, Statement items and Accounts
FINANCIAL_ITEM_ID	NUMBER		The Financial Item to Which the Account is Associate
PARENT_FINANCIAL_ITEM_ID	NUMBER		Parent Financial Item to which a child item or Account belongs to
ACCOUNT_GROUP_ID	NUMBER		A Set Id Which Groups all the Accounts that are imported in the same import run
NATURAL_ACCOUNT_ID	NUMBER		The Natural Account
PARENT_NATURAL_ACCOUNT_ID	NUMBER		The Natural Account ID of the Parent Account, if the current record is sub/child account
NATURAL_ACCOUNT_VALUE	VARCHAR2	(150)	The Natural Account Value
SEQUENCE_NUMBER	NUMBER		The Order in which Items in the Statements Need to be displayed in a UI

Query Text

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


SELECT STATEMENT_GROUP_ID
,      FINANCIAL_STATEMENT_ID
,      NAME
,      OBJECT_TYPE
,      FINANCIAL_ITEM_ID
,      PARENT_FINANCIAL_ITEM_ID
,      ACCOUNT_GROUP_ID
,      NATURAL_ACCOUNT_ID
,      PARENT_NATURAL_ACCOUNT_ID
,      NATURAL_ACCOUNT_VALUE
,      SEQUENCE_NUMBER
FROM APPS.AMW_FIN_STMNT_KEY_ACCT_V;

Dependencies

[top of page]

APPS.AMW_FIN_STMNT_KEY_ACCT_V references the following:

APPS: AMW_FIN_ITEMS_KEY_ACC; AMW_FIN_KEY_ACCOUNTS_B; AMW_FIN_KEY_ACCOUNTS_TL; AMW_FIN_STMNT_B; AMW_FIN_STMNT_ITEMS_B; AMW_FIN_STMNT_ITEMS_TL; AMW_FIN_STMNT_TL

APPS.AMW_FIN_STMNT_KEY_ACCT_V is not referenced by any database object