APPS.RCV_RETURN_SV dependencies on RCV_TRANSACTIONS

Line 220: FROM rcv_transactions rt

216: ** Sum the total of the children transactions that are not corrections.
217: */
218: SELECT nvl(sum(rt.primary_quantity), 0)
219: INTO x_primary_child_qty
220: FROM rcv_transactions rt
221: WHERE rt.parent_transaction_id = x_transaction_id
222: AND rt.transaction_type <> 'CORRECT';
223:
224: x_progress := 20;

Line 230: FROM rcv_transactions rt

226: ** Sum the total of the children transactions that are corrections.
227: */
228: SELECT nvl(sum(rt.primary_quantity), 0)
229: INTO x_primary_child_qty_correct
230: FROM rcv_transactions rt
231: WHERE rt.parent_transaction_id = x_transaction_id
232: AND rt.transaction_type = 'CORRECT';
233:
234: x_progress := 30;

Line 243: FROM rcv_transactions_interface rti

239: rti.primary_quantity * -1,
240: rti.primary_quantity )
241: ),0)
242: INTO x_primary_interface_qty
243: FROM rcv_transactions_interface rti
244: WHERE rti.parent_transaction_id = x_transaction_id
245: AND rti.processing_status_code in ('PENDING' , 'WSH_INTERFACED') -- rtv vidya
246: AND rti.transaction_status_code = 'PENDING'
247: -- rtv project : start

Line 286: FROM rcv_transactions_interface rti

282: ** Determine the sum of the transactions in the interface table
283: */
284: SELECT nvl(sum(rti.primary_quantity),0)
285: INTO x_primary_interface_qty
286: FROM rcv_transactions_interface rti
287: WHERE rti.parent_transaction_id = x_transaction_id
288: AND rti.processing_status_code = 'PENDING'
289: AND rti.transaction_status_code = 'PENDING';
290: /*