Search Results pabv_cost_distributions

Overview

PABV_COST_DISTRIBUTIONS is an APPS-owned, read-only database view in the Oracle E-Business Suite Projects (PA) module. It is designated as a retrofitted object, meaning it was introduced or regenerated to maintain backward compatibility after the base cost distribution structures were migrated to alternative tables (notably PA_COST_DISTRIBUTION_LINES_ALL). The view presents project cost distribution lines joined to their corresponding expenditure items, exposing both project-side accounting detail and the originating Oracle Payables (AP) invoice context.

The defining characteristic of this view is its dual lineage. It carries native Projects columns such as LINE_NUM, AMOUNT, QUANTITY, BURDENED_COST, PA_DATE, and GL_DATE alongside AP-sourced identifiers derived from the expenditure item, including AP_INVOICE_ID (mapped from DOCUMENT_HEADER_ID), AP_INVOICE_LINE_NUMBER (mapped from DOCUMENT_LINE_NUMBER), and AP_INVOICE_DISTRIBUTION_ID (mapped from DOCUMENT_DISTRIBUTION_ID). Because the search term "ap_invoice_line_number" resolves here, this view is the primary interface for tracing a project cost distribution back to a specific invoice line in Payables.

Underlying Base Objects

The view is defined over two documented base objects:

• PA_COST_DISTRIBUTION_LINES_ALL (referenced via synonym) — the principal driver, supplying distribution line amounts, quantities, burdened cost, currency and exchange rate detail, accounting code combinations, transfer status, and line-level reversal information.
• PA_EXPENDITURE_ITEMS_ALL (referenced via synonym) — joined on EXPENDITURE_ITEM_ID, supplying the AP document context: DOCUMENT_HEADER_ID, DOCUMENT_LINE_NUMBER, DOCUMENT_DISTRIBUTION_ID, DOCUMENT_PAYMENT_ID, DOCUMENT_TYPE, DOCUMENT_DISTRIBUTION_TYPE, and VENDOR_ID.

The join predicate is PCDL.EXPENDITURE_ITEM_ID = PEA.EXPENDITURE_ITEM_ID. A security predicate restricts rows to the session's operating unit ('_SEC:PCDL.ORG_ID' IS NOT NULL), and the view is defined WITH READ ONLY. Several columns carry label-translation directives (prefixed _LA), which resolve coded values against FND_LOOKUPS and PA_LOOKUPS so that descriptions such as billable flag meaning, reversal status, line type, and transfer status are displayed instead of raw codes.

Key Columns

• EXPENDITURE_ITEM_ID — join key linking a cost distribution line to its expenditure item; the anchor for all AP invoice traceability.
• AP_INVOICE_ID, AP_INVOICE_DISTRIBUTION_ID, AP_INVOICE_LINE_NUMBER, AP_INVOICE_PAYMENT_ID — invoice header, distribution, line, and payment references passed through from the expenditure item.
• LINE_NUMBER, AMOUNT, QUANTITY, BURDENED_COST — the distribution's core cost figures.
• LINE_NUMBER_REVERSED, the reversed flag, and the billable flag — support identification of reversal entries and billable versus non-billable distributions.
• PA_DATE, GL_DATE, TRANSFERRED_DATE, TRANSFER_REJECTION_REASON — dates and rejection detail governing the distribution's progress through accounting and transfer to GL.
• DR_CODE_COMBINATION_ID and CR_CODE_COMBINATION_ID — the debit and credit accounting flexfield combinations.
• DENOM_, ACCT_, and PROJECT_ currency and cost columns, with ACCT/PROJECT rate type, date, and exchange rate — support multi-currency reporting at denominator, accounting, and project currency levels.
• ORG_ID, CREATION_DATE, CREATED_BY, BATCH_NAME, VENDOR_ID — organizational, audit, batch, and supplier context.

Common Use Cases and Queries

Typical applications include invoice-to-project cost reconciliation, distribution transfer monitoring, and audit of billable and reversed lines. Because the view is read only and secured by ORG_ID, queries require APPS responsibility context and should filter by operating unit.

Retrieve invoice distributions for a specific invoice line:

• SELECT expenditure_item_id, ap_invoice_id, ap_invoice_line_number, ap_invoice_distribution_id, line_number, amount, burdened_cost, pa_date, gl_date FROM pabv_cost_distributions WHERE ap_invoice_line_number = :line AND org_id = :org_id;

List distributions awaiting transfer or rejected during transfer:

• SELECT expenditure_item_id, ap_invoice_id, ap_invoice_line_number, transfer_status, transferred_date, transfer_rejection_reason FROM pabv_cost_distributions WHERE transfer_status <> 'Y' AND org_id = :org_id;

Reconcile burdened cost by vendor and billing status:

• SELECT vendor_id, billable_flag, SUM(amount) raw_cost, SUM(burdened_cost) burdened FROM pabv_cost_distributions WHERE org_id = :org_id GROUP BY vendor_id, billable_flag;