Search Results pafv_invoice_lines




Overview
Explore in AI Chat

Overview

PAFV_INVOICE_LINES is a read-only business view owned by the APPS schema within the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to expose information about the individual lines of a draft invoice generated through the Oracle Projects billing cycle. The view is defined WITH READ ONLY, meaning it is intended strictly for querying and reporting rather than for insert, update, or delete operations. It combines header-level attributes from the draft invoice with line-level detail from the draft invoice items, and enriches that data with descriptive project, task, and currency conversion information.

Because it is a business view, PAFV_INVOICE_LINES is commonly used as a reporting and integration surface, allowing external reports, custom concurrent programs, and interfaces to consume draft invoice line data without joining the highly normalized underlying Projects tables directly.

Underlying Base Objects

The view is defined over five documented base objects:

  • PA_DRAFT_INVOICES_ALL — the draft invoice header, supplying invoice-level attributes such as the draft invoice number, currency codes, rate types, rate dates, exchange rates, and system reference.
  • PA_DRAFT_INVOICE_ITEMS — the draft invoice lines, supplying line number, amounts, text, task and event references, and audit columns.
  • PA_PROJECTS_ALL — the project master, supplying project name and number.
  • PA_TASKS — supplying task name and task number (joined with an outer join, so lines without a task still appear).
  • PA_CONVERSION_TYPES_V — referenced twice to resolve the invoice and accounted currency rate types into user conversion type names.

The primary joins are on PROJECT_ID and DRAFT_INVOICE_NUM between the draft invoice header and items, with PROJECT_ID linking to the project master and TASK_ID linking to tasks.

Key Columns

Common Use Cases and Queries

Typical uses include reviewing draft invoice lines before release, reconciling project, invoice, and accounted amounts, and extracting billing detail for downstream reporting or integration. The following samples are illustrative.

  • List all lines for a given draft invoice:
SELECT draft_invoice_number, line_number, project_number,
       task_number, amount, inv_amount, acctd_amount
FROM   pafv_invoice_lines
WHERE  draft_invoice_number = :p_invoice
ORDER  BY line_number;
  • Summarize invoice currency totals by project:
SELECT project_number, project_name, inv_currency_code,
       SUM(inv_amount) total_inv_amount
FROM   pafv_invoice_lines
GROUP  BY project_number, project_name, inv_currency_code;

Because the view is read-only and enforces organization-level security via the embedded ORG_ID predicate, queries automatically return only the draft invoice lines visible within the current operating unit context.