Posted by: Edi Yanto on: January 26, 2012
The script below is used to populate the order import interface tables using data from an existing sales order. Interface Tables: OE_HEADERS_IFACE_ALL OE_LINES_IFACE_ALL OE_PRICE_ADJS_IFACE_ALL OE_PAYMENTS_INTERFACE OE_CREDITS_IFACE_ALL OE_LOTSERIALS_IFACE_ALL Base Tables: OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL OE_PRICE_ADJUSTMENTS OE_PAYMENTS OE_SALES_CREDITS OE_LOT_SERIAL_NUMBERS
Posted by: Edi Yanto on: January 20, 2012
Transact Move Order Allocating Move Order using inv_replenish_detail_pub.line_details_pub. To delete the lot allocation record use inv_trx_util_pub.delete_lot_ser_trx and to insert new lot allocation record use inv_trx_util_pub.insert_lot_trx. Transact Move Order using inv_pick_wave_pick_confirm_pub.pick_confirm. Ship Confirm Ship Confirm using wsh_deliveries_pub.delivery_action p_action_code := ‘CONFIRM’ and p_sc_action_flag := ‘S’ Note: p_sc_action_flag => Ship Confirm option – S, B, T, A, C. [...]
Posted by: Edi Yanto on: January 20, 2012
The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so the PO will be received. Records needs to be inserted into [...]
Recent Comments