DBA Data[Home] [Help]

APPS.FV_SLA_PROCESSING_PKG dependencies on RCV_TRANSACTIONS

Line 2370: SELECT sum(quantity) INTO l_returned_quantity_net FROM RCV_TRANSACTIONS

2366: l_fv_extract_detail(l_index).net_pya_adj_amt:= l_po_dist_info_rec.quantity_delivered -
2367: l_po_dist_info_rec.quantity_ordered;
2368: END IF;
2369: ELSIF l_get_event_code_rec.event_type_code = 'RETURN_TO_RECEIVING' THEN
2370: SELECT sum(quantity) INTO l_returned_quantity_net FROM RCV_TRANSACTIONS
2371: WHERE po_header_id = l_rcv_extract_header_rec.po_header_id
2372: AND po_distribution_id = l_rcv_extract_header_rec.po_distribution_id;
2373:
2374: IF l_returned_quantity_net > l_po_dist_info_rec.quantity_ordered THEN