Results for “prev_ctl”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.AR_LINE_FREIGHT_V is a reporting view in the Oracle E-Business Suite Receivables module that exposes customer transaction lines eligible for freight charges. It is defined over RA_CUSTOMER_TRX_LINES and serves as the driving query for freight assignment, freight import, and AutoInvoice-related freight processing. Within the Receivables data model, freight is not stored as an attribute of an invoice line; instead, each freight charge is persisted as a separate row in RA_CUSTOMER_TRX_LINES with LINE_TYPE = 'FREIGHT', linked back to its parent line through LINK_TO_CUST_TRX_LINE_ID. The view identifies those parent lines that do not yet have freight defined and that satisfy the business rules governing whether freight is permitted.
The view is frequently relevant to implementers searching for AR_MEMO_LINES because the final predicate in its definition consults AR_MEMO_LINES to determine whether freight is allowed for a given memo line type. It is a read-only reporting construct and therefore carries no data of its own; results reflect the current state of the underlying transaction line and memo line records at query time.
Underlying Base Objects
The documented base objects for this view are RA_CUSTOMER_TRX_LINES (SYNONYM), AR_MEMO_LINES (SYNONYM), and the MO_GLOBAL (PACKAGE). The package reference indicates that the view participates in Multi-Org Access Control (MOAC), and its results are therefore subject to the operating unit context established by the session, typically through MO_GLOBAL.INIT or an equivalent initialization call.
The primary driving object is RA_CUSTOMER_TRX_LINES, aliased CTL in the view text. Three correlated subqueries refine the result set:
- A NOT EXISTS against RA_CUSTOMER_TRX_LINES (CTL2) that excludes any line already carrying a freight row for the same transaction.
- A conditional EXISTS against RA_CUSTOMER_TRX_LINES (PREV_CTL) that verifies, for credit or adjustment lines, that freight was defined on the previously credited transaction.
- An EXISTS against AR_MEMO_LINES that restricts memo-linked lines to those memo line types of 'FREIGHT' or 'LINE'.
Key Columns
- CUSTOMER_TRX_ID — Identifier of the customer transaction (invoice, debit memo, credit memo, or on-account credit) to which the line belongs.
- CUSTOMER_TRX_LINE_ID — Primary identifier of the transaction line. This value is the LINK_TO_CUST_TRX_LINE_ID target when a freight row is subsequently created.
- LINE_NUMBER — Display sequence of the line within the transaction, used for ordering and user-facing reference.
- DESCRIPTION — Descriptive text of the eligible line, typically the item or memo line description.
- INVENTORY_ITEM_ID — Inventory item associated with the line, where the line references a stocked or non-stocked item.
- MEMO_LINE_ID — Identifier of the associated memo line, used to determine whether freight is permitted for the memo line type as stored in AR_MEMO_LINES.
Common Use Cases and Queries
Typical usage includes identifying lines that can still receive a freight charge, diagnosing why freight was not applied during import or entry, and auditing memo-linked lines for freight eligibility. A simple query returns all eligible lines for a given transaction:
SELECT customer_trx_id, customer_trx_line_id, line_number, description, inventory_item_id, memo_line_id FROM apps.ar_line_freight_v WHERE customer_trx_id = :trx_id ORDER BY line_number;SELECT customer_trx_id, COUNT(*) eligible_lines FROM apps.ar_line_freight_v GROUP BY customer_trx_id;SELECT v.customer_trx_line_id, v.description, m.line_type FROM apps.ar_line_freight_v v, apps.ar_memo_lines m WHERE v.memo_line_id = m.memo_line_id;
Because the view is MOAC-aware through MO_GLOBAL, queries must be executed within an initialized operating unit context or with an appropriate multi-org initialization call to return complete and correctly scoped results.
-
VIEW: APPS.AR_LINE_FREIGHT_V 12.1.1
-
View: AR_LINE_FREIGHT_V 12.1.1
(Release 10SC Only)
APPS.AR_LINE_FREIGHT_V·↳ AR_MEMO_LINES·↳ MO_GLOBAL·↳ RA_CUSTOMER_TRX_LINES·Explore AR module →
-
VIEW: APPS.AR_LINE_FREIGHT_V 12.2.2
-
View: AR_LINE_FREIGHT_V 12.2.2
(Release 10SC Only)
APPS.AR_LINE_FREIGHT_V·↳ AR_MEMO_LINES·↳ MO_GLOBAL·↳ RA_CUSTOMER_TRX_LINES·Explore AR module →