[Home] [Help]
172: */
173:
174: /*
175: || Code changed by aiyer for the bug #3090371.
176: || Modified the cursor to get the actual_shipment_date from oe_order_lines_all instead of the
177: || conversion_date from oe_order_headers_all.
178: || As a Sales order shipment date can be different from its creation date, hence the conversion rate
179: || applicable on the date of shipment should be considerd for all processing rather than the creation
180: || date of the Sales order.
181: */
182:
183: CURSOR get_conv_detail_cur(
184: cp_order_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE ,
185: cp_line_id OE_ORDER_LINES_ALL.LINE_ID%TYPE
186: ) IS
187: SELECT
188: order_number ,
189: transactional_curr_code ,
191: conversion_rate ,
192: b.actual_shipment_date
193: FROM
194: oe_order_headers_all a ,
195: oe_order_lines_all b
196: WHERE
197: a.header_id = b.header_id AND
198: b.line_id = cp_line_id AND
199: a.header_id = cp_order_header_id ;
421: --Anuradha Parthasarathy
422:
423: CURSOR get_actual_shipment_date(p_order_line_id NUMBER) IS
424: SELECT actual_shipment_date
425: FROM Oe_Order_Lines_All
426: WHERE line_id = p_order_line_id;
427:
428: -- added by sriram Bug # 2454978
429: v_line_amount NUMBER;
737:
738:
739: 31. 2003/09/24 Aiyer - Bug#3139718, File Version 616.5
740:
741: Modified the cursor get_conv_detail_cur to get the actual_shipment_date from oe_order_lines_all instead of the
742: conversion_date from oe_order_headers_all.
743: As a Sales order shipment date can be different from its creation date, hence the conversion rate
744: applicable on the date of shipment should be considered for all processing rather than the creation
745: date of the Sales order.