Results for “pa_draft_inv_lines_form_mrc_v”

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

Overview

The view PA_DRAFT_INV_LINES_FORM_MRC_V belongs to the Oracle Projects (PA) module and is designed to supply line-level detail for the draft invoice lines form, with a specific focus on multi-reporting-currency (MRC) and multi-currency conversion information. It exposes draft invoice header attributes and draft invoice line attributes together with the currency conversion metadata required to display amounts in more than one currency context. The "MRC" suffix indicates that the view is intended to reconcile reporting-currency, project-currency, project-functional-currency, and bill-transaction-currency values within a single rowsource so that the invoice lines form and its downstream reporting can present converted figures without separate lookups.

In Oracle EBS 12.1.1 and 12.2.2, this view is one of several "FORM" views constructed for UI and report consumption rather than as a standalone stored table. As the ETRM metadata records, it selects its data from pa_draft_invoices, pa_mc_draft_inv_items, and pa_draft_invoice_items. The view is especially relevant to the search term user_conversion_type, because the view text derives conversion-rate indicators from lookup tables (CON1, CON2, CON3) keyed by USER_CONVERSION_TYPE.

Underlying Base Objects

The documented base objects are:

• PA_DRAFT_INVOICES — the draft invoice header, providing invoice-level and project-level context.
• PA_DRAFT_INVOICE_ITEMS — the primary draft invoice line container (aliased I in the view text), supplying line numbers, text, amounts, and tax attributes.
• PA_MC_DRAFT_INV_ITEMS — the multi-currency draft invoice items, supplying rate dates, exchange rates, and currency codes such as PROJFUNC_INV_EXCHANGE_RATE and BILL_TRANS_CURRENCY_CODE (aliased EV).

The view additionally joins supporting entities including HZ locations (ship-to/work-site address concatenation), a task table for event task numbers, and multiple lookup tables that resolve USER_CONVERSION_TYPE and meaning values. In 12.2.2 no base objects are formally documented for this view beyond the three named tables, and the implementation notes indicate it is not separately implemented in the reference database, consistent with a form-support view generated from package logic.

Key Columns

• ROW_ID — the ROWID of the underlying draft invoice item row.
• PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM, DRAFT_INV_LINE_NUM_CREDITED — invoice and line identity attributes.
• AMOUNT, INV_AMOUNT, ACCT_AMOUNT, ROUNDING_AMOUNT — line amounts and rounding adjustments at various currency stages.
• INVPROC_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE — invoicing/processing and project-functional currency codes.
• USER_CONVERSION_TYPE — returned via DECODE from CON1/CON2/CON3 based on PR.INVPROC_CURRENCY_TYPE ('PROJFUNC_CURRENCY', 'PROJECT_CURRENCY', or the default), identifying the rate type used for conversion.
• Rate date and rate columns — DECODEd from PROJFUNC_INV_RATE_DATE / PROJECT_INV_RATE_DATE / FUNDING_RATE_DATE and the corresponding exchange-rate fields.
• EVENT_ID, EVENT_NUM, EVENT_TASK_NUMBER, COMPLETION_DATE — billing event linkage.
• WORK_SITE — concatenated city, state, and postal code for the ship-to location.
• TAXABLE_FLAG, OUTPUT_TAX_EXEMPT_* , OUTPUT_TAX_CLASSIFICATION_CODE — tax handling attributes.

Common Use Cases and Queries

Typical uses include draft invoice line reporting, reconciliation of converted amounts across MRC currencies, and troubleshooting exchange-rate or rate-type discrepancies. A representative query:

SELECT project_id, draft_invoice_num, line_num,
       invproc_currency_code, projfunc_currency_code,
       user_conversion_type, amount, inv_amount
FROM   pa_draft_inv_lines_form_mrc_v
WHERE  draft_invoice_num = :invoice_number
ORDER BY line_num;

Analysts also use the view to audit which USER_CONVERSION_TYPE is applied per line when INVPROC_CURRENCY_TYPE differs between project-functional and project currency, and to join back to PA_DRAFT_INVOICES and PA_DRAFT_INVOICE_ITEMS for detailed drill-down.