Search Results project_currency




Overview
Explore in AI Chat

Overview

APPS.PA_DRAFT_INVOICE_LINES_ALL_V is a reporting and integration view in Oracle EBS Projects (PA) that exposes draft invoice line details used during the billing cycle prior to invoice generation. Unlike released invoice interfaces, this view surfaces draft lines retained in the PA_DRAFT_INVOICES_ALL / PA_DRAFT_INVOICE_ITEMS tables and enriches them with task, event, tax, and currency context. In Oracle EBS 12.1.1 and 12.2.2 the view is a key source for reports, extensions, and interfaces that must reflect provisional billing data before the draft is finalized and transferred to Oracle Receivables.

The view is particularly relevant to currency handling. The user search term "project_currency" maps directly to the view's currency derivation logic, which resolves the invoicing currency according to the invoice processing currency type (PROJFUNC_CURRENCY, PROJECT_CURRENCY, or funding currency) and joins conversion types from PA_CONVERSION_TYPES_V.

Underlying Base Objects

The view is defined over the following documented objects:

Because the FROM clause includes these objects, the view is a denormalized projection spanning billing, event, task, tax, and party/location data.

Key Columns

Common Use Cases and Queries

Typical uses include draft billing review reports, reconciliation of project currency versus invoice processing currency, and pre-transfer validation of tax and rounding amounts. A representative query filtering by project currency follows:

SELECT dil.PROJECT_ID, dil.DRAFT_INVOICE_NUM, dil.LINE_NUM, dil.PROJECT_CURRENCY_CODE, dil.INVPROC_CURRENCY_CODE, dil.AMOUNT, dil.PROJFUNC_BILL_AMOUNT, dil.TASK_NUMBER, dil.WORK_SITE FROM APPS.PA_DRAFT_INVOICE_LINES_ALL_V dil WHERE dil.PROJECT_CURRENCY_CODE = :project_currency AND dil.PROJECT_ID = :project_id ORDER BY dil.DRAFT_INVOICE_NUM, dil.LINE_NUM;

The view is read-only and is suited to reporting rather than DML; updates to draft lines must be performed against the underlying PA_DRAFT_INVOICE_ITEMS table.