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_DTL_V

Object Details

Object Name:	FV_BE_BA_FD_DTL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FV.FV_BE_BA_FD_DTL_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 lines for SLA to identify the sources

[View Source]

Columns

Name	Datatype	Length	Comments
EVENT_ID	NUMBER	(15)	Sub Ledger Accounting Event Identifier
LINE_NUMBER	NUMBER	(15)	Detail budgetary transaction identifier
TRANSACTION_TYPE_ID	NUMBER	(15)	Transaction Type identifier.
SUB_TYPE	VARCHAR2	(30)	Sub Type code
FUND_DISTRIBUTION_ACCOUNT	NUMBER		Distribution account code combination identifier
LINE_SEGMENT1	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT2	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT3	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT4	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT5	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT6	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT7	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT8	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT9	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT10	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT11	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT12	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT13	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT14	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT15	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT16	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT17	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT18	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT19	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT20	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT21	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT22	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT23	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT24	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT25	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT26	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT27	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT28	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT29	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
LINE_SEGMENT30	VARCHAR2	(25)	Accounting flexfield segment from FV_BE_TRX_DTLS
INCREASE_DECREASE_FLAG	VARCHAR2	(1)	Flag used to indicate Increase or Decrease in amount
ACCOUNTED_AMOUNT	NUMBER		Transaction amount
LINE_ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment from FV_BE_TRX_DTLS
LINE_ATTR_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure column from FV_BE_TRX_DTLS
CORRECTED_FLAG	VARCHAR2	(1)	Corrected flag, used to indicate whether the original interface record was modified
GROUP_ID	NUMBER		Group ID, identifies which group_id the record came from
TRANSACTION_TYPE	VARCHAR2	(25)	Transaction Type
DR_ACCOUNT_SEGMENT_VALUE	VARCHAR2	(25)	Debit account segment value for the transaction type
CR_ACCOUNT_SEGMENT_VALUE	VARCHAR2	(25)	Credit account segment value for the transaction type
APPROVAL_DATE	DATE		Approval date of the record
PUBLIC_LAW_CODE	VARCHAR2	(7)	Public Law Code. Used only for appropriation transactions
ADVANCE_TYPE	VARCHAR2	(25)	Advance Type. Used only for appropriation transactions. Valid values are "P" Advanced in prior year "F" Advanced from future year
DEPT_ID	VARCHAR2	(3)	Department identifier
MAIN_ACCOUNT	VARCHAR2	(4)	Main account
TRANSFER_DESCRIPTION	VARCHAR2	(30)	Description for direct transfer

Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      TRANSACTION_TYPE_ID
,      SUB_TYPE
,      FUND_DISTRIBUTION_ACCOUNT
,      LINE_SEGMENT1
,      LINE_SEGMENT2
,      LINE_SEGMENT3
,      LINE_SEGMENT4
,      LINE_SEGMENT5
,      LINE_SEGMENT6
,      LINE_SEGMENT7
,      LINE_SEGMENT8
,      LINE_SEGMENT9
,      LINE_SEGMENT10
,      LINE_SEGMENT11
,      LINE_SEGMENT12
,      LINE_SEGMENT13
,      LINE_SEGMENT14
,      LINE_SEGMENT15
,      LINE_SEGMENT16
,      LINE_SEGMENT17
,      LINE_SEGMENT18
,      LINE_SEGMENT19
,      LINE_SEGMENT20
,      LINE_SEGMENT21
,      LINE_SEGMENT22
,      LINE_SEGMENT23
,      LINE_SEGMENT24
,      LINE_SEGMENT25
,      LINE_SEGMENT26
,      LINE_SEGMENT27
,      LINE_SEGMENT28
,      LINE_SEGMENT29
,      LINE_SEGMENT30
,      INCREASE_DECREASE_FLAG
,      ACCOUNTED_AMOUNT
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      LINE_ATTR_CATEGORY
,      CORRECTED_FLAG
,      GROUP_ID
,      TRANSACTION_TYPE
,      DR_ACCOUNT_SEGMENT_VALUE
,      CR_ACCOUNT_SEGMENT_VALUE
,      APPROVAL_DATE
,      PUBLIC_LAW_CODE
,      ADVANCE_TYPE
,      DEPT_ID
,      MAIN_ACCOUNT
,      TRANSFER_DESCRIPTION
FROM APPS.FV_BE_BA_FD_DTL_V;

Dependencies

[top of page]

APPS.FV_BE_BA_FD_DTL_V references the following:

APPS: FV_BE_ACCOUNT_PAIRS; FV_BE_TRANSACTION_TYPES; FV_BE_TRX_DTLS; FV_BE_TRX_HDRS; FV_BE_TRX_SUB_TYPES; FV_BE_XLA_PKG - show dependent code; GL_LEDGERS; XLA_EVENTS_GT

APPS.FV_BE_BA_FD_DTL_V is referenced by following:

APPS: XLA_08901_AAD_S_000002_BC_PKG - show dependent code