Results for “chrg_type”

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

Overview

APPS.AP_ALLOCATED_LINES_V is a reporting view in Oracle E-Business Suite Payables that exposes the relationship between allocated charge lines and their target invoice distributions. It is defined as a UNION of two nearly identical queries against AP_ALLOCATION_RULE_LINES and its global temporary counterpart AP_ALLOCATION_RULE_LINES_GT, joined to AP_INVOICE_LINES and AP_LOOKUP_CODES. The view is important in the context of the search term "ap_invoice_lines" because it presents allocation-level detail derived from the AP_INVOICE_LINES base table, allowing users to see how freight, miscellaneous, and tax charge lines have been apportioned across invoice lines by an allocation rule.

The view is read-only and is typically used for inquiry, reporting, and integration extract purposes. The UNION with the _GT synonym ensures both persistent allocation rule lines and session-level or temporary allocation rule lines are visible through the same interface.

Underlying Base Objects

The view is defined over the following documented objects, all referenced through APPS synonyms or views:

• AP_INVOICE_LINES — source of the charge lines themselves, supplying line number, line type, description, and amount.
• AP_ALLOCATION_RULE_LINES — persistent allocation rule line rows, supplying the target invoice line number, allocation percentage, allocated amount, and audit columns.
• AP_ALLOCATION_RULE_LINES_GT — the global temporary variant used in the second branch of the UNION, allowing temporary allocation rows to surface alongside permanent ones.
• AP_LOOKUP_CODES — a view over lookup values used to resolve the INVOICE LINE TYPE lookup code to its displayed description.
• FND_GLOBAL — the standard EBS package providing session context such as user and responsibility identifiers for audit and security filtering.

The join condition keys on INVOICE_ID and LINE_NUMBER matching CHRG_INVOICE_LINE_NUMBER, ensuring each allocation row is tied to a specific payables invoice charge line.

Key Columns

• INVOICE_ID — identifier of the payables invoice to which the allocation belongs.
• TO_INVOICE_LINE_NUMBER — the invoice line number receiving the allocated amount.
• LINE_NUMBER — the charge line number within AP_INVOICE_LINES.
• CHRG_TYPE_LOOKUP_CODE — the line type lookup code from AP_INVOICE_LINES, restricted to FREIGHT, MISCELLANEOUS, or TAX.
• CHRG_TYPE — the displayed lookup value derived from AP_LOOKUP_CODES (DISPLAYED_FIELD).
• DESCRIPTION — description of the source charge line.
• CHRG_LINE_AMOUNT — the amount on the charge line before allocation.
• ALLOCATED_PERCENTAGE and AMOUNT — the percentage applied and the resulting allocated amount on the target line.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns carried from the allocation rule line.

Common Use Cases and Queries

This view is commonly used to reconcile charge allocations to invoice lines, to validate that freight, tax, and miscellaneous charges are distributed correctly, and to feed downstream reporting or integration extracts. A typical query retrieves all allocations for a given invoice:

SELECT invoice_id, to_invoice_line_number, line_number,
       chrg_type, chrg_line_amount, allocated_percentage, amount
FROM   apps.ap_allocated_lines_v
WHERE  invoice_id = :p_invoice_id
ORDER BY line_number, to_invoice_line_number;

Analysts also aggregate allocated amounts by charge type to confirm that total allocated amounts equal the original charge line amount. Because the view joins to AP_LOOKUP_CODES and includes audit columns, it is suited for audit trail and control reporting without requiring direct joins to the underlying allocation rule tables.