1499: INTO l_pending_rcv_transactions
1500: FROM dual
1501: WHERE EXISTS
1502: ( SELECT 1
1503: FROM rcv_transactions_interface RTI, po_line_locations_all PLL
1504: WHERE PLL.po_line_id = p_po_line_id
1505: AND RTI.po_line_location_id = PLL.line_location_id -- JOIN
1506: AND RTI.transaction_status_code = 'PENDING' );
1507:
1719: INTO l_pending_rcv_transactions
1720: FROM dual
1721: WHERE EXISTS
1722: ( SELECT 1
1723: FROM rcv_transactions_interface RTI
1724: WHERE RTI.po_line_location_id = p_line_location_id
1725: AND RTI.transaction_status_code = 'PENDING' );
1726:
1727: IF (l_pending_rcv_transactions > 0) THEN