Search Results req_line_quantity




Overview
Explore in AI Chat

Overview

POR_DISTRIBUTIONS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It belongs to the ICX (Oracle iProcurement) product family and is documented as the "Distribution View." Its purpose is to expose requisition distribution records in a denormalized, presentation-ready form suitable for requisition inquiry and iProcurement self-service pages.

The view joins distribution-level information stored in PO_REQ_DISTRIBUTIONS to header-level attributes held in PO_REQUISITION_LINES, combining accounting, encumbrance, project, and tax attributes on a single row. Because it is a view rather than a table, it carries no storage of its own; it is a read-only query surface used by forms, OAF pages, and custom reports. The requested column tax_recovery_override_flag maps to the view column TAX_RECOVERY_OVERRIDE_FLAG, which surfaces the distribution-level override that determines whether the default tax recovery rate for a requisition distribution is replaced by a manually entered value.

Underlying Base Objects

Per the documented ETRM metadata, POR_DISTRIBUTIONS_V references two base objects, both exposed through APPS-owned synonyms:

  • PO_REQUISITION_LINES (synonym) — aliased LINE in the view text, supplying quantity and unit price used to derive percentage and amount.
  • PO_REQ_DISTRIBUTIONS (synonym) — aliased DIST, supplying all distribution-level attributes including accounting, encumbrance, project, and tax-recovery columns.

The join predicate is DIST.REQUISITION_LINE_ID = LINE.REQUISITION_LINE_ID, a one-to-many relationship where a single requisition line may have multiple distributions, each producing a separate view row.

Key Columns

The view returns distribution identity and accounting keys such as DISTRIBUTION_ID, REQUISITION_LINE_ID, CODE_COMBINATION_ID, BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, and VARIANCE_ACCOUNT_ID, together with ORG_ID and SET_OF_BOOKS_ID for multi-org and ledger context. Encumbrance state is represented by ENCUMBERED_FLAG, ENCUMBERED_AMOUNT, GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE, PREVENT_ENCUMBRANCE_FLAG, and FAILED_FUNDS_LOOKUP_CODE.

Project accounting columns include PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID, PROJECT_ACCOUNTING_CONTEXT, and PROJECT_RELATED_FLAG. Derived columns—ALLOCATION_TYPE (defaulted to 'QUANTITY'), ALLOCATION_VALUE, PERCENTAGE, QUANTITY, and AMOUNT—are computed at runtime rather than stored. Tax handling is exposed through RECOVERABLE_TAX, NONRECOVERABLE_TAX, RECOVERY_RATE, and TAX_RECOVERY_OVERRIDE_FLAG, the last indicating whether the calculated recovery was overridden on the distribution. Fifteen ATTRIBUTE columns carry descriptive flexfield data, and SOURCE_REQ_DISTRIBUTION_ID, DISTRIBUTION_NUM, USSGL_TRANSACTION_CODE, and GL_CLOSED_DATE complete the attribute set.

Common Use Cases and Queries

Typical uses include requisition distribution inquiry, encumbrance and funds-check reporting, and tax recovery analysis. A query to identify distributions with a recovery override is shown below.

  • Listing overridden tax recovery distributions: 
    SELECT d.distribution_id,
       d.requisition_line_id,
       d.recovery_rate,
       d.tax_recovery_override_flag
FROM   apps.por_distributions_v d
WHERE  d.tax_recovery_override_flag = 'Y';
  • Joining to PO_REQUISITION_LINES to report requisition, line, and account context.
  • Aggregating AMOUNT and ENCUMBERED_AMOUNT by CODE_COMBINATION_ID for budget versus actual analysis.
  • Filtering by ORG_ID to constrain results to a single operating unit.

Because the view derives ALLOCATION_VALUE, PERCENTAGE, and AMOUNT from the line record, consumers should treat those columns as computed rather than stored, and should apply org-security and ledger filters appropriate to their reporting context.