[Home] [Help] [Dependency Information]
Object Name: | FV_BE_RPR_HDR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FV.FV_BE_RPR_HDR_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 headers for SLA to identify the sources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Sub ledger accounting event identifier | |
BUDGET_LEVEL_ID | NUMBER | (15) | Yes | Budget level identifier. Foreign key to FV_BUDGET_LEVELS table |
GL_DATE | DATE | Yes | General ledger date | |
TRANSACTION_ID | NUMBER | (15) | Yes | Unique system generated identifier from FV_BE_RPR_TRANSACTIONS |
DOC_NUMBER | VARCHAR2 | (26) | Yes | Document number |
TRANSACTION_STATUS | VARCHAR2 | (25) | Yes | Status of transaction |
RPR_APPROVED_BY_USER_ID | NUMBER | (15) | User identification of the approver | |
SOURCE | CHAR | (3) | The source of the transaction. Currently fixed to "RPR" | |
LEDGER_ID | NUMBER | (15) | Yes | Ledger identifier |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, BUDGET_LEVEL_ID
, GL_DATE
, TRANSACTION_ID
, DOC_NUMBER
, TRANSACTION_STATUS
, RPR_APPROVED_BY_USER_ID
, SOURCE
, LEDGER_ID
, CURRENCY_CODE
FROM APPS.FV_BE_RPR_HDR_V;
|
|
|