APPS.RCV_RECEIPTS_QUERY_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 151: FROM rcv_transactions_interface

147: SELECT nvl(sum(primary_quantity),0),
148: decode(min(item_id),null,min(unit_of_measure),min(primary_unit_of_measure))
149: INTO x_cancel_qty,
150: primary_uom
151: FROM rcv_transactions_interface
152: WHERE transaction_status_code = 'PENDING'
153: AND transaction_type = 'CANCEL'
154: AND po_line_location_id = x_line_location_id;
155: if (x_cancel_qty = 0) then