DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1493: FROM rcv_transactions_interface RTI, po_line_locations_all PLL

1489: INTO l_pending_rcv_transactions
1490: FROM dual
1491: WHERE EXISTS
1492: ( SELECT 1
1493: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1494: WHERE PLL.po_line_id = p_po_line_id
1495: AND RTI.po_line_location_id = PLL.line_location_id -- JOIN
1496: AND RTI.transaction_status_code = 'PENDING' );
1497:

Line 1713: FROM rcv_transactions_interface RTI

1709: INTO l_pending_rcv_transactions
1710: FROM dual
1711: WHERE EXISTS
1712: ( SELECT 1
1713: FROM rcv_transactions_interface RTI
1714: WHERE RTI.po_line_location_id = p_line_location_id
1715: AND RTI.transaction_status_code = 'PENDING' );
1716:
1717: IF (l_pending_rcv_transactions > 0) THEN