Results for “chrg_type_lookup_code”

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

Overview

AP_ALLOCATED_LINES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Payables (AP) product family and exposes the allocation results produced against charge-type invoice lines — freight, miscellaneous, and tax — when Payables distributes those charges across the target lines of an invoice. The view is not a transactional entity; it is a reporting and inquiry surface that reconciles each allocated amount back to its originating charge line and forward to the destination invoice line.

The object carries a status of VALID in the ETRM repository. Because it is a view rather than a table, no DML is permitted against it, and it does not participate directly in Oracle Payables' validation or accounting logic. Its principal consumers are custom reports, reconciliations, period-end analysis, and third-party integrations that require line-level allocation detail without navigating the base allocation tables directly.

Underlying Base Objects

The view is defined over four referenced objects plus one server-side package: AP_ALLOCATION_RULE_LINES, AP_ALLOCATION_RULE_LINES_GT, AP_INVOICE_LINES, and AP_LOOKUP_CODES, resolved through APPS synonyms, together with FND_GLOBAL. The view text is a UNION of two nearly identical SELECT statements, differing only in the allocation source: the first reads persisted allocation rows from AP_ALLOCATION_RULE_LINES, while the second reads the same shaped data from the global temporary table AP_ALLOCATION_RULE_LINES_GT. The GT branch is populated during online allocation processing, allowing users to review allocation results before they are committed to the permanent table.

Joins are enforced on INVOICE_ID and on line number: AP_INVOICE_LINES.LINE_NUMBER must equal AP_ALLOCATION_RULE_LINES.CHRG_INVOICE_LINE_NUMBER, so the driving invoice line is always the charge line, not the target line. The charge line's LINE_TYPE_LOOKUP_CODE must resolve against AP_LOOKUP_CODES where LOOKUP_TYPE equals 'INVOICE LINE TYPE', and the row is restricted to the values FREIGHT, MISCELLANEOUS, or TAX. FND_GLOBAL supplies session context for the standard auditing columns.

Key Columns

• INVOICE_ID — Identifier of the invoice to which both the charge line and the allocations belong.
• CHRG_INVOICE_LINE_NUMBER — The charge line being allocated; present in the metadata even where the view text exposes AIL.LINE_NUMBER.
• TO_INVOICE_LINE_NUMBER — The destination line that receives the allocated portion of the charge.
• CHRG_TYPE_LOOKUP_CODE / CHRG_TYPE — Lookup code (FREIGHT, MISCELLANEOUS, TAX) and its translated display value.
• CHRG_LINE_AMOUNT — Total amount of the originating charge line.
• ALLOCATED_PERCENTAGE — Proportion of the charge assigned to the target line.
• ALLOCATED_AMOUNT — Monetary value distributed to the target line.
• DESCRIPTION — Description carried from the charge line.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit and concurrency columns.

Common Use Cases and Queries

Typical scenarios include reconciling allocated freight or tax across invoice distribution lines, verifying that allocation percentages total one hundred percent per charge line, and populating custom extraction tables for downstream systems. A representative query lists allocations for a specific invoice:

SELECT TO_INVOICE_LINE_NUMBER, CHRG_TYPE, CHRG_LINE_AMOUNT,
    ALLOCATED_PERCENTAGE, ALLOCATED_AMOUNT
FROM APPS.AP_ALLOCATED_LINES_V
WHERE INVOICE_ID = :p_invoice_id
ORDER BY CHRG_TYPE, TO_INVOICE_LINE_NUMBER;

A second common pattern aggregates by charge type to confirm charge-line totals equal the sum of allocations. Because the view performs an implicit UNION, queries against it never return duplicate rows for a single persisted allocation; the GT branch contributes only during active allocation sessions. Access should be granted through the APPS schema with the standard MO: Operating Unit security applied to INVOICE_ID.