Search Results event_task_number




Overview
Explore in AI Chat

Overview

PA_DRAFT_INVOICE_LINES_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It exposes draft invoice line information generated by the Project Billing process, presenting the same data that appears on draft invoices before they are released and transferred to Oracle Receivables. The object is documented in ETRM 12.2.2 with a view status of VALID in the APPS schema, and is annotated in the source documentation as "10SC Only," indicating that the view is intended for use in a specific localization or configuration scope rather than general availability.

The view is a reporting and integration construct rather than a transactional entity. It flattens the relationship between draft invoice headers, draft invoice lines, project events, tasks, customers, and location data into a single queryable structure, which allows callers to retrieve billing detail without joining the underlying tables individually. This makes it useful for custom reports, interfaces, and extensions that need line-level draft invoice data in a currency- and tax-aware form.

Underlying Base Objects

The view is defined over a set of Project Billing tables and their supporting lookups and setup objects. According to the documented metadata, the referenced base objects are:

The view text selects primarily from PA_DRAFT_INVOICE_ITEMS (aliased I), joined to PA_EVENTS (EV), PA_TASKS (T and TSK), FND_LOOKUPS (FND_LK, FND_LK1, FND_LK2), and the HZ location tables. Currency conversion information is derived conditionally from PA_CONVERSION_TYPES_V based on the invoice processing currency type.

Key Columns

The columns exposed by the view fall into several functional groups:

Notably, three separate FND_LOOKUPS aliases (FND_LK, FND_LK1, FND_LK2) supply MEANING values, and the view also exposes CC_PROJECT_ID, CC_TAX_TASK_ID, and CC_REV_CODE_COMBINATION_ID for cross-charge handling.

Common Use Cases and Queries

The view is typically used to report or extract draft invoice lines prior to invoice release, to reconcile billed amounts against project events, and to feed downstream tax or revenue interfaces. A basic retrieval by draft invoice number resembles:

  • SELECT line_num, task_number, amount, inv_amount, bill_trans_currency_code, work_site FROM apps.pa_draft_invoice_lines_v WHERE draft_invoice_num = :p_invoice_num ORDER BY line_num;

Because the view joins to HR and HZ tables and to PA_CONVERSION_TYPES_V, it is generally appropriate to filter by PROJECT_ID or DRAFT_INVOICE_NUM to limit the result set. When currency conversion is required, the caller should evaluate the DECODE expressions for INVPROC_CURRENCY_CODE against the bill transaction currency and consult the PA_PROJECTS_ALL INVPROC_CURRENCY_TYPE setting to determine whether the project functional or project currency rate is returned. Given the "10SC Only" designation, implementers should confirm applicability for their specific localization before building production reports on this view.