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:
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