Search Results fnd_lk

Overview

APPS.PA_DRAFT_INVOICE_LINES_V is a reporting and integration view within the Oracle E-Business Suite Projects (PA) module that exposes draft invoice line detail for project billing. It consolidates line-level attributes from draft invoice headers and items together with related project, task, event, customer work-site, tax, and multi-currency conversion information. The view is commonly used by billing analysts, revenue accountants, and interface developers who need to review, export, or reconcile uninvoiced project billing lines before they are finalized into Oracle Receivables invoices.

A notable characteristic of this view is its multi-currency conversion logic. It surfaces conversion type descriptions (via the USER_CONVERSION_TYPE column supplied by the PA_CONVERSION_TYPES_V view) alongside exchange rates and rate dates, resolving the correct rate source depending on whether the invoice processing currency is the project functional currency, the project currency, or the funding currency. This makes the view valuable for understanding how foreign-currency invoice amounts were derived. The presence of the column USER_CONVERSION_TYPE in the search context reflects that users frequently query this view to identify the conversion type applied to a draft invoice line.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined over the following base objects:

• PA_DRAFT_INVOICES_ALL — draft invoice header (and joined via alias PR for invoice processing currency type).
• PA_DRAFT_INVOICE_ITEMS — the draft invoice line items (alias I), the primary source of line attributes.
• PA_EVENTS — project billing events (alias EV), supplying event ID, completion date, bill transaction currency, rates, and rate dates.
• PA_PROJECTS_ALL — project definitions (alias PR), providing invoice processing currency type.
• PA_TASKS — task definitions (aliases T and TSK), providing task numbers.
• PA_CONVERSION_TYPES_V — supplies user conversion type descriptions (aliases con1, con2, con3).
• FND_LOOKUPS — supplies lookup meanings (FND_LK1, FND_LK2).
• HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS — customer site and location data used to build the work-site string.
• HR_ALL_ORGANIZATION_UNITS — organization data.
• PA_OUTPUT_TAX (PACKAGE) — resolves output tax classification meaning.
• FND_GLOBAL (PACKAGE) — session context functions.

Key Columns

• PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM — identify the project, draft invoice, and line.
• AMOUNT, INV_AMOUNT, ACCT_AMOUNT, ROUNDING_AMOUNT — line amounts in various bases.
• UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR — accounting distributions.
• TAXABLE_FLAG, OUTPUT_TAX_EXEMPT_FLAG, OUTPUT_TAX_CLASSIFICATION_CODE — tax attributes.
• USER_CONVERSION_TYPE, EXCHANGE_RATE, RATE_DATE — currency conversion details.
• PROJFUNC_CURRENCY_CODE, PROJECT_CURRENCY_CODE, INVPROC_CURRENCY_CODE, BILL_TRANS_CURRENCY_CODE — currency context.
• WORK_SITE — formatted city/state/postal concatenation from HZ_LOCATIONS.
• EVENT_TASK_NUMBER, TASK_NUMBER — task identifiers.

Common Use Cases and Queries

Typical uses include reconciling draft invoice lines before transfer to Receivables, exporting line detail for external reporting, and auditing currency conversion on foreign-currency billing. A representative query follows:

SELECT project_id, draft_invoice_num, line_num,
       amount, user_conversion_type, exchange_rate, rate_date
FROM   apps.pa_draft_invoice_lines_v
WHERE  draft_invoice_num = :p_invoice_num
ORDER  BY line_num;

Analysts also filter by project or task to isolate billing lines, or by USER_CONVERSION_TYPE to confirm which conversion rate was applied. Because the view joins several large transactional tables, queries should always be constrained by invoice number, project, or date range to control performance.