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

VIEW: APPS.FV_BE_RPR_HDR_V

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.FV_BE_RPR_HDR_V references the following:

SchemaAPPS
SynonymFV_BE_RPR_TRANSACTIONS
SynonymGL_LEDGERS
SynonymXLA_EVENTS_GT
APPS.FV_BE_RPR_HDR_V is referenced by following:

SchemaAPPS
Package BodyXLA_08901_AAD_S_000002_BC_PKG - show dependent code
Package BodyXLA_08901_AAD_S_000002_PKG - show dependent code