APPS.RCV_GARBAGE_COLLECTOR_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 25: FROM rcv_transactions_interface rti,

21: -- Bug 3549318 added or condition to collect rows with no source id specified
22: CURSOR c1 IS
23: SELECT rhi.header_interface_id,
24: COUNT (rti.interface_transaction_id) error_count
25: FROM rcv_transactions_interface rti,
26: rcv_headers_interface rhi
27: WHERE rhi.header_interface_id = rti.header_interface_id
28: AND rhi.processing_status_code = 'PENDING'
29: AND (rti.document_num IS NOT NULL OR rti.oe_order_num IS NOT NULL)

Line 55: -- Mark all rcv_transactions_interface rows to RUNNING that have the

51: begin
52: -- For Bug 2367174
53: -- Part 1
54:
55: -- Mark all rcv_transactions_interface rows to RUNNING that have the
56: -- the header_interface_row set to RUNNING so all the
57: -- transaction_interface rows get picked up.
58:
59: -- An ASN with multiple OU POs will thus be not supported.

Line 65: update rcv_transactions_interface rti

61: /* FPJ WMS CHANGE.
62: * We now support ROI for all the processing modes. Hence change
63: * the sql to support all modes.
64: */
65: update rcv_transactions_interface rti
66: SET rti.processing_status_code = 'RUNNING',
67: rti.processing_request_id =decode(p_request_id,null,null,
68: p_request_id)
69: where exists (select 'x' from rcv_headers_interface rhi

Line 92: from rcv_transactions_interface rti

88: for c1_rec in c1 loop
89:
90: select count(*)
91: into v_total_count
92: from rcv_transactions_interface rti
93: where
94: rti.header_interface_id = c1_rec.header_interface_id;
95:
96: if c1_rec.error_count = v_total_count then

Line 121: update rcv_transactions_interface

117: /* FPJ WMS CHANGE.
118: * We now support ROI for all the processing modes. Hence change
119: * the sql to support all modes.
120: */
121: update rcv_transactions_interface
122: SET processing_status_code = 'RUNNING',
123: processing_request_id = decode(p_request_id,null,null,
124: p_request_id)
125: WHERE processing_status_code = 'PENDING'