Results for “projfunc_rev_rate_type”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view PA_CUST_EVENT_REV_DIST_LINES_V is an Oracle E-Business Suite Projects (PA) single-org view owned by the APPS schema. It exposes customer event revenue distribution lines generated by the Revenue Processing (RevProc) and Invoicing Processing (InvProc) engines. In ETRM 12.1.1 and 12.2.2 the object is documented as VALID and resolves to a single organization context, meaning ORG_ID is carried as a column rather than being supplied implicitly through a multi-org secured synonym.

The view is primarily consumed by revenue and invoicing reporting, reconciliation, and integration routines that need to inspect the currency, rate type, rate date, and exchange rate values applied when amounts were converted between the bill transaction, revenue processing, invoicing processing, project, project functional, and funding currencies. For users searching on revproc_rate_type, this view is the repository of that attribute, surfaced as REVPROC_RATE_TYPE and accompanied by the related RevProc currency, rate date, and exchange rate columns.

Underlying Base Objects

The documented base objects referenced by this view are:

The view is essentially a projection over PA_CUST_EVENT_REV_DIST_LINES, with selected columns passed through unchanged and several rate type columns wrapped by the multi-currency package function. The synonym supplies the physical distribution line attributes, while the package supplies the derivation logic for user-facing conversion type descriptions. No joins to additional tables are documented in the supplied excerpt; currency rate data is therefore assumed to be denormalized onto the distribution line itself.

Key Columns

Common Use Cases and Queries

Typical usage includes reconciling revenue processing conversion rates, auditing which rate type was applied to a distribution line, and feeding downstream revenue extracts.

  • Retrieve RevProc rate type and rates for a project: 
    SELECT project_id, event_num, line_num, revproc_currency_code,
       revproc_rate_type, revproc_rate_date, revproc_exchange_rate
FROM   apps.pa_cust_event_rev_dist_lines_v
WHERE  project_id = :project_id;
  • Compare RevProc and InvProc rate types on the same line: 
    SELECT event_num, line_num, revproc_rate_type, invproc_rate_type,
       project_rev_rate_type, funding_rev_rate_type
FROM   apps.pa_cust_event_rev_dist_lines_v
WHERE  org_id = :org_id
AND    reversed_flag = 'N';
  • Report user-facing conversion types using the package wrapper: 
    SELECT project_id, project_rev_rate_type,
       pa_multi_currency.get_user_conversion_type(project_rev_rate_type) display_type
FROM   apps.pa_cust_event_rev_dist_lines_v;

Because the view carries ORG_ID, queries should filter by operating unit where multi-org isolation is required.