APPS.RCV_RETURN_SV dependencies on RCV_TRANSACTIONS

Line 219: FROM rcv_transactions rt

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

Line 229: FROM rcv_transactions rt

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

Line 242: FROM rcv_transactions_interface rti

238: rti.primary_quantity * -1,
239: rti.primary_quantity )
240: ),0)
241: INTO x_primary_interface_qty
242: FROM rcv_transactions_interface rti
243: WHERE rti.parent_transaction_id = x_transaction_id
244: AND rti.processing_status_code = 'PENDING'
245: AND rti.transaction_status_code = 'PENDING';
246: /*

Line 278: FROM rcv_transactions_interface rti

274: ** Determine the sum of the transactions in the interface table
275: */
276: SELECT nvl(sum(rti.primary_quantity),0)
277: INTO x_primary_interface_qty
278: FROM rcv_transactions_interface rti
279: WHERE rti.parent_transaction_id = x_transaction_id
280: AND rti.processing_status_code = 'PENDING'
281: AND rti.transaction_status_code = 'PENDING';
282: /*