APPS.RCV_QUANTITIES_S dependencies on WSH_DELIVERY_DETAILS

Line 2642: AND exists ( select 1 from wsh_delivery_details wdd

2638: FROM rcv_transactions_interface rti
2639: WHERE parent_transaction_id = p_transaction_id
2640: AND processing_status_code = 'RUNNING'
2641: AND transaction_type IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING')
2642: AND exists ( select 1 from wsh_delivery_details wdd
2643: where wdd.delivery_detail_id = rti.interface_source_line_id
2644: and wdd.source_code = 'RTV');
2645:
2646: x_interface_quantity := x_interface_quantity - x_rtv_running_qty;

Line 2698: AND exists ( select 1 from wsh_delivery_details wdd

2694: FROM rcv_transactions_interface rti
2695: WHERE parent_transaction_id = p_transaction_id
2696: AND processing_status_code = 'RUNNING'
2697: AND transaction_type IN ('RETURN TO VENDOR', 'RETURN TO RECEIVING')
2698: AND exists ( select 1 from wsh_delivery_details wdd
2699: where wdd.delivery_detail_id = rti.interface_source_line_id
2700: and wdd.source_code = 'RTV');
2701:
2702: x_secondary_interface_qty := x_secondary_interface_qty - (2 * x_rtv_running_sec_qty);