[Home] [Help]
6276: --following line added for bug 3712551
6277: IF(p_line_rec.actual_shipment_date is null) THEN
6278: SELECT nvl ( max ( transaction_date ) , sysdate )
6279: INTO p_x_interface_line_rec.ship_date_actual
6280: FROM rcv_transactions t , oe_drop_ship_sources s
6281: WHERE t.po_header_id = s.po_header_id
6282: AND t.po_line_location_id = s.line_location_id
6283: AND transaction_type = 'RECEIVE'
6284: AND s.line_id = p_line_rec.line_id;
6796: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE7 := '0';
6797: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE8 := '0';
6798: p_x_interface_line_rec.Reason_Code := p_line_rec.Return_Reason_Code;
6799: --Bug2302812.Commented the procedure "Get_Received_Status" and in turn we get the
6800: --Receipt date from "RCV_TRANSACTIONS".
6801: /* 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);*/
6802: --Bug2758528-Added a check for 'RECEIVE' Transaction type.
6803:
6804: -- With the new fix we are populating the actual_shipment_date for RMAs.
6807:
6808: IF p_line_rec.actual_shipment_date IS NULL THEN
6809: SELECT max ( transaction_date ) -- Bug#3343004
6810: INTO l_rma_date
6811: FROM rcv_transactions
6812: WHERE transaction_type IN ('RECEIVE','UNORDERED')
6813: AND oe_order_line_id = p_line_rec.line_id;
6814:
6815: p_x_interface_line_rec.Ship_Date_Actual := l_rma_date;