[Home] [Help]
177: */
178:
179: /*
180: || Code changed by aiyer for the bug #3090371.
181: || Modified the cursor to get the actual_shipment_date from oe_order_lines_all instead of the
182: || conversion_date from oe_order_headers_all.
183: || As a Sales order shipment date can be different from its creation date, hence the conversion rate
184: || applicable on the date of shipment should be considerd for all processing rather than the creation
185: || date of the Sales order.
186: */
187:
188: CURSOR get_conv_detail_cur(
189: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,
190: cp_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE
191: ) IS
192: SELECT
193: order_number ,
194: transactional_curr_code ,
196: conversion_rate ,
197: b.actual_shipment_date
198: FROM
199: oe_order_headers_all a ,
200: oe_order_lines_all b
201: WHERE
202: a.header_id = b.header_id AND
203: b.line_id = cp_line_id AND
204: a.header_id = cp_order_header_id ;
434: --Anuradha Parthasarathy
435:
436: CURSOR get_actual_shipment_date(p_order_line_id NUMBER) IS
437: SELECT actual_shipment_date
438: FROM Oe_Order_Lines_All
439: WHERE line_id = p_order_line_id;
440:
441: -- added by sriram Bug # 2454978
442: v_line_amount NUMBER;
765:
766:
767: 31. 2003/09/24 Aiyer - Bug#3139718, File Version 616.5
768:
769: Modified the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
770: conversion_date from oe_order_headers_all.
771: As a Sales order shipment date can be different from its creation date, hence the conversion rate
772: applicable on the date of shipment should be considered for all processing rather than the creation
773: date of the Sales order.