Results for “product_transfer_movement_type”

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

Overview

OZF_RESALE_LINES_ALL is the transactional detail table within Oracle Trade Management (OZF) that stores chargeback line information. In Oracle EBS 12.1.1 and 12.2.2, it functions as the line-level counterpart to OZF_RESALE_HEADERS_ALL, capturing the individual resale/chargeback transactions processed against trade promotion and channel rebate agreements. Each row represents a single resale line documenting a product transfer between trading partners, enriched with party, pricing, item, and sourcing details used to calculate and validate chargeback claims.

From a Data Vault modeling perspective, the heuristic classification for this table is satellite-leaning. The presence of a single-column surrogate primary key (RESALE_LINE_ID) alongside multiple foreign keys — RESALE_HEADER_ID, BILL_TO_CUST_ACCOUNT_ID, SHIP_TO_CUST_ACCOUNT_ID, and others — suggests the table acts as an aggregated descriptive satellite attached to parent hubs such as customers, inventory items, and resale headers, rather than as a pure hub or link. This classification is offered as a modeling suggestion, and the table's 194 columns reinforce its role as a wide descriptive structure.

Key Information Stored

The documented schema contains 194 columns. The most operationally significant among them include:

• RESALE_LINE_ID — the surrogate primary key, defined by unique index OZF_RESALE_LINES_ALL_U1 and enforced by constraint OZF_RESALE_LINES_ALL_PK.
• RESALE_HEADER_ID — foreign key to OZF_RESALE_HEADERS_ALL, linking each line to its parent chargeback transaction.
• BILL_TO_CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID, SHIP_TO_CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID — party and site references into HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL, capturing the billing and shipping relationships for the resale.
• END_CUST_PARTY_ID, END_CUST_PARTY_NAME, END_CUST_LOCATION — end-customer identification, essential for direct and indirect channel chargeback attribution.
• INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, UPC_CODE, and the INVENTORY_ITEM_SEGMENT1 through SEGMENT20 flexfield columns — item identity and descriptive attributes.
• QUANTITY, UOM_CODE, PURCHASE_UOM_CODE — resale quantities and units of measure.
• SELLING_PRICE, ACCTD_SELLING_PRICE, PURCHASE_PRICE, ACCTD_PURCHASE_PRICE — pricing basis for chargeback computation.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE — currency conversion context.
• ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_LINE_REFERENCE, ORIG_SYSTEM_ITEM_NUMBER — source-system traceability for imported resale data.
• ORG_ID and SECURITY_GROUP_ID — multi-org and security group partitioning.
• STATUS_CODE and PRODUCT_TRANSFER_MOVEMENT_TYPE — processing status and transfer classification.

Common Use Cases and Queries

Typical uses include chargeback validation, resale reporting by customer or item, and reconciliation of incoming resale feeds against open claims. A common query joins lines to headers and customer accounts:

SELECT l.resale_line_id, l.resale_header_id, h.resale_number,
       l.bill_to_cust_account_id, l.quantity, l.selling_price
FROM   ozf_resale_lines_all l,
       ozf_resale_headers_all h
WHERE  l.resale_header_id = h.resale_header_id
AND    l.org_id = :p_org_id;

Reporting often aggregates resale quantities by INVENTORY_ITEM_ID or END_CUST_PARTY_ID to measure indirect sales, or joins to OZF_RESALE_ADJUSTMENTS_ALL to net adjustments against a given line.

Related Objects

• OZF_RESALE_HEADERS_ALL — parent table; joined on RESALE_HEADER_ID.
• OZF_RESALE_ADJUSTMENTS_ALL — child table referencing RESALE_LINE_ID, storing line-level adjustments.
• OZF_RESALE_BATCH_LINE_MAPS_ALL — maps batch transactions to resale lines via RESALE_LINE_ID.
• HZ_CUST_ACCOUNTS — source of bill-to and ship-to customer references.
• HZ_CUST_SITE_USES_ALL — source of bill-to and ship-to site use references.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data security partitioning.