Search Results draft_invoice_number

Overview

PABV_INVOICE_LINES is an APPS-owned, read-only database view in the Oracle E-Business Suite Projects (PA) module. Its name follows the "BV" designation used for Business View/backing views, and the ETRM documentation annotates its description as "Retrofitted," indicating the object was carried forward across releases and re-validated for Oracle EBS 12.1.1 and 12.2.2. The view consolidates draft invoice line information together with the parent draft invoice header, project currency context, and conversion rate definitions. Its primary role is to present invoice line data in a flattened, reporting-friendly structure that joins line-level detail to header-level currency, exchange rate, and accounting attributes.

Because the view exposes the column INV_AMOUNT—the enterprise search term associated with this object—it is frequently used to retrieve the invoiced amount expressed in the invoice (transaction) currency. This makes it relevant for project billing analysis, revenue and receivables reporting, and integrations that extract draft invoice lines out of the Projects billing tables.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects, over which the view is defined:

• PA_DRAFT_INVOICE_ITEMS (SYNONYM) — the line-level source table (aliased PDII).
• PA_DRAFT_INVOICES_ALL (SYNONYM) — the invoice header table (aliased PDIA).
• PA_PROJECTS_ALL (SYNONYM) — the project master, supplying PROJECT_CURRENCY_CODE (aliased PPA).
• PA_CONVERSION_TYPES_V (VIEW) — joined twice, as INV and ACCT, to resolve invoice-currency and accounted-currency conversion rate types.

The join pattern links PDII to PDIA on PROJECT_ID and DRAFT_INVOICE_NUM, links PPA to PDIA on PROJECT_ID, and outer-joins the conversion types view on the header's rate-type columns. A security predicate on the invoice header organization ('_SEC:PDIA.ORG_ID') enforces operating unit access, and the view is defined WITH READ ONLY plus row-level security via the underscore-prefixed pseudo-columns.

Key Columns

• PROJECT_ID, DRAFT_INVOICE_NUMBER, LINE_NUMBER — primary identifying keys of the invoice line.
• PROJECT_CURRENCY_CODE — the project's functional currency.
• AMOUNT — line amount in project currency.
• INV_CURRENCY_CODE, INV_AMOUNT, INV_RATE_TYPE, INV_RATE_DATE, INV_EXCHANGE_RATE — the invoice (transaction) currency and the exchange rate used to translate the line.
• ACCTD_CURRENCY_CODE, ACCT_AMOUNT, ACCTD_RATE_TYPE, ACCTD_RATE_DATE, ACCTD_EXCHG_RATE — the accounted (ledger) currency and its translation details.
• EVENT_NUM, TASK_ID, SYSTEM_REFERENCE — billing event, task, and source-system tracking identifiers.
• Descriptive flexible columns such as "_LA:INVOICE_LINE_TYPE" and "_LA:TAXABLE_FLAG" carry lookup meanings for line type and taxability; INVOICE_LINE_TEXT holds the line description.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include reconciling draft invoice lines by currency, extracting billed amounts for a project, and feeding downstream revenue or receivables reporting. A representative query retrieves invoice-currency amounts for a given project:

• SELECT project_id, draft_invoice_number, line_number, inv_currency_code, inv_amount, acctd_amount FROM apps.pabv_invoice_lines WHERE project_id = :project_id AND draft_invoice_number = :invoice_num;

• SELECT draft_invoice_number, SUM(inv_amount) inv_total FROM apps.pabv_invoice_lines WHERE inv_currency_code = 'USD' GROUP BY draft_invoice_number;

Because the view is READ ONLY and subject to the ORG_ID security predicate, queries automatically return only the invoice lines visible to the caller's operating unit, making it suitable for both ad hoc inquiry and controlled integration extracts.