Results for “pa_cost_dist_lines_forms_mrc_v”

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

Overview

The view PA_COST_DIST_LINES_FORMS_MRC_V belongs to the Oracle Projects (PA) module and exposes expenditure cost distribution lines in a multiple reporting currency (MRC) context. The name suffix "MRC_V" indicates that the view is intended to surface amounts expressed in more than one currency — typically the functional (denominated) currency, the project currency, and the accounting (GL) currency — as well as the associated conversion rate attributes. The "FORMS" component signals that the view is designed to support an Oracle Forms-based user interface or an equivalent report that presents distribution lines to end users, for example the cost distribution and transfer windows used during the interface of project costs to Oracle General Ledger.

The view is documented in ETRM for release 12.2.2 and, per its metadata, is not implemented in this database. That means the object is recognized and documented but was not created or compiled in the referenced environment. It may be a legacy or conditional object, present only where the relevant MRC configuration and Projects cost distribution features are enabled, or it may have been superseded by a functionally equivalent view. Underlying column names mirror those of the PA_COST_DISTRIBUTION_LINES_ALL entity, which is the primary repository for expenditure distribution lines awaiting or completing transfer to GL.

Underlying Base Objects

The documented metadata lists no explicitly referenced base objects. Inspection of the view text, however, shows that every column is derived from an alias CDL that corresponds to the Projects cost distribution lines table, conventionally PA_COST_DISTRIBUTION_LINES_ALL. No joins, aggregations, or lookups are present in the excerpt, so the view is a straight projection — effectively a structural and column-restricted presentation of the distribution lines table rather than a derived data set. The MRC-specific behavior is achieved through the presence of parallel currency columns (denominated, project, and accounted) that already exist on the base table, not through an additional join.

Key Columns

• EXPENDITURE_ITEM_ID, LINE_NUM, PROJECT_ID, TASK_ID — Identify the expenditure item and the project/task the distribution line belongs to.
• AMOUNT, QUANTITY, BURDENED_COST, BURDEN_SUM_SOURCE_RUN_ID — Raw cost, quantity, and burden amounts, together with the burden summarization source.
• DENOM_CURRENCY_CODE, DENOM_RAW_COST, DENOM_BURDENED_COST — Amounts in the denominated (functional) currency.
• PROJECT_CURRENCY_CODE, PROJECT_RAW_COST, PROJECT_BURDENED_COST, PROJECT_RATE_TYPE, PROJECT_RATE_DATE, PROJECT_EXCHANGE_RATE — Amounts and rate information in the project currency.
• ACCT_CURRENCY_CODE, ACCT_RAW_COST, ACCT_BURDENED_COST, ACCT_RATE_TYPE, ACCT_RATE_DATE, ACCT_EXCHANGE_RATE — Amounts and rates in the accounting (GL) currency.
• PROJFUNC_CURRENCY_CODE, PROJFUNC_COST_EXCHANGE_RATE, PROJFUNC_COST_RATE_TYPE, PROJFUNC_BURDENED_COST — Amounts converted using the project functional currency rules.
• DR_CODE_COMBINATION_ID, CR_CODE_COMBINATION_ID, CODE_COMBINATION_ID — Distribution account code combinations.
• TRANSFER_STATUS_CODE, TRANSFERRED_DATE, TRANSFER_REJECTION_REASON, GL_DATE, GL_PERIOD_NAME, PA_DATE, PA_PERIOD_NAME — Transfer and period status used to track the interface of the line to General Ledger.
• BILLABLE_FLAG, ACCUMULATED_FLAG, REVERSED_FLAG, LINE_NUM_REVERSED, SYSTEM_REFERENCE1–4 — Billability, accumulation, reversal, and reference attributes.

Common Use Cases and Queries

The view is typically used to drive or report cost distribution lines in the project functional currency alongside the accounting currency amounts, supporting reconciliation between the Projects subledger and GL. A sample query for examining burdened cost in both the project and accounting currencies follows:

SELECT expenditure_item_id,
       project_id,
       task_id,
       project_currency_code,
       project_burdened_cost,
       acct_currency_code,
       acct_burdened_cost,
       transfer_status_code
  FROM pa_cost_dist_lines_forms_mrc_v
 WHERE project_id = :project_id
   AND transfer_status_code = 'Y';

Because the object is reported as not implemented, it should be verified against the target database before use; where it is absent, equivalent reporting may be obtained directly from PA_COST_DISTRIBUTION_LINES_ALL, which supplies the same columns. This makes the view primarily a convenience presentation layer rather than a source of additional business logic.