Results for “customer_item”

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

Overview

M4R_3A6_OE_LINE_ACKS is an APPS-owned database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, owned by the CLN product family — Supply Chain Trading Connector for RosettaNet. The view is documented in ETRM with a status of VALID and is defined as a superset of the OE_LINE_ACKS view, contributing one additional derived column named MODEL_REFERENCE_TEXT. Its purpose is to present order line acknowledgment data in a form suitable for RosettaNet message construction, where inbound and outbound line-level acknowledgments must carry explicit references to parent and top-model order lines. The view is therefore a controlled read-only interface consumed by the trading connector layer rather than a transactional object.

Underlying Base Objects

The documented base objects referenced by this view are OE_LINE_ACKS (SYNONYM) and OE_ORDER_LINES_ALL (SYNONYM). OE_LINE_ACKS supplies the primary acknowledgment attributes, including line numbers, ordered quantities, schedule dates, and acknowledgment type. OE_ORDER_LINES_ALL is accessed twice through correlated scalar subqueries to resolve the LINE_NUMBER of the top model line and the parent line referenced by LINK_TO_LINE_ID. In the view definition the primary alias is OELA (OE_LINE_ACKS), with OELT and OELL used for the two OE_ORDER_LINES_ALL lookups against TOP_MODEL_LINE_ID and LINK_TO_LINE_ID respectively. This dual reference to OE_ORDER_LINES_ALL is the mechanism that generates MODEL_REFERENCE_TEXT.

Key Columns

• LINK_TO_LINE_ID — Identifier of the parent line to which the current acknowledgment line is linked; the column the user searched for. It drives the PARENTLINEREFERENCE token in MODEL_REFERENCE_TEXT.
• TOP_MODEL_LINE_ID — Identifier of the top-level model line for configured or ATO items; drives the TOPMODELLINEREFERENCE token.
• MODEL_REFERENCE_TEXT — Derived column concatenating the decoded references, producing strings such as TOPMODELLINEREFERENCE=<line>|PARENTLINEREFERENCE=<line>|. Returns NULL-safe empty strings when neither identifier is populated.
• CUSTOMER_ITEM, USER_ITEM_DESCRIPTION, CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER — Customer-facing identification of the item and line.
• ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, ORIG_SYS_DOCUMENT_REF — Original source system references used for RosettaNet correlation.
• ORDERED_QUANTITY, ORDER_QUANTITY_UOM, UNIT_SELLING_PRICE — Commercial line attributes.
• REQUEST_DATE, SCHEDULE_ARRIVAL_DATE — Requested and scheduled dates for the acknowledgment.
• ACKNOWLEDGMENT_TYPE, FIRST_ACK_CODE, CHANGE_SEQUENCE — Acknowledgment control attributes.
• REQUEST_ID, SOLD_TO_ORG_ID — Contextual identifiers for the trading request and customer.

Common Use Cases and Queries

The view is typically queried to extract acknowledgment payloads for RosettaNet processing, to reconcile parent and child line relationships, or to inspect how the connector derives reference strings. A representative query returning the hierarchy information for a given request follows:

SELECT LINE_NUMBER, CUSTOMER_ITEM, LINK_TO_LINE_ID, TOP_MODEL_LINE_ID, MODEL_REFERENCE_TEXT FROM APPS.M4R_3A6_OE_LINE_ACKS WHERE REQUEST_ID = :p_request_id ORDER BY LINE_NUMBER;

To isolate lines bound to a specific parent, filtering by LINK_TO_LINE_ID is used:

SELECT LINE_NUMBER, LINK_TO_LINE_ID, MODEL_REFERENCE_TEXT FROM APPS.M4R_3A6_OE_LINE_ACKS WHERE LINK_TO_LINE_ID = :p_parent_line_id;

Because the view performs correlated lookups against OE_ORDER_LINES_ALL, queries should constrain on indexed identifiers such as REQUEST_ID, ORIG_SYS_LINE_REF, or CUSTOMER_LINE_NUMBER to avoid full scans. The view is read-only and must not be used for transactional updates; any modification to line acknowledgments should be performed against the underlying base objects through supported APIs.