Results for “project_no”

14 results




Overview
Explore in AI Chat

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

Overview

PO_DIST_DTL is the General Ledger (GL) distribution table for purchase orders and stock receipt transactions in Oracle Process Manufacturing Logistics (GML). It resides in the GML schema and stores the accounting distributions generated when procurement and receiving activity is captured, bridged, and ultimately posted to the general ledger. Each row represents one distribution line associated with a specific document type, document, order line, receipt sequence, and distribution sequence. In Oracle EBS 12.1.1 and 12.2.2, this table functions as a staging and reconciliation layer between the logistics subledger and GL, carrying both base and transaction currency amounts, quantity, account, period, and posting status information.

Heuristically, the mined foreign-key structure suggests a Data Vault classification of link, since the table primarily resolves relationships between documents (via SY_DOCS_MST), items (IC_ITEM_MST, IC_ITEM_MST_B), accounts (GL_ACCT_MST), ledgers (GL_LDGR_MST), accounting units (GL_ACCU_MST), currencies (GL_CURR_MST), and organizations (SY_ORGN_MST). This is a modeling suggestion only; in practice, PO_DIST_DTL behaves like a richly attributed link with satellite-style descriptive and posting columns.

Key Information Stored

The composite primary key, implemented by the unique index PO_DIST_DTL_PK, comprises DOC_TYPE, DOC_ID, LINE_ID, RECV_SEQ_NO, and SEQ_NO. These five columns together form the business-key candidate that uniquely identifies a distribution line. The most important attribute columns include:

  • DOC_TYPE / DOC_ID – identify the source document and its type; DOC_TYPE joins to SY_DOCS_MST.
  • LINE_ID / RECV_SEQ_NO / SEQ_NO – identify the order line, receipt sequence, and distribution sequence within the document.
  • ACCT_ID – the GL account charged; joins to GL_ACCT_MST.
  • ACCT_TTL_TYPE – the account title type; joins to GL_ACCT_TTL.
  • ACCT_DESC – descriptive text for the account distribution.
  • ACCTG_UNIT_ID – the accounting unit; joins to GL_ACCU_MST.
  • AMOUNT_BASE / AMOUNT_TRANS – distribution amounts in base and transaction currency.
  • CURRENCY_BASE / CURRENCY_TRANS – currency codes for both amount fields; both join to GL_CURR_MST.
  • LEDGER_CODE – the target ledger; joins to GL_LDGR_MST.
  • GL_POSTED_IND / EXPORTED_DATE – posting status and the date the row was exported to GL.
  • FISCAL_YEAR / PERIOD – the accounting period the distribution belongs to.
  • ITEM_ID / QUANTITY / QUANTITY_UM – item and quantity details; ITEM_ID joins to IC_ITEM_MST / IC_ITEM_MST_B, QUANTITY_UM joins to SY_UOMS_MST.
  • CO_CODE – the organization/company; joins to SY_ORGN_MST / SY_ORGN_MST_B.

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), along with TRANS_CNT, TEXT_CODE, PROJECT_NO, and DELETE_MARK, complete the 32 documented columns.

Common Use Cases and Queries

Typical reporting scenarios include distribution reconciliation, GL posting status review, and period-close analysis. A frequent query checks unposted distributions for a ledger and period:

  • SELECT DOC_TYPE, DOC_ID, LINE_ID, ACCT_ID, AMOUNT_BASE, GL_POSTED_IND FROM GML.PO_DIST_DTL WHERE LEDGER_CODE = :ledger AND FISCAL_YEAR = :year AND PERIOD = :period AND GL_POSTED_IND = 'N';
  • Joining to GL_ACCT_MST and GL_LDGR_MST to resolve account and ledger descriptions for financial reporting.
  • Aggregating AMOUNT_BASE by ITEM_ID or ACCT_ID to analyze procurement spend distributions.
  • Comparing AMOUNT_TRANS to AMOUNT_BASE, with CURRENCY_TRANS and CURRENCY_BASE, for multi-currency receipt valuation.
  • Reconciling exported rows (EXPORTED_DATE) against GL balances during period close.

Related Objects

The most significant related objects, based on the documented foreign keys, are:

  • GL_LDGR_MST – joined on PO_DIST_DTL.LEDGER_CODE; the ledger master.
  • GL_ACCT_MST – joined on ACCT_ID; the chart of accounts master.
  • GL_ACCU_MST – joined on ACCTG_UNIT_ID; the accounting unit master.
  • GL_CURR_MST – joined on CURRENCY_TRANS and CURRENCY_BASE; currency master.
  • GL_ACCT_TTL – joined on ACCT_TTL_TYPE; account title type.
  • IC_ITEM_MST and IC_ITEM_MST_B – joined on ITEM_ID; item master tables.
  • SY_DOCS_MST – joined on DOC_TYPE; document type master.
  • SY_ORGN_MST and SY_ORGN_MST_B – joined on CO_CODE; organization masters.
  • SY_UOMS_MST – joined on QUANTITY_UM; units of measure master.
  • PO_COST_MST – joined on AQUI_COST_ID; acquisition cost master.

These relationships make PO_DIST_DTL a central reconciliation point between procurement, inventory, and general ledger accounting within the GML module.