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

Object Details

Object Name:	FV_BE_XLA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_BE_XLA_V
Subobject Name:
Status:	VALID

View Type

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

The main purpose of this view is used for reporting BE transactions in SLA. The information acquired from this view is displayed in Subledger Accounting reports and inquiries

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_ID	NUMBER	(15)	Yes	Unique system generated identifier from FV_BE_TRX_HDRS
DOC_NUMBER	VARCHAR2	(30)	Yes	Document number
FUND_VALUE	VARCHAR2	(25)	Yes	Balancing segment value
TRANSACTION_DATE	DATE		Yes	Transaction date
BE_SOURCE	VARCHAR2	(25)		The Source of the transaction. Currently it is populated with "RPR" for Reprogramming transactions. Can be used in future for getting transactions from other feeder systems.
TREASURY_SYMBOL	VARCHAR2	(35)	Yes	Treasury symbol
BUDGET_LEVEL	VARCHAR2	(15)	Yes	Budget level description

Query Text

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


SELECT DOC_ID
,      DOC_NUMBER
,      FUND_VALUE
,      TRANSACTION_DATE
,      BE_SOURCE
,      TREASURY_SYMBOL
,      BUDGET_LEVEL
FROM APPS.FV_BE_XLA_V;

Dependencies

[top of page]

APPS.FV_BE_XLA_V references the following:

APPS: FV_BE_TRX_HDRS; FV_BUDGET_LEVELS; FV_TREASURY_SYMBOLS

APPS.FV_BE_XLA_V is not referenced by any database object