[Home] [Help] [Dependency Information]
Object Name: | FV_BE_RPR_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_BE_RPR_DTL_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Sub Ledger accounting event identifier | |
LINE_NUMBER | NUMBER | (15) | Yes | Transaction identifier from FV_BE_RPR_TRANSACTIONS |
FUND_VALUE_FROM | VARCHAR2 | (25) | Yes | Balancing segment value from which funds are being transferred |
DISTRIBUTION_FROM_ACCOUNT | NUMBER | From distribution code combination identifier | ||
FUND_VALUE_TO | VARCHAR2 | (25) | Yes | Balancing segment value to which funds are being transferred |
DISTRIBUTION_TO_ACCOUNT | NUMBER | To distribution code combination identifier | ||
TRANSACTION_TYPE_ID | NUMBER | (15) | Yes | Transaction type identifier. Foreign key to FV_BE_TRANSACTION_TYPES |
SUB_TYPE | VARCHAR2 | (30) | Sub Type code | |
ACCOUNTED_AMOUNT | NUMBER | Yes | 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) | Yes | 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 |
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;
|
|
|