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_BA_FD_HDR_V

Object Details

Object Name:	FV_BE_BA_FD_HDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_BE_BA_FD_HDR_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 as Transaction extract headers for SLA to identify the sources

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(15)		Sub ledger account event identifier
DOC_ID	NUMBER	(15)	Yes	Unique system generated identifier in FV_BE_TRX_DTLS
DOC_NUMBER	VARCHAR2	(30)	Yes	Document number
REVISION_NUM	NUMBER	(4)	Yes	Document revision number
QUARTER_NUM	NUMBER	(15)		Quarter number
TREASURY_SYMBOL_ID	NUMBER	(15)	Yes	Treasury symbol identifier
FUND_VALUE	VARCHAR2	(25)	Yes	Balancing segment value
BUDGET_LEVEL_ID	NUMBER	(15)	Yes	Budget level identifier
TRANSACTION_DATE	DATE		Yes	Transaction date
DISTRIBUTION_ACCOUNT	NUMBER			Distribution account code combination identifier
GL_DATE	DATE		Yes	General ledger date
HEADER_SEGMENT1	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT2	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT3	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT4	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT5	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT6	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT7	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT8	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT9	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT10	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT11	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT12	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT13	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT14	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT15	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT16	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT17	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT18	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT19	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT20	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT21	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT22	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT23	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT24	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT25	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT26	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT27	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT28	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT29	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
HEADER_SEGMENT30	VARCHAR2	(25)		Accounting flexfield segment from FV_BE_TRX_HDRS
APPROVAL_ID	NUMBER	(15)		The approval process identifier. On pressing the approve button on the budget entry forms this will be set to a unique number
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.
APPROVED_BY_USER_ID	NUMBER	(15)		User identifier of the approver. Foreign key to FV_BUDGET_USER_DTL
OLD_DOC_NUMBER	VARCHAR2	(30)		For upgrade customers this field will store the document number from fv_budgetary_transactions table
LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
PARENT_DOC_ID	NUMBER	(15)		Parent document identifier
HEADER_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment from FV_BE_TRX_HDRS
HEADER_ATTR_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column from FV_BE_TRX_HDRS
BU_GROUP_ID	NUMBER	(15)	Yes	Budget security group identifier of the User
DOC_STATUS	VARCHAR2	(25)	Yes	Status of the document
TREASURY_SYMBOL	VARCHAR2	(35)	Yes	Treasury Symbol of fund value
TIME_FRAME	VARCHAR2	(25)	Yes	Fund time frame
ESTABLISHED_FISCAL_YR	NUMBER	(15)		Established fiscal year of the fund
EXPIRATION_DATE	DATE			Fund expiration date
CANCELLATION_DATE	DATE			Fund cancellation date
RESOURCE_TYPE	VARCHAR2	(80)		Resource type used for year end processing
FUND_CATEGORY	VARCHAR2	(1)	Yes	Fund category
BEA_CATEGORY	VARCHAR2	(25)		Budget enforcement act category

Query Text

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


SELECT EVENT_ID
,      DOC_ID
,      DOC_NUMBER
,      REVISION_NUM
,      QUARTER_NUM
,      TREASURY_SYMBOL_ID
,      FUND_VALUE
,      BUDGET_LEVEL_ID
,      TRANSACTION_DATE
,      DISTRIBUTION_ACCOUNT
,      GL_DATE
,      HEADER_SEGMENT1
,      HEADER_SEGMENT2
,      HEADER_SEGMENT3
,      HEADER_SEGMENT4
,      HEADER_SEGMENT5
,      HEADER_SEGMENT6
,      HEADER_SEGMENT7
,      HEADER_SEGMENT8
,      HEADER_SEGMENT9
,      HEADER_SEGMENT10
,      HEADER_SEGMENT11
,      HEADER_SEGMENT12
,      HEADER_SEGMENT13
,      HEADER_SEGMENT14
,      HEADER_SEGMENT15
,      HEADER_SEGMENT16
,      HEADER_SEGMENT17
,      HEADER_SEGMENT18
,      HEADER_SEGMENT19
,      HEADER_SEGMENT20
,      HEADER_SEGMENT21
,      HEADER_SEGMENT22
,      HEADER_SEGMENT23
,      HEADER_SEGMENT24
,      HEADER_SEGMENT25
,      HEADER_SEGMENT26
,      HEADER_SEGMENT27
,      HEADER_SEGMENT28
,      HEADER_SEGMENT29
,      HEADER_SEGMENT30
,      APPROVAL_ID
,      SOURCE
,      APPROVED_BY_USER_ID
,      OLD_DOC_NUMBER
,      LEDGER_ID
,      CURRENCY_CODE
,      PARENT_DOC_ID
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_ATTRIBUTE11
,      HEADER_ATTRIBUTE12
,      HEADER_ATTRIBUTE13
,      HEADER_ATTRIBUTE14
,      HEADER_ATTRIBUTE15
,      HEADER_ATTR_CATEGORY
,      BU_GROUP_ID
,      DOC_STATUS
,      TREASURY_SYMBOL
,      TIME_FRAME
,      ESTABLISHED_FISCAL_YR
,      EXPIRATION_DATE
,      CANCELLATION_DATE
,      RESOURCE_TYPE
,      FUND_CATEGORY
,      BEA_CATEGORY
FROM APPS.FV_BE_BA_FD_HDR_V;

Dependencies

[top of page]

APPS.FV_BE_BA_FD_HDR_V references the following:

APPS: FV_BE_TRX_DTLS; FV_BE_TRX_HDRS; FV_BE_XLA_PKG - show dependent code; FV_FUND_PARAMETERS; FV_TREASURY_SYMBOLS; GL_LEDGERS; XLA_EVENTS_GT

APPS.FV_BE_BA_FD_HDR_V is referenced by following:

APPS: XLA_08901_AAD_S_000002_BC_PKG - show dependent code; XLA_08901_AAD_S_000002_PKG - show dependent code