Search Results revproc_revtrans_rate_type




Overview
Explore in AI Chat

Overview

APPS.PA_CUST_EVENT_REV_DIST_LINES_V is a reporting and integration view in Oracle EBS Projects (Oracle Projects / ETRM) that exposes customer event revenue distribution lines together with their associated revenue, invoicing, and multi-currency conversion attributes. It is defined in the APPS schema and surfaces the revenue distribution detail generated when customer events are processed, including the draft revenue, draft invoice, and general ledger code combination references, as well as the retained amount and reversal indicators.

The view is principally intended for reporting, reconciliation, and downstream integration scenarios where functional users require visibility into event-driven revenue distributions and the specific conversion rates applied to each line. Because the view already exposes the conversion rate type (for example REVPROC_RATE_TYPE), rate date, and exchange rate for each currency context, it is a convenient source for auditing which rate was used when revenue was recognized or invoiced in a foreign currency, rather than re-deriving that information from the base tables.

Underlying Base Objects

Per the ETRM 12.2.2 metadata, the view is defined over two referenced objects:

It is important to note that REVPROC_RATE_TYPE itself is selected directly from the base table and is not passed through the conversion function, whereas REVPROC_REVTRANS_RATE_TYPE is wrapped by PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE.

Key Columns

Common Use Cases and Queries

The view is typically queried to reconcile revenue versus billing amounts across currency contexts, to audit which conversion rate type was applied, and to feed downstream processes or reports. A representative query filtering on the searched attribute is:

  • Audit revenue transaction rate types: SELECT PROJECT_ID, EVENT_NUM, LINE_NUM, REVPROC_CURRENCY_CODE, REVPROC_REVTRANS_RATE_TYPE, REVPROC_REVTRANS_RATE_DATE, REVPROC_REVTRANS_EX_RATE, REVTRANS_AMOUNT FROM APPS.PA_CUST_EVENT_REV_DIST_LINES_V WHERE PRC_GENERATED_FLAG = 'Y'.
  • Compare project revenue and billing conversions: SELECT PROJECT_ID, DRAFT_REVENUE_NUM, PROJECT_REVENUE_AMOUNT, PROJECT_BILL_AMOUNT, PROJECT_REV_RATE_TYPE, PROJECT_INV_RATE_TYPE FROM APPS.PA_CUST_EVENT_REV_DIST_LINES_V WHERE PROJECT_ID = :project_id.
  • Identify reversed distributions: SELECT EVENT_NUM, LINE_NUM, REVERSED_FLAG, LINE_NUM_REVERSED, AMOUNT FROM APPS.PA_CUST_EVENT_REV_DIST_LINES_V WHERE REVERSED_FLAG = 'Y'.

Because the view already resolves conversion types through PA_MULTI_CURRENCY, it should be preferred over querying the base synonym directly whenever the reported value must match Oracle Projects' user-facing rate type terminology.