Search Results purchase_order




Overview
Explore in AI Chat

Overview

PA_XLA_BC_PKT_PO_DETAIL_V is a Subledger Accounting (SLA/XLA) supporting view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. Its name reflects its function: it exposes the purchase order and requisition distribution detail associated with Burden Cost (BC) packets that are processed by the Projects SLA/XLA accounting engine. It is designated a "detail" view because it flattens the encumbrance and accounting distribution lines that feed the creation of XLA events and their corresponding journal entries for procurement-related project expenditures.

The view is primarily consumed by the Subledger Accounting programs that derive and populate the XLA_AE_HEADERS and XLA_AE_LINES tables for project burden cost transactions. Because it joins procurement documents (purchase orders and requisitions) to Projects burden packet structures, it is relevant to funds control, encumbrance accounting, and budgetary reconciliation reporting. The view is delivered VALID in both 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The view is defined over the following documented base objects, joined through synonyms and utility packages:

The view is therefore a composite layer that joins procurement distributions to Projects packet data and uses package functions to compute the appropriate debit or credit side for each distribution line.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing the amount side selected for a PO/REQ distribution, verifying encumbrance upgrade flags, and reconciling burden packet events to their procurement source.

Example: list distributions for a given packet.

  • SELECT bc_event_id, document_distribution_id, document_type, project_id, task_id, currency_code, budget_version_id FROM pa_xla_bc_pkt_po_detail_v WHERE bc_packet_id = :p_packet_id;

Example: identify rows requiring the encumbrance upgrade attribute.

  • SELECT bc_event_id, document_header_id, document_distribution_id, use_enc_upg_attrib_flag FROM pa_xla_bc_pkt_po_detail_v WHERE use_enc_upg_attrib_flag IS NOT NULL;

Because the view embeds package function calls, queries should be constrained by packet or event identifiers to avoid full-table evaluation of the underlying derivation logic. Outputs feed the Projects SLA accounting programs, so results should generally be correlated to XLA_EVENTS_GT and the resulting journal entries.