Results for “bom_resource”

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

Overview

The APPS.PO_DISTRIBUTIONS_INQ_V view is a Purchasing (PO) module inquiry view that exposes purchase order distribution accounting information in a denormalized, read-optimized form. It is registered in the E-Business Suite environment with a status of VALID and is described in the ETRM metadata as "Retrofitted," indicating it was introduced or reconstituted to support inquiry and reporting functionality rather than transactional DML. Purchase order distributions represent the accounting and charge allocations for each shipment line in Purchasing; they carry the code combination, encumbrance state, accrual flags, and project or WIP references required downstream by Payables, General Ledger, and Project Accounting. This view presents those distribution rows joined with supplementary descriptive data from headers, lines, line types, and requisition entities, allowing consumers to resolve contextual meaning without issuing multiple joins themselves.

Because the object type is VIEW, it stores no data of its own. All results are derived at query time from the underlying synonym-based tables, which means performance depends entirely on the selectivity of the queried columns and the indexing of PO_DISTRIBUTIONS_ALL. The view is intended for read and inquiry patterns: reporting, integration extracts, reconciliation of encumbrance and accrual amounts, and diagnostic queries.

Underlying Base Objects

Per the documented view metadata, PO_DISTRIBUTIONS_INQ_V is defined over the following base objects, all referenced through APPS synonyms: PO_DISTRIBUTIONS_ALL, which supplies the core distribution rows addressed by the row identifier; PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_RELEASES_ALL, which provide the document hierarchy from header through release, line, and shipment; PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL, along with PO_DOC_STYLE_HEADERS, which supply document type and style context; PO_LINE_TYPES_TL, which provides the translated line type; PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL, and PO_REQ_DISTRIBUTIONS_ALL, which link distributions back to their originating requisition and requisition distribution; PO_SYSTEM_PARAMETERS, which supplies operating unit purchasing controls; and WIP_ENTITIES, which is relevant for distributions directed to Work in Process.

The inclusion of PO_REQ_DISTRIBUTIONS_ALL and the requisition tables explains the presence of REQ_HEADER_REFERENCE_NUM and REQ_LINE_REFERENCE_NUM among the selected columns, and it is the reason a search for "req_num" surfaces this view. The view returns each distribution enriched with requisition reference numbers, which are commonly used to trace demand from requisition through to purchase order distribution.

Key Columns

The view selects the ROWID of PO_DISTRIBUTIONS_ALL as its first column, giving a stable physical identifier for each returned row. Primary identifiers include PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_LINE_ID, PO_RELEASE_ID, REQ_DISTRIBUTION_ID, and SOURCE_DISTRIBUTION_ID, which together establish document and lineage relationships. Requisition traceability is exposed through REQ_HEADER_REFERENCE_NUM and REQ_LINE_REFERENCE_NUM.

Accounting and encumbrance data is represented by CODE_COMBINATION_ID, ACCRUAL_ACCOUNT_ID, BUDGET_ACCOUNT_ID, and VARIANCE_ACCOUNT_ID, alongside AMOUNT_BILLED, ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT, and UNENCUMBERED_QUANTITY. Encumbrance and accrual state are captured by ENCUMBERED_FLAG, ACCRUED_FLAG, ACCRUE_ON_RECEIPT_FLAG, PREVENT_ENCUMBRANCE_FLAG, and FAILED_FUNDS_LOOKUP_CODE. General Ledger lifecycle dates include GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE, and GL_CLOSED_DATE. Project and WIP references include PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, WIP_ENTITY_ID, WIP_LINE_ID, WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM, BOM_RESOURCE_ID, and WIP_REPETITIVE_SCHEDULE_ID. Destination and delivery data include DESTINATION_TYPE_CODE, DESTINATION_SUBINVENTORY, DESTINATION_ORGANIZATION_ID, DELIVER_TO_LOCATION_ID, and DELIVER_TO_PERSON_ID. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent request columns (PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) are also exposed.

Notably, the quantity columns QUANTITY_BILLED, QUANTITY_CANCELLED, and QUANTITY_DELIVERED are wrapped in DECODE expressions keyed on ORDER_TYPE_LOOKUP_CODE, returning null quantities for RATE and FIXED PRICE order types while passing through the stored value otherwise.

Common Use Cases and Queries

Typical uses include requisition-to-order traceability, encumbrance and accrual reconciliation, project and WIP distribution reporting, and integration extracts for downstream systems. The following query locates distributions by requisition reference number:

• SELECT po_distribution_id, po_header_id, po_line_id, req_header_reference_num, req_line_reference_num, code_combination_id, amount_billed, encumbered_amount, accrued_flag FROM apps.po_distributions_inq_v WHERE req_num IS NOT NULL;
• SELECT po_header_id, SUM(amount_billed) billed, SUM(encumbered_amount) encumbered FROM apps.po_distributions_inq_v WHERE encumbered_flag = 'Y' GROUP BY po_header_id;
• SELECT po_distribution_id, project_id, task_id, expenditure_type, expenditure_item_date FROM apps.po_distributions_inq_v WHERE project_id IS NOT NULL;
• SELECT po_distribution_id, wip_entity_id, wip_line_id, wip_operation_seq_num, unencumbered_quantity FROM apps.po_distributions_inq_v WHERE wip_entity_id IS NOT NULL;

Queries should filter on indexed distribution columns such as PO_HEADER_ID, PO_LINE_ID, or PO_DISTRIBUTION_ID to limit the join fan-out across the referenced base tables. All access should be performed with the APPS schema or an appropriately granted reporting responsibility.