DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FV_BE_RPR_DTL_V

Object Details
Object Name: FV_BE_RPR_DTL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFV.FV_BE_RPR_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 RPR Transaction Extract lines for SLA to identify the sources.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15)
Sub Ledger accounting event identifier
LINE_NUMBER NUMBER (15)
Transaction identifier from FV_BE_RPR_TRANSACTIONS
FUND_VALUE_FROM VARCHAR2 (25)
Balancing segment value from which funds are being transferred
DISTRIBUTION_FROM_ACCOUNT NUMBER

From distribution code combination identifier
FUND_VALUE_TO VARCHAR2 (25)
Balancing segment value to which funds are being transferred
DISTRIBUTION_TO_ACCOUNT NUMBER

To distribution code combination identifier
TRANSACTION_TYPE_ID NUMBER (15)
Transaction type identifier. Foreign key to FV_BE_TRANSACTION_TYPES
SUB_TYPE VARCHAR2 (30)
Sub Type code
ACCOUNTED_AMOUNT NUMBER

Transaction amount
SEGMENT1_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT2_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT3_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT4_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT5_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT6_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT7_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT8_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT9_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT10_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT11_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT12_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT13_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT14_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT15_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT16_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT17_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT18_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT19_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT20_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT21_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT22_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT23_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT24_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT25_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT26_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT27_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT28_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT29_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT30_FROM VARCHAR2 (25)
From distribution accounting flexfield segment
SEGMENT1_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT2_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT3_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT4_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT5_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT6_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT7_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT8_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT9_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT10_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT11_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT12_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT13_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT14_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT15_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT16_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT17_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT18_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT19_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT20_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT21_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT22_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT23_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT24_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT25_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT26_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT27_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT28_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT29_TO VARCHAR2 (25)
To distribution accounting flexfield segment
SEGMENT30_TO VARCHAR2 (25)
To distribution accounting flexfield segment
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
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
Query Text

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


SELECT EVENT_ID
,      LINE_NUMBER
,      FUND_VALUE_FROM
,      DISTRIBUTION_FROM_ACCOUNT
,      FUND_VALUE_TO
,      DISTRIBUTION_TO_ACCOUNT
,      TRANSACTION_TYPE_ID
,      SUB_TYPE
,      ACCOUNTED_AMOUNT
,      SEGMENT1_FROM
,      SEGMENT2_FROM
,      SEGMENT3_FROM
,      SEGMENT4_FROM
,      SEGMENT5_FROM
,      SEGMENT6_FROM
,      SEGMENT7_FROM
,      SEGMENT8_FROM
,      SEGMENT9_FROM
,      SEGMENT10_FROM
,      SEGMENT11_FROM
,      SEGMENT12_FROM
,      SEGMENT13_FROM
,      SEGMENT14_FROM
,      SEGMENT15_FROM
,      SEGMENT16_FROM
,      SEGMENT17_FROM
,      SEGMENT18_FROM
,      SEGMENT19_FROM
,      SEGMENT20_FROM
,      SEGMENT21_FROM
,      SEGMENT22_FROM
,      SEGMENT23_FROM
,      SEGMENT24_FROM
,      SEGMENT25_FROM
,      SEGMENT26_FROM
,      SEGMENT27_FROM
,      SEGMENT28_FROM
,      SEGMENT29_FROM
,      SEGMENT30_FROM
,      SEGMENT1_TO
,      SEGMENT2_TO
,      SEGMENT3_TO
,      SEGMENT4_TO
,      SEGMENT5_TO
,      SEGMENT6_TO
,      SEGMENT7_TO
,      SEGMENT8_TO
,      SEGMENT9_TO
,      SEGMENT10_TO
,      SEGMENT11_TO
,      SEGMENT12_TO
,      SEGMENT13_TO
,      SEGMENT14_TO
,      SEGMENT15_TO
,      SEGMENT16_TO
,      SEGMENT17_TO
,      SEGMENT18_TO
,      SEGMENT19_TO
,      SEGMENT20_TO
,      SEGMENT21_TO
,      SEGMENT22_TO
,      SEGMENT23_TO
,      SEGMENT24_TO
,      SEGMENT25_TO
,      SEGMENT26_TO
,      SEGMENT27_TO
,      SEGMENT28_TO
,      SEGMENT29_TO
,      SEGMENT30_TO
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TRANSACTION_TYPE
,      DR_ACCOUNT_SEGMENT_VALUE
,      CR_ACCOUNT_SEGMENT_VALUE
FROM APPS.FV_BE_RPR_DTL_V;

Dependencies

[top of page]

APPS.FV_BE_RPR_DTL_V references the following:

SchemaAPPS
PL/SQL PackageFND_FLEX_EXT - show dependent code
SynonymFV_BE_ACCOUNT_PAIRS
SynonymFV_BE_RPR_TRANSACTIONS
SynonymFV_BE_TRANSACTION_TYPES
SynonymFV_BE_TRX_SUB_TYPES
PL/SQL PackageFV_BE_XLA_PKG - show dependent code
SynonymGL_LEDGERS
SynonymXLA_EVENTS_GT
APPS.FV_BE_RPR_DTL_V is referenced by following:

SchemaAPPS
Package BodyXLA_08901_AAD_S_000002_BC_PKG - show dependent code