Apply Deal Discounts to Purchase Orders (orddscnt)

Module Name

orddscnt.pc

Description

Apply Deal Discounts to Purchase Orders

Functional Area

Purchase Orders

Module Type

Business Processing

Module Technology

ProC

Catalog ID

RMS283

Wrapper Script

rmswrap_multi.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This module applies deals to a purchase order by calculating the discounts and rebates that are applicable to a purchase order. It will fetch orders that need to be recalculated for cost from the DEAL_CALC_QUEUE table. Using the dealordlib shared library, it will update the unit cost and populate the ORDLOC_DISCOUNT and ORDHEAD_DISCOUNT tables.

Restart/Recovery

This program has inherent restart ability, since records are deleted from deal_calc_queue as they are processed. Recommended maximum commit counter is low.

Design Assumptions

N/A