Results for “rma_header_id”

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

Overview

JAI_OM_OE_RMA_LINES is an Oracle E-Business Suite table owned by the JA schema and delivered as part of the Asia/Pacific Localizations (JA) product family. It stores the line-level details of return orders (RMAs) processed through Oracle Order Management. Whereas the parent header record captures order-level attributes, this table holds the individual return lines, including the returned inventory item, quantity, pricing, tax categorization, and the associated tax amounts that are required for GST, excise, and other statutory reporting obligations common to the Asia/Pacific region.

Under a heuristic Data Vault classification derived from its foreign key structure, JAI_OM_OE_RMA_LINES is satellite-leaning. It functions primarily as a descriptive child of the order header, carrying attributes that describe the transactional context of each return line and referencing multiple surrounding entities.

Key Information Stored

The table contains 43 documented columns. The surrogate primary key is RMA_LINE_ID, enforced by the unique index JAI_OM_OE_RMA_LINES_PK. The most operationally significant columns include:

• RMA_LINE_ID — Surrogate primary key uniquely identifying each return line.
• RMA_LINE_NUMBER and RMA_NUMBER — Business-facing line and header references used in user and reporting contexts.
• RMA_HEADER_ID — Foreign key linking the line to its return order header in OE_ORDER_HEADERS_ALL.
• INVENTORY_ITEM_ID — The item being returned.
• QUANTITY and UOM — Returned quantity and unit of measure.
• SELLING_PRICE — Line selling price used for valuation and credit calculation.
• TAX_CATEGORY_ID — Foreign key to JAI_CMN_TAX_CTGS_ALL defining the applicable tax regime.
• TAX_AMOUNT, ASSESSABLE_VALUE, and GST_ASSESSABLE_VALUE — Tax and statutory valuation amounts for GST and related calculations.
• EXCISE_DUTY_RATE and RATE_PER_UNIT — Duty and rate attributes supporting excise determination.
• RECEIVED_FLAG — Indicates whether the returned goods have been received.
• PICKING_LINE_ID and DELIVERY_DETAIL_ID — Foreign keys tying the line to SO_PICKING_LINES_ALL and WSH_DELIVERY_DETAILS respectively.
• ALLOW_EXCISE_CREDIT_FLAG and ALLOW_SALES_CREDIT_FLAG — Flags governing credit eligibility.
• SHIP_TO_ORG_ID and SERVICE_TYPE_CODE — Destination and service classification attributes.

Fifteen generic ATTRIBUTE columns plus ATTRIBUTE_CATEGORY provide extensibility, while standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER support auditing and optimistic locking.

Common Use Cases and Queries

Typical reporting scenarios include extracting return line details joined to the order header for RMA reconciliation, computing taxable values per return, and tracing returned quantities against deliveries and pick confirmations. A representative query joining header and line data follows:

• SELECT l.rma_line_id, l.rma_number, l.rma_line_number, l.inventory_item_id, l.quantity, l.uom, l.tax_amount, l.gst_assessable_value FROM jai_om_oe_rma_lines l JOIN oe_order_headers_all h ON h.header_id = l.rma_header_id WHERE l.received_flag = 'Y';
• Tax analysis joining TAX_CATEGORY_ID to JAI_CMN_TAX_CTGS_ALL for jurisdiction-level reporting.
• Credit eligibility review using ALLOW_EXCISE_CREDIT_FLAG and ALLOW_SALES_CREDIT_FLAG.
• Cross-referencing returns to physical movement via PICKING_LINE_ID and DELIVERY_DETAIL_ID.

Related Objects

The table participates in an extensive referential network. Parent references include OE_ORDER_HEADERS_ALL (via RMA_HEADER_ID), JAI_CMN_TAX_CTGS_ALL (via TAX_CATEGORY_ID), WSH_DELIVERY_DETAILS (via DELIVERY_DETAIL_ID), and SO_PICKING_LINES_ALL (via PICKING_LINE_ID). Child tables that reference RMA_LINE_ID include JAI_OM_OE_RMA_TAXES, MTL_MATERIAL_TRANSACTIONS, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_SO_RMA_INTERFACE, MTL_COGS_RECOGNITION_TEMP, CS_REPAIRS_ALL, CS_ESTIMATE_DETAILS, CST_MARGIN_SUMMARY, CST_MARGIN_TEMP, CST_BIS_MARGIN_SUMMARY, WMS_CARTONIZATION_TEMP, and WMS_MATERIAL_TXN_TRACE. These relationships make the table central to RMA financial recognition, costing, and inventory traceability.