APPS.RCV_GARBAGE_COLLECTOR_SV dependencies on PO_HEADERS_ALL

Line 31: FROM po_headers_all poha

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'
31: FROM po_headers_all poha
32: WHERE poha.segment1 = rti.document_num)
33: AND rhi.GROUP_ID = DECODE (p_group_id, 0, rhi.GROUP_ID, p_group_id)
34: AND ( rhi.processing_request_id IS NULL
35: OR rhi.processing_request_id = p_request_id