[Home] [Help]
6031: --following line added for bug 3712551
6032: IF(p_line_rec.actual_shipment_date is null) THEN
6033: SELECT nvl ( max ( transaction_date ) , sysdate )
6034: INTO p_x_interface_line_rec.ship_date_actual
6035: FROM rcv_transactions t , oe_drop_ship_sources s
6036: WHERE t.po_header_id = s.po_header_id
6037: AND t.po_line_location_id = s.line_location_id
6038: AND transaction_type = 'RECEIVE'
6039: AND s.line_id = p_line_rec.line_id;
6523: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE7 := '0';
6524: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8 := '0';
6525: p_x_interface_line_rec.Reason_Code := p_line_rec.Return_Reason_Code;
6526: --Bug2302812.Commented the procedure "Get_Received_Status" and in turn we get the
6527: --Receipt date from "RCV_TRANSACTIONS".
6528: /* OE_LINE_STATUS_PUB.Get_Received_Status(p_line_id => p_line_rec.line_id, x_result=>l_rma_result, x_result_date=>l_rma_date);*/
6529: --Bug2758528-Added a check for 'RECEIVE' Transaction type.
6530:
6531: -- With the new fix we are populating the actual_shipment_date for RMAs.
6534:
6535: IF p_line_rec.actual_shipment_date IS NULL THEN
6536: SELECT max ( transaction_date ) -- Bug#3343004
6537: INTO l_rma_date
6538: FROM rcv_transactions
6539: WHERE transaction_type IN ('RECEIVE','UNORDERED')
6540: AND oe_order_line_id = p_line_rec.line_id;
6541:
6542: p_x_interface_line_rec.Ship_Date_Actual := l_rma_date;