Results for “pos_distributions_v”

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

Overview

POS_DISTRIBUTIONS_V is a VALID Oracle E-Business Suite view owned by the APPS schema within the POS (iSupplier Portal) product family. Its documented purpose is to select the detailed information for purchase order distributions, exposing a distribution-level projection of the underlying purchasing tables so that iSupplier Portal and related reporting components can present, reconcile, and audit how ordered quantities and amounts are allocated across accounting distributions, destinations, and accrual treatments.

The view is a read-only, security-agnostic wrapper: it applies no organization-based row filtering of its own, so access control is inherited from the invoking responsibility and any predicates layered on top by the calling form, concurrent program, or report. Because it is a view and not a table, it exposes no DML surface and should be treated strictly as a query source. In ETRM terms, POS_DISTRIBUTIONS_V is a reporting-facing object rather than a base transactional entity.

Underlying Base Objects

The view is defined over the base object PO_DISTRIBUTIONS_ALL, referenced in the ETRM metadata as a synonym in the APPS schema. In practice PO_DISTRIBUTIONS_ALL is the multi-organization table that stores one row per distribution of a purchase order line or line location, carrying the charge, budget, accrual, variance, and encumbrance accounting references alongside delivered, billed, and cancelled quantity counters.

Column correspondence between POS_DISTRIBUTIONS_V and PO_DISTRIBUTIONS_ALL is essentially one-to-one for the physical columns (PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, CODE_COMBINATION_ID, ACCRUAL_ACCOUNT_ID, and so on). The view adds derived logic on top of the base columns. Notably, the accounting reference is computed at runtime: when DESTINATION_TYPE_CODE is 'EXPENSE' and ACCRUE_ON_RECEIPT_FLAG is 'Y', ACCRUAL_ACCOUNT_ID is returned; otherwise CODE_COMBINATION_ID is returned for expense destinations, and ACCRUAL_ACCOUNT_ID is returned for all other destination types. A second DECODE over PREVENT_ENCUMBRANCE_FLAG and ACCRUE_ON_RECEIPT_FLAG governs encumbrance-related exposure.

Key Columns

The view exposes the full distribution attribute set, including:

• PO_DISTRIBUTION_ID — primary identifier for the distribution row.
• PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, PO_RELEASE_ID — foreign keys to the purchase order header, line, shipment, and release.
• CODE_COMBINATION_ID, ACCRUAL_ACCOUNT_ID, BUDGET_ACCOUNT_ID, VARIANCE_ACCOUNT_ID — accounting flexfield references for charge, accrual, budget, and variance postings.
• ACCRUED_FLAG, ENCUMBERED_FLAG — the search term for this object. ACCRUED_FLAG indicates whether accrual accounting has been recorded for the distribution; ENCUMBERED_FLAG indicates whether funds have been encumbered.
• QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED — lifecycle quantity counters.
• AMOUNT_BILLED, ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT, UNENCUMBERED_QUANTITY — monetary and quantity balances.
• DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY — where the goods are charged.
• GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE — General Ledger encumbrance timing.
• ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns.
• RATE, RATE_DATE — currency conversion data.

Common Use Cases and Queries

The view is typically used to reconcile distribution-level commitments and accruals, to report unbilled or unencumbered balances, and to feed iSupplier Portal screens that display distribution detail to suppliers and buyers. The ACCRUED_FLAG column is frequently used to isolate distributions awaiting or carrying accrual entries.

• Distributions with recorded accruals: SELECT PO_DISTRIBUTION_ID, PO_LINE_ID, ACCRUED_FLAG FROM APPS.POS_DISTRIBUTIONS_V WHERE ACCRUED_FLAG = 'Y';
• Unencumbered exposure: SELECT PO_HEADER_ID, UNENCUMBERED_AMOUNT FROM APPS.POS_DISTRIBUTIONS_V WHERE ENCUMBERED_FLAG = 'Y' AND UNENCUMBERED_AMOUNT > 0;
• Expense distributions with accrual account: SELECT PO_DISTRIBUTION_ID, ACCRUAL_ACCOUNT_ID FROM APPS.POS_DISTRIBUTIONS_V WHERE DESTINATION_TYPE_CODE = 'EXPENSE';