APPS.PO_DOCUMENT_CHECKS_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 19289: FROM rcv_transactions_interface rti

19285: )
19286: AND EXISTS
19287: (
19288: SELECT 'Transaction to process'
19289: FROM rcv_transactions_interface rti
19290: WHERE rti.processing_status_code = 'PENDING'
19291: AND rti.po_header_id = poh.po_header_id
19292: );
19293:

Line 19341: FROM rcv_transactions_interface rti

19337: )
19338: AND EXISTS
19339: (
19340: SELECT 'Transaction to process'
19341: FROM rcv_transactions_interface rti
19342: WHERE rti.processing_status_code = 'PENDING'
19343: AND rti.po_release_id = por.po_release_id
19344: );
19345:

Line 19396: FROM rcv_transactions_interface rti

19392: )
19393: AND EXISTS
19394: (
19395: SELECT 'Transaction to process'
19396: FROM rcv_transactions_interface rti
19397: WHERE rti.processing_status_code = 'PENDING'
19398: AND rti.po_line_id = pol.po_line_id
19399: );
19400:

Line 19470: FROM rcv_transactions_interface rti

19466: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19467: AND EXISTS
19468: (
19469: SELECT 'Transaction to process'
19470: FROM rcv_transactions_interface rti
19471: WHERE rti.processing_status_code = 'PENDING'
19472: AND rti.po_line_location_id = poll.line_location_id
19473: );
19474:

Line 19515: FROM rcv_transactions_interface rti

19511: )
19512: AND EXISTS
19513: (
19514: SELECT 'Transaction to process'
19515: FROM rcv_transactions_interface rti
19516: WHERE rti.processing_status_code = 'PENDING'
19517: AND rti.po_line_location_id = poll.line_location_id
19518: );
19519: