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_ITEMS_ACCOUNT_RANGE_V

Object Details

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

View Type

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

The Account Range for a Row in FSG

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FINANCIAL_STATEMENT_ID	NUMBER	(15)	Yes	Statement ID Mapped to FSG Row Set
FINANCIAL_ITEM_ID	NUMBER		Yes	Statement Item Mapped to FSG Row
SET_OF_BOOKS_ID	NUMBER	(15)		Set of Books Mapped to FSG Row
SEGMENT1_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT1_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT1_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT2_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT2_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT2_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT3_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT3_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT3_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT4_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT4_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT4_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT5_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT5_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT5_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT6_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT6_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT6_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT7_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT7_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT7_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT8_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT8_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT8_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT9_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT9_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT9_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT10_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT10_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT10_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT11_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT11_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT11_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT12_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT12_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT12_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT13_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT13_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT13_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT14_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT14_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT14_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT15_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT15_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT15_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT16_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT16_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT16_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT17_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT17_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT17_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT18_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT18_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT18_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT19_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT19_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT19_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT20_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT20_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT20_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT21_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT21_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT21_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT22_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT22_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT22_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT23_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT23_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT23_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT24_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT24_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT24_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT25_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT25_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT25_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT26_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT26_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT26_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT27_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT27_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT27_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT28_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT28_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT28_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT29_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT29_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT29_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT30_LOW	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT30_HIGH	VARCHAR2	(60)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator
SEGMENT30_TYPE	VARCHAR2	(1)		Segment Value defined for Account Flex Field. See Oracle Financial Statment Generator

Query Text

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


SELECT FINANCIAL_STATEMENT_ID
,      FINANCIAL_ITEM_ID
,      SET_OF_BOOKS_ID
,      SEGMENT1_LOW
,      SEGMENT1_HIGH
,      SEGMENT1_TYPE
,      SEGMENT2_LOW
,      SEGMENT2_HIGH
,      SEGMENT2_TYPE
,      SEGMENT3_LOW
,      SEGMENT3_HIGH
,      SEGMENT3_TYPE
,      SEGMENT4_LOW
,      SEGMENT4_HIGH
,      SEGMENT4_TYPE
,      SEGMENT5_LOW
,      SEGMENT5_HIGH
,      SEGMENT5_TYPE
,      SEGMENT6_LOW
,      SEGMENT6_HIGH
,      SEGMENT6_TYPE
,      SEGMENT7_LOW
,      SEGMENT7_HIGH
,      SEGMENT7_TYPE
,      SEGMENT8_LOW
,      SEGMENT8_HIGH
,      SEGMENT8_TYPE
,      SEGMENT9_LOW
,      SEGMENT9_HIGH
,      SEGMENT9_TYPE
,      SEGMENT10_LOW
,      SEGMENT10_HIGH
,      SEGMENT10_TYPE
,      SEGMENT11_LOW
,      SEGMENT11_HIGH
,      SEGMENT11_TYPE
,      SEGMENT12_LOW
,      SEGMENT12_HIGH
,      SEGMENT12_TYPE
,      SEGMENT13_LOW
,      SEGMENT13_HIGH
,      SEGMENT13_TYPE
,      SEGMENT14_LOW
,      SEGMENT14_HIGH
,      SEGMENT14_TYPE
,      SEGMENT15_LOW
,      SEGMENT15_HIGH
,      SEGMENT15_TYPE
,      SEGMENT16_LOW
,      SEGMENT16_HIGH
,      SEGMENT16_TYPE
,      SEGMENT17_LOW
,      SEGMENT17_HIGH
,      SEGMENT17_TYPE
,      SEGMENT18_LOW
,      SEGMENT18_HIGH
,      SEGMENT18_TYPE
,      SEGMENT19_LOW
,      SEGMENT19_HIGH
,      SEGMENT19_TYPE
,      SEGMENT20_LOW
,      SEGMENT20_HIGH
,      SEGMENT20_TYPE
,      SEGMENT21_LOW
,      SEGMENT21_HIGH
,      SEGMENT21_TYPE
,      SEGMENT22_LOW
,      SEGMENT22_HIGH
,      SEGMENT22_TYPE
,      SEGMENT23_LOW
,      SEGMENT23_HIGH
,      SEGMENT23_TYPE
,      SEGMENT24_LOW
,      SEGMENT24_HIGH
,      SEGMENT24_TYPE
,      SEGMENT25_LOW
,      SEGMENT25_HIGH
,      SEGMENT25_TYPE
,      SEGMENT26_LOW
,      SEGMENT26_HIGH
,      SEGMENT26_TYPE
,      SEGMENT27_LOW
,      SEGMENT27_HIGH
,      SEGMENT27_TYPE
,      SEGMENT28_LOW
,      SEGMENT28_HIGH
,      SEGMENT28_TYPE
,      SEGMENT29_LOW
,      SEGMENT29_HIGH
,      SEGMENT29_TYPE
,      SEGMENT30_LOW
,      SEGMENT30_HIGH
,      SEGMENT30_TYPE
FROM APPS.AMW_FIN_ITEMS_ACCOUNT_RANGE_V;

Dependencies

[top of page]

APPS.AMW_FIN_ITEMS_ACCOUNT_RANGE_V references the following:

APPS: FND_DATA_SECURITY - show dependent code; FND_GLOBAL - show dependent code; RG_REPORT_AXES_V; RG_REPORT_AXIS_CONTENTS; RG_REPORT_AXIS_SETS_V

APPS.AMW_FIN_ITEMS_ACCOUNT_RANGE_V is referenced by following:

APPS: AMW_IMPORT_STMNTS_ACCS_PKG - show dependent code