DBA Data[Home] [Help]

APPS.WSH_SC_DEL_LINES_PVT dependencies on SO_FREIGHT_CHARGES

Line 50: -- and delete rows from so_freight_charges also.

46: IF (( original_detail_id > 0) AND
47: ( so_reservations = 'Y')) THEN
48: -- call transaction manager for demand / reservation transfer
49: -- The transfer routine need to update so_picking_line_details
50: -- and delete rows from so_freight_charges also.
51: -- but we raise a exception for now
52:
53: transfer_qty := 0;
54: OPEN c1( pld_id);

Line 86: DELETE FROM so_freight_charges

82: load_seq_number = NULL
83: -- transaction_temp_id = NULL
84: WHERE picking_line_detail_id = pld_id;
85:
86: DELETE FROM so_freight_charges
87: WHERE delivery_id = del_id
88: AND picking_line_detail_id = pld_id;
89:
90: COMMIT;