APPS.RCV_GARBAGE_COLLECTOR_SV dependencies on RCV_HEADERS_INTERFACE

Line 26: rcv_headers_interface rhi

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)
30: AND NOT EXISTS (SELECT 'x'

Line 69: where exists (select 'x' from rcv_headers_interface rhi

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
70: where rhi.header_interface_id = rti.header_interface_id and
71: rhi.processing_status_code = 'RUNNING' and
72: (rhi.processing_request_id is null or
73: rhi.processing_request_id = p_request_id)) and

Line 109: update rcv_headers_interface

105: /* FPJ WMS CHANGE.
106: * We now support ROI for all the processing modes. Hence change
107: * the sql to support all modes.
108: */
109: update rcv_headers_interface
110: set processing_status_code = 'RUNNING',
111: processing_request_id = decode(p_request_id,null,null, p_request_id)
112: where processing_status_code = 'PENDING' and
113: header_interface_id = c1_rec.header_interface_id;