Search Results po_line_locations_trx_v




Overview
Explore in AI Chat

Overview

The APPS.PO_LINE_LOCATIONS_TRX_V view is a Purchasing (PO) module database object in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a transaction-oriented projection of the PO_LINE_LOCATIONS table, which holds the shipment- and distribution-schedule level detail of a purchase order line. Each row in PO_LINE_LOCATIONS represents a specific shipment or schedule for a given PO line, carrying quantity, pricing, receipt, invoicing, and tax attributes that govern how that shipment is processed downstream.

The view is classified as VALID and owned by the APPS schema. Its role is to provide a stable, read-oriented interface for reporting and integration that other PO components — including package logic and tax calculation routines — can reference without directly targeting the base table. Because the searched term "calculate_tax_flag" relates to tax determination on purchasing documents, this view is relevant where transactional tax flags and amounts are read from the shipment level.

Underlying Base Objects

The documented metadata identifies the following referenced base objects:

  • PO_LINE_LOCATIONS (SYNONYM) — the primary physical table from which the view derives its columns.
  • PO_LINES_TRX_V (VIEW) — the line-level transactional view, related to this view through the PO_LINE_ID foreign key.
  • PO_DISTRIBUTIONS_ALL (SYNONYM) — distribution-level detail linked to shipments via LINE_LOCATION_ID.
  • PO_CLM_INTG_GRP (PACKAGE) — a Purchasing package referenced in the dependency chain, generally associated with contract/commitment integration processing.

The view text directly selects from POLL (the PO_LINE_LOCATIONS alias), projecting nearly all columns of the base table. It does not perform aggregation, so one view row corresponds to one shipment/schedule record.

Key Columns

Common Use Cases and Queries

Typical scenarios include reporting open shipment quantities, reviewing tax attributes per shipment, and feeding receiving or invoicing processes. A representative query retrieves taxable shipments for a given PO line:

  • SELECT line_location_id, po_line_id, quantity, taxable_flag, tax_name, estimated_tax_amount FROM apps.po_line_locations_trx_v WHERE po_line_id = :p_line_id AND taxable_flag = 'Y';
  • Joining to PO_DISTRIBUTIONS_ALL on LINE_LOCATION_ID to reconcile billed versus ordered quantities.
  • Filtering on CLOSED_FLAG = 'N' and CANCEL_FLAG = 'N' to isolate active shipments pending receipt.

Because the view projects the base table without transformation, its results remain consistent with transaction-level Purchasing data and are suitable for custom reports, extracts, and integration interfaces.