Search Results charge_account




Overview
Explore in AI Chat

Overview

APPS.POR_VIEW_DIST_LINES_V is an Oracle E-Business Suite internal database view owned by the APPS schema. It is registered in FND Design Data under the identifier ICX.POR_VIEW_DIST_LINES_V and is classified as Oracle Internal Use Only; Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. The view presents the distribution-level detail of purchase requisition lines, combining requisition line identity, accounting distribution information, and the associated charge account. It is a read-only reporting layer intended to support requisition distribution inquiry and integration flows, particularly those surfaced through the iProcurement and ICX self-service requisitioning components. The view is valid in both Oracle EBS 12.1.1 and 12.2.2, and its query text is a straightforward projection over the referenced base objects.

Underlying Base Objects

The view is defined over the following documented objects:

The view does not reference any additional database objects beyond this list, and no other database object references POR_VIEW_DIST_LINES_V. It is therefore a terminal reporting object in the dependency tree.

Key Columns

  • REQUISITION_LINE_ID (NUMBER) — the unique identifier of the requisition line, joining the view back to PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS.
  • DISTRIBUTION_NUM (NUMBER) — the sequence number of the accounting distribution within the requisition line.
  • CHARGE_ACCOUNT (VARCHAR2, 155) — the concatenated charge account number derived from GL_CODE_COMBINATIONS_KFV, representing the accounting flexfield combination charged by the distribution. This is the column most directly associated with the user search term "charge_account."
  • PERCENTAGE (NUMBER) — the percentage of the requisition line amount charged to the account.
  • QUANTITY (NUMBER) — the quantity charged to the account.
  • AMOUNT (VARCHAR2, 4000) — the amount charged to the account, exposed as a string, typically due to formatting or currency conversion applied within the view.

Common Use Cases and Queries

Because the view is documented as internal-use only, its supported use is through standard Oracle Applications programs that surface requisition distribution and charge account information. Reporting scenarios include distribution-level charge account analysis, percentage and quantity splits across accounts, and reconciliation of requisition distributions to the general ledger. A representative query follows:

  • SELECT req_line_id, distribution_num, charge_account, percentage, quantity, amount FROM APPS.POR_VIEW_DIST_LINES_V WHERE requisition_line_id = :p_line_id;
  • SELECT charge_account, SUM(TO_NUMBER(amount)) FROM APPS.POR_VIEW_DIST_LINES_V GROUP BY charge_account;

Note that AMOUNT is a VARCHAR2 and should be cast when aggregating. Access to this view outside Oracle Applications programs is unsupported and should be treated as internal-only.