Results for “pa_draft_invoice_lines_all_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_DRAFT_INVOICE_LINES_ALL_V is an APPS-owned reporting view within the Oracle Projects (PA) product family. It exposes draft invoice line detail generated by the Oracle Projects billing cycle, joining each line to its parent draft invoice, project, task, event, and associated tax and address attributes. The object is documented with the note "10SC Only," indicating it is intended for use with the 10SC (Ten-Stream / country-specific) billing configuration rather than as a generic global interface.

Because the view consolidates line-level amounts, revenue and receivable accounting indicators, currency conversion attributes, tax classification, and work-site location data in a single projection, it is commonly used for ad hoc reporting, reconciliation of draft invoice lines prior to release, and downstream integration where line detail is extracted for review. The view is read-only by nature; all maintenance occurs against the underlying draft invoice and draft invoice item entities.

Underlying Base Objects

The view is defined over a set of PA and cross-module base objects. Its primary sources are PA_DRAFT_INVOICE_ITEMS (the line records, aliased I in the view text) and PA_DRAFT_INVOICES_ALL (the header). Project and task context is supplied by PA_PROJECTS_ALL, PA_TASKS, and PA_EVENTS. Tax and classification attributes come from AR_VAT_TAX_ALL and AR_LOOKUPS. Currency conversion data is drawn from PA_CONVERSION_TYPES_V. Address and work-site information is resolved through the HZ hierarchy: HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, and HZ_LOCATIONS.

This structure confirms the view functions as a denormalized reporting layer: it does not add data of its own but resolves foreign keys, lookup meanings, and derived columns (such as the concatenated WORK_SITE string and conditional currency conversion type).

Key Columns

• PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM — Primary identifying context for each draft invoice line.
• AMOUNT, INV_AMOUNT, ACCT_AMOUNT — Entered, invoice, and accounted amounts for the line.
• UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR — Accounting indicators used in revenue and receivable generation, with corresponding ROUNDING_AMOUNT columns.
• TAXABLE_FLAG, OUTPUT_VAT_TAX_ID, OUTPUT_TAX_CLASSIFICATION_CODE, OUTPUT_TAX_EXEMPT_FLAG, TAX_CODE — Taxability and VAT/classification attributes resolved from AR_VAT_TAX_ALL and AR_LOOKUPS.
• EVENT_NUM, EVENT_ID, EVENT_TASK_NUMBER, COMPLETION_DATE — Linkage to the billing event driving the line.
• PROJFUNC_CURRENCY_CODE, INVPROC_CURRENCY_CODE, BILL_TRANS_CURRENCY_CODE and associated rate/date columns — Currency conversion context derived conditionally from conversion type.
• WORK_SITE — Concatenation of city, state, and postal code from the HZ locations hierarchy.
• DRAFT_INV_LINE_NUM_CREDITED, INVOICE_LINE_TYPE — Identifies credit lines and line type classification.

Common Use Cases and Queries

Typical scenarios include reviewing draft invoice lines before release, reconciling unbilled receivable and unearned revenue balances, and extracting tax-relevant line detail.

Sample query to retrieve lines for a specific draft invoice:

SELECT project_id, line_num, amount, inv_amount,
       taxable_flag, tax_code, work_site
FROM   apps.pa_draft_invoice_lines_all_v
WHERE  draft_invoice_num = :p_draft_invoice_num
ORDER  BY line_num;

Sample query to summarize taxable draft invoice amounts by project:

SELECT project_id, SUM(amount) total_amount
FROM   apps.pa_draft_invoice_lines_all_v
WHERE  taxable_flag = 'Y'
GROUP  BY project_id;

Because the object is documented as "10SC Only," its use should be scoped to environments configured for that billing mode, and any dependency on non-PA tax or HZ objects validated against the target instance before deployment.