Search Results ozf_sd_request_lines_all_pk

Overview

The OZF_SD_REQUEST_LINES_ALL table is a core transactional entity within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. It is owned by the OZF (Trade Management) module and is fundamental to the Ship and Debit (S&D) functionality. Ship and Debit is a channel sales program where a distributor sells a product at a reduced price and later requests a debit (rebate) from the manufacturer. This table specifically stores the detailed line-level information for each S&D request submitted. Each record represents a distinct product or item for which a price concession is being sought, linked to a parent request header. Its role is to persist all line-specific attributes, quantities, pricing, and statuses necessary for processing, approving, and fulfilling debit claims.

Key Information Stored

The table's primary purpose is to capture the item details of a Ship and Debit request. The most critical column is REQUEST_LINE_ID, which serves as the unique primary key identifier for each request line. While the full column list is not detailed in the provided metadata, based on its function, the table typically stores data such as the associated REQUEST_HEADER_ID (linking to the parent request), INVENTORY_ITEM_ID, REQUESTED_QUANTITY, UNIT_SELLING_PRICE, and the calculated DEBIT_AMOUNT. It also holds status columns to track the line's progression through the workflow (e.g., from 'DRAFT' to 'APPROVED' to 'PROCESSED'), and likely includes columns for reason codes, customer ship-to information, and references to the original sales order line.

Common Use Cases and Queries

This table is central to reporting and operational processes within Trade Management. Common use cases include generating reports on S&D line activity by product, customer, or status; auditing pending and approved debit amounts; and providing data for reconciliation with financial systems. A frequent query pattern involves joining to the header table to retrieve a complete request view. For example, to find all approved request lines for a specific item, a query might be:

• SELECT rl.request_line_id, rl.inventory_item_id, rl.requested_quantity, rl.debit_amount, rh.request_number FROM ozf_sd_request_lines_all rl, ozf_sd_requests_all rh WHERE rl.request_header_id = rh.request_header_id AND rl.status = 'APPROVED' AND rl.inventory_item_id = :p_item_id;

Technical consultants often query this table to debug request processing issues or to build custom interfaces for loading S&D request data.

Related Objects

The OZF_SD_REQUEST_LINES_ALL table exists within a key relational structure. Its primary key, REQUEST_LINE_ID, is enforced by the index OZF_SD_REQUEST_LINES_ALL_PK. The most critical relationship is a foreign key to the parent header table, OZF_SD_REQUESTS_ALL, via the REQUEST_HEADER_ID column. This links each line to its overarching request. Lines are also commonly joined to inventory tables (e.g., MTL_SYSTEM_ITEMS_B) via INVENTORY_ITEM_ID to get item details, and to customer tables (e.g., HZ_CUST_ACCOUNTS) for customer information. Other related objects may include the OZF_SD_CREDIT_LINES_ALL table, which holds the resulting credit memos generated from approved debit requests.