Search Results pa_draft_inv_items_bas




Overview
Explore in AI Chat

Overview

APPS.PA_DRAFT_INVOICES_V is a reporting view in Oracle Projects that consolidates draft invoice header information with descriptive attributes drawn from project, customer, agreement, and HR master data. In Oracle EBS 12.1.1 and 12.2.2 it functions as a denormalized read layer over the draft invoicing tables, allowing reporting tools, concurrent programs, and integrations to retrieve invoice and project context from a single object rather than joining PA_DRAFT_INVOICES_ALL to multiple parent tables. The view exposes a ROW_ID pseudo-key, invoice lifecycle dates, transfer and status indicators, billing and currency attributes, and computed status expressions. Because it resolves lookups and meanings through subqueries, it is well suited to operational dashboards, extract interfaces, and reconciliation reports, though the correlated subqueries make it less efficient for large-scale bulk processing than the base tables.

Underlying Base Objects

The view is defined over the synonym PA_DRAFT_INVOICES_ALL as its driving table, aliased I, and joins outward to PA_PROJECTS_ALL (P) for project number, name, distribution rule, and project type; HR_ALL_ORGANIZATION_UNITS (ORG) for the owning project organization; PA_AGREEMENTS_ALL (A) and PA_CUSTOMERS_V (C) for agreement and customer identity; and PER_ALL_PEOPLE_F (EMP, EMP2) for the approver and releaser. Lookup meanings are resolved from PA_DISTRIBUTION_RULES, PA_PROJECT_STATUSES, RA_TERMS, PA_LOOKUPS, and PA_CONVERSION_TYPES_V. The metadata additionally lists PA_DRAFT_INV_ITEMS_BAS, PA_DRAFT_INVOICE_PP_V, PA_PROJECT_CUSTOMERS, PA_PROJECT_TYPES, PA_MULTI_CURRENCY, PA_OUTPUT_TAX, PA_SECURITY, PA_IMPLEMENTATIONS, FND_LANGUAGES, and HZ_CUST_SITE_USES, which supply line-level items, preparatory payment invoices, customer sites, currency conversion, tax, security, and language context. This breadth means the view inherits Oracle Projects security behavior through PA_SECURITY and multi-currency behavior through the PA_MULTI_CURRENCY package.

Key Columns

Common Use Cases and Queries

Typical uses include pending-invoice aging, approval and release audit reports, and feeds into external billing systems. Because the search term referenced PA_DRAFT_INV_ITEMS_BAS, analysts often join this view to that table to obtain line-level detail beneath each header.

A representative query lists unreleased invoices by project:

  • SELECT project_number, draft_invoice_num, chk_status, invoice_date, bill_through_date, inv_currency_code FROM apps.pa_draft_invoices_v WHERE chk_status = 'UNRELEASED' AND project_number = :p_project ORDER BY draft_invoice_num;

An audit query aggregates approvals by approver:

  • SELECT approved_by_person_name, COUNT(*) FROM apps.pa_draft_invoices_v WHERE approved_date BETWEEN :start_date AND :end_date GROUP BY approved_by_person_name;

Where line-level amounts are required, join to PA_DRAFT_INV_ITEMS_BAS on the draft invoice identifier to sum billed amounts per header. Reports should apply PA_SECURITY-consistent filters and consider that correlated subqueries within the view may benefit from indexed access on PROJECT_ID and DRAFT_INVOICE_NUM.