Results for “denom_tp_currency_code”

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

Overview

PA_CC_DIST_LINES_SUMMARIZE_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It presents summarized distribution and accounting information drawn from the cross-charge distribution lines stored in PA_CC_DIST_LINES_ALL. The view aggregates individual distribution rows into debit and credit accounting entries, providing a consolidated picture of amounts that are prepared for transfer to Oracle General Ledger.

The view plays a supporting role in cross-charge processing and General Ledger interface reporting. Because cross-charge distributions are ultimately transferred to GL as balanced journal lines, the summarization performed here reduces row volume and exposes the accounted debit (ACCOUNTED_DR) and accounted credit (ACCOUNTED_CR) amounts that integration and reconciliation processes require. The view is defined only over lines whose transfer status is 'A' (accepted) or 'R' (rejected), so it reflects the portion of cross-charge activity that has reached a defined disposition within the transfer cycle.

Underlying Base Objects

The view is defined over a single documented base object, the synonym PA_CC_DIST_LINES_ALL, which resolves to the cross-charge distribution lines table in the APPS schema. The view performs no joins; instead, it applies aggregation and a UNION ALL over the same base table to produce separate debit and credit rows.

The view text uses DECODE and SIGN combinations to split signed amounts into positive and negative components. The first branch of the UNION ALL groups by the debit code combination (DR_CODE_COMBINATION_ID) and labels the rows with a literal 'DR'. The second branch groups by the credit code combination (CR_CODE_COMBINATION_ID) and labels the rows 'CR'. In this way a single signed distribution row is represented as either a debit or a credit summary line, depending on the sign of the underlying DENOM_TRANSFER_PRICE and AMOUNT values.

Key Columns

• ENTERED_DR / ENTERED_CR — Entered-currency debit and credit amounts derived from DENOM_TRANSFER_PRICE, split by sign.
• ACCOUNTED_DR / ACCOUNTED_CR — Accounted-currency debit and credit amounts derived from the AMOUNT column, split by sign. The accounted_dr searched column corresponds directly to this field.
• DENOM_TP_CURRENCY_CODE — Currency of the transfer price (entered) amount.
• ACCT_CURRENCY_CODE — Currency in which the accounted amounts are expressed.
• GL_DATE — Accounting date associated with the distribution for GL transfer.
• GL_BATCH_NAME — Name of the GL batch to which the summarized lines belong.
• LINE_TYPE — Classification of the underlying distribution line.
• REQUEST_ID — Concurrent request that produced the distribution lines.
• DR_CODE_COMBINATION_ID / CR_CODE_COMBINATION_ID — Accounting flexfield combinations for the debit and credit sides.
• TRANSFER_STATUS_CODE — Status of the line ('A' accepted or 'R' rejected), used to filter the view.
• TRANSFER_REJECTION_CODE — Reason code when a line has been rejected.
• PA_DATE — Project accounting date for the distribution.
• ORG_ID — Operating unit identifier, supporting multi-org reporting.
• COUNT(*) — Number of base rows aggregated into each summarized line.

Common Use Cases and Queries

The view is typically used to report and reconcile cross-charge amounts pending or completed transfer to GL, and to analyze rejected cross-charge activity by operating unit and batch. A representative query retrieving accounted debit totals for an operating unit follows:

• SELECT gl_date, gl_batch_name, SUM(accounted_dr) accounted_dr, SUM(accounted_cr) accounted_cr FROM pa_cc_dist_lines_summarize_v WHERE org_id = :org_id GROUP BY gl_date, gl_batch_name;
• SELECT * FROM pa_cc_dist_lines_summarize_v WHERE transfer_status_code = 'R' ORDER BY gl_batch_name;
• SELECT request_id, COUNT(*), SUM(accounted_dr), SUM(accounted_cr) FROM pa_cc_dist_lines_summarize_v GROUP BY request_id;

Because the view pre-aggregates and splits debits from credits, it is well suited to feeds and reconciliations where balanced accounted debit and credit columns are required without post-processing signed amounts.